Pulling data from a subreport

[slickp007]

Crystal 11

I have a sub report in my report and would like to pull the premium field from this report to get the percentage difference to the premium field in my main report. But i'm not sure how to do this. I've looked on the help about shared variables, would i have to use one of these?

 

[lbass]

Yes. Create a formula in your subreport like:

whileprintingrecords;
shared numbervar prem := {table.premium};//or whatever summary you are using.

Add this formula to the sub report footer. Then in the main report, in a section below the one in which the sub is located, e.g., in GFb if the sub is in GFa, you can reference the variable in a formula something like this:

whileprintingrecords;
shared numbervar prem;
({table.prem}-prem)%{table.prem}

-LB

 

[slickp007]

Cheers thank you very much for the quick response. i should have really searched for it because i found my answer in another thread, but thanks all the same!!