Need Grand Total of Sub reports

[hormaz]

Hi,
In my report there are 4 city wise subreports which give respective balances.
Scenario;
In all subreports there will be multiple city wise totals such as BOMBAY, DELHI..etc
I need all those balances in a grand total. Kindly help

 

[lbass]

Please explain in what report sections the subreports are located. How are they linked to the main report (if they are linked)?

You say that there are multiple totals within each subreport--what are they? Are you expecting to get multiple grand totals or just one? This is hard to visualize.

You can pass shared variables to a section in the main report below the one in which a subreport is located, so you could create a shared variable in each sub like this (changing the name of each variable, e.g., to y, z):

whileprintingrecords;
shared numbervar x := sum({table.amt});

Then in the main report (lower section), you could add a formula like this:

whileprintingrecords;
shared numbervar x;
shared numbervar y;
shared numbervar z;
x+y+z

-LB

 

[hormaz]

There is no main report. There are 4 subreports. The multiple totals are sum of each city.

 

[lbass]

The suggestion I gave you should work fine. If you want more help you would need to respond to my earlier questions.

-LB