Sum in sub reports

[nb4884]

Hi All,

Have a question on sub-reports, not sure if I can do something like this:

FOr eg if I have 3 subreports (1,2,3), placed next to each other in a main report.

Is it possible to create a column in Main report that would be the sum of columns from 3 sub reports. Ie if I have a column A in subreport 1 , column B in subreport 2 and column C in subreport 3.

How to do A.1 + B.2+ C.3 to get a column D in main report.

Thanks

Thanks

 

[Madawc]

To pass data back from a subreport, use a shared variable. 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.

In your case it might be best to use three sets of variables and add them.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

You can pass the three amounts by setting them up as shared variables in the subreports as Madawc suggests. Then reference them in a section below the one containing the subreports:

whileprintingrecords;
shared currencyvar SumSaved;
shared currencyvar SumSavedB;
shared currencyvar SumSavedC;
SumSaved+SumSavedB+SumSavedC

If they are numbers, not currencies, use numbervar in all formulas.

You can place on the right side of the page and then format the previous section (containing the subs) to "underlay following sections" if you want the sums from the subs to display next to the overall summary.

-LB