Subreport data

[Djbell]

Hi All

I have a formula on a Subreport thats works out a calculation, how can I get the result of this formula passed to my main report so that I can use the result in a formula on the main report.

Regards

Douglas Bell

 

[lupins46]

You declare a common shared variable in the main report and subreport and in the subreport you use a formula field to put the value you want to pass into the variable and in the main report you have another formula field which gets the value.
Shared variables are described in detail in Help.

The formula 'putting' the value must come earlier in the report than the formula 'getting' the value.

 

[Madawc]

To pass data back from a subreport, use a shared variable. For a date, put a formula field in the subreport like

Shared dateVar 
V_Today := {LoadStatus.LastDLoad}

To access it in the main report, create another formula field with

Shared dateVar 
V_Today := V_Today

If it was a currency value, you'd do it differently, e.g.

whileprintingrecords;
shared currencyvar SumSaved;
SumSaved:={#TotSaved};
SumSaved

And to access it in the main report, create another formula field with

whileprintingrecords;
shared currencyvar SumSaved;
SumSaved

Note that the shared variable is only available in the section after the section which contains the subreport.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10