Use Subreport field in GrandTotal

[elibb]

hi, i have a report in CR9, im using it with a VB6.0 application.
in main report i have a subreport, that has a grand total field, and in my main report i also have a grand total field, but i need another field that will display the grandtotal in the main report minus the grandtotal of the subreport.. how can do i that??
how can i get the grandtotal value of the subreport??

thank you very much

Eli

 

[cmpgeek]

try this:

in the subreport add a formula for a shared variable:
shared numbervar GTsubreport:= {@GTofsubrprt)

in the main report add this formula:
shared numbervar GTsubreport;

then add another formula in the main report to get the GT you really want:

{mainreportGT} - {@variablefromsubreport}

(i am not promising anything; but i did something close to this a few days ago and it worked great (thank to these great people of course!)

good luck

 

[elibb]

thank you very much, it worked perfect

Eli