how to pull sub-total value from sub-report and use in main report?

[Lnxvas]

using CR2008
i created a report which has a subreport.

in supreport i have sub-total for 1 column and i have to use this value in main report to calculate the total.

how do i get the value from subreport to use in the main report?

can anyone help?

Thanks a bunch.

 

[lbass]

Set the value in the subreport to a shared variable, which is placed in the subreport footer, as in:

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

Then in the main report, in a section below the one containing the subreport, reference the variable and use it in your calculation (sample calculation follows).

whileprintingrecords;
shared numbervar x;
x/{table.otheramt}

If your subreport is in a group section, you will likely need to set up a reset formula to place in the group footer:

whileprintingrecords;
shared numbervar x := 0;

-LB

 

[Lnxvas]

thanks a lot.