sub report total

[Former Member]

Is there a way of adding a total in the main report to a total in a sub report with the result shown in the main report? 

[abhilash_kumar · Accepted solution]

Hi Susan,

Yes, using shared variables.

E.g: The formula in the Main Report would be:

shared numbervar x;

x := x + {@Total_field};

Formula inside the Subreport would be:

shared numbervar x;

x := x + {@Total_field_in_Subreport};

Finally, the Grand Total formula on the Main Report would be:

shared numbervar x;

The Final Total should be in a section 'below' the section that holds the Subreport.

-Abhilash

[Former Member · Accepted solution]

many thanks for your prompt response - I will try it!