StoreVar and FetchVar Functions in CR 2008

[yosteevo]

I am using Crystal Reports 2008.

I need to assign the calculated value of a formula to a Shared Variable that is configured within a subreport that is configured in a main report.

I then want to have the ability to recall the value of my formula calculation contained in my subreport in order to use that variable's value in other formulas in my main report.

(Similar to StoreVar and FetchVar Functions from earlier versions of Crystal Reports)



I have succeeded in creating a formula that assigns a value to a Variable within my subreport with the following syntax:

Shared NumberVar Ring1_AV_Store_Calculation;
Ring1_AV_Store_Calculation := {@AV Calculation for Both S1_S2}



Now I need help with the syntax and the process that fetches the value into the main report.
I have come across StoreVar and FetchVar Function tutorials online but they no longer work in Crystal Reports 2008.


Thanks
Stephen

 

[pmax9999]

Add WhilePrinting records to the first line of your subreport formula as follows:

WhilePrintingRecords;
Shared NumberVar Ring1_AV_Store_Calculation;
Ring1_AV_Store_Calculation := {@AV Calculation for Both S1_S2}

Then in your main report wherever you want to use that value from the subreport, add the following lines to the beginning of each formula:

WhilePrintingRecords;
Shared NumberVar Ring1_AV_Store_Calculation;

You can then perform whatever calculation upon want on that variable.

Remember, the variable won't be available in the main report until a section below the subreport, and the variable must be declared in every formula it is used.

Hope this helps.

Cheers
Pete

 

[yosteevo]

Thanks Pete,

I did have the correct syntax.
I just needed to import another copy of my subreport in my main report's header and suppress all the sections within the subreport copy.



Stephen