Pass a subtotal back to the main report

[sjjustina]

I have a subtotal in the report footer of a subreport. I also want to print that subreport on the main report in a report footer. Can I assign it to a variable to return to the main report? And if so how?

Thanks, Sarah

 

[lbass]

Please explain in what report section your subreport is located, and what you want to see in the report footer--is it just one value or a set of values?

-LB

 

[sjjustina]

The subreport is in the main report's report footer and it's just one value that I need to return. Thanks.

 

[lbass]

Okay, then just create a formula like this:

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

Place this formula on the subreport. Then you can reference it in a section below the one in which the subreport is located, e.g., report footer_b, by using a formula:

whileprintingrecords;
shared numbervar yoursubtotal; //display only

Or for a calculation:

whileprintingrecords;
shared numbervar yoursubtotal;
yoursubtotal * .05 //sample calculation using the shared variable

-LB

 

[sjjustina]

Thanks, how do I capture the subtotal into the variable? It's a sum total. Thanks.

 

[lbass]

That's what this is:

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

Substitute your actual subtotal for sum({table.amt}).

-LB

 

[sjjustina]

Thanks, that did it.