Setting a Remote Desktop Connection (RDC) on Windows XP and Windows Vista

Intro

Remote desktop allows you to access a computers desktop from a remote location using another PC, Mobile phone, PDA. You can access from any of these devices as long as you make the correct settings. In the case of a PC or laptop accessing the remote machine (another computer), it is very simple to set this up. However if you want to access using mobile phone you will need to set the RDC connection to show up on a web browser.

First I'll show you the simple way using PC to connect and then I'll go on to using a mobile phone to connect using a web browser.

PC (or laptop) to PC Remote Connection

Obtain:
IP Address
Computers Name

Change Routing Information (Port Forwarding)



First Step: Obtain IP Address

In order to make a connection to the remote server you will need to obtain IP address. There are several ways to obtain IP address. One way is to use command prompt and using the ipconfig command will bring up the IP address of the computer. Another way is to get the IP address by typing "my ip" on Google. If you use the command prompt and you have a router which send the internet connection to remote server then you will get a local IP address. This will probably look something like 192.168.x.x or 10.x.x.x and it really depends what kind of router is installed. If you are obtaining IP address from a website that will give you the IP address of your router.

In the case of a direct connection, I mean if you don't use a router to get internet connection, it is easier to make Remote Desktop Connection (RDC) work. You will have to

However, if you have a router you will have to change the port forwarding settings on your router. Port 3389 is used for RDC

Problem Showing Shared Variable or Value into Bar Chart / Bar Graph (Crystal Reports 9)

Problem Showing Shared Variable or Value into Bar Chart / Bar Graph


(I am using Crystal Reports 9 in Windows XP)

Hi Everyone,

I am having a problem showing a shared variable into main reports graph / chart. The shared variable is obtained from the subreport. I used the Get and Set terminology in the formulas. The Set formula is setup in the subreport and the Get is setup in the main report.

The value actually shows on the main report when placed somewhere after the subreport, however, it does not show anything on the Graph.

The following are the methods I am using in Subreport and Main Report:

Set Formula:
*********************************************************** *******
//@SetFirstReviewTotalAverage is placed in subreport.

WhilePrintingRecords;
Shared numberVar FirstReviewTotalAverage;
FirstReviewTotalAverage := {#RAvgTotal};
*********************************************************** *******

Get Formula:
*********************************************************** *******
//@GetFirstReviewTotalAverage is placed in main report.

WhilePrintingRecords;
Shared numberVar FirstReviewTotalAverage;
FirstReviewTotalAverage;
*********************************************************** *******

I tried changing the GetFirstReviewTotalAverage formula to replace with an integer and it shows up on the graph. However it does not show when I put the code as shown above in the GetFirstReviewTotalAverage formula.

Changed Get Formula - It shows a bar with value 5 on graph:
*********************************************************** *******
//@GetFirstReviewTotalAverage is placed in main report.

5;
*********************************************************** *******

Kind Regards,

M. Asif Ashrafi
Software Developer


Got an answer, working on it.

I have got the answer from experts at www.expert-exchange.com. I got a reply within 45 minutes after posting the problem question. I'm working on the solution that was provided.

Please visit the following link to see for your self.

www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_22887107.html

M. Asif Ashrafi
Software Developer
(Please visit my Blog: http://socomputers.blogspot.com/)


Report works, YES!

The simple way to show a graph on the report is to make a sub-report and send values to it. The graph will be generated on the sub-report and will be shown on the main report once run.

In my case I generated two sub-reports and they passed values to the main report. These values would show up on the main report but a graph would not generate. Thats why I created another subreport and sent it the two values that I obtained from the other two sub reports. These values were sent by setting up a link to the newly created sub report.

Lets call the newly created sub-report SubChart and call the other two subreports SubFirst and SubSecond. And lets call the values sent by SubFirst and SubSecond "FirstValue" and "SecondValue" respectively. Please look at the little diagram below to see a full picture of these reports.

Having three subreports on the Main report we can continue our conversation. Now, the Main report sends FirstValue and SecondValue to SubChart. In the SubChart I created a graph in the Footer section using the Chart Expert. The On Change Of field includes a formula which has no code in it (empty - well in my case I wanted it to be empty). The Show Value field will have the FirstValue and SecondValue.

Back on the SubChart, I have another formula which is named Printer. The Printer allows the graph to print. The Printer formula only had one line of code and it was {Table.Field}, where Table is a name of the table you are using in Main report and the Field is a field from that table. The Printer formula somehow works along with the graph. If you remove the Printer formula the graph would disappear.

In my opinion the Printer formula refreshes the values FirstValue and SecondValue on the graph. The Printer formula has to be placed on the Detail or Footer section of the SubChart report. You can supress the Printer formula because it may not be need along with the graph.

Now the graph works fine.


MAIN REPORT
____________

SubFirst
SubSecond
FirstValue
SecondValue

SubChart
____________



SUBCHART
____________

FirstValue
SecondValue
Printer
OnChangeOf
____________



If you are having a problem with your report please send me an e-mail: asifashrafi@hotmail.com



M. Asif Ashrafi
Software Developer