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