Running total

[crystalbeginner15]

I am using CR11

can we access the running totals from one subreport to other subreport I know we can access the variables by declaring them shared.

 

[synapsevampire]

No, you need to use shared variables to pass them back and forth.

-k

 

[Madawc]

To expand on what synapsevampire correctly said:

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.

Passing data TO a subreport is done using Supreport Links under edit. Note that it will want to link to a field and will generate a rule in the subreport's Record Selection on the basis of the link. You can remove the rule if you don't want it.

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