passing running totals from subreport to main report 1

[inncoggnitto]

i have a report with a subreport that includes totals for each group. i need to get a grand total of all of the totals for each subreport. the summary field cannot be selected in the main report. how do i pass the grand total to the main report?

 

[kenhamady]

You will need to do a grand total in each subreport, pass each back to the main report as a shared variable, and then after each subreport runs you will need to accumulate its grand total (along with the others) in a running total formula, using variables. To see how to build a running total using variables see faq149-182. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[inncoggnitto]

thanks for the help, i also used you formulas book and the Osborne reference book to get what i need to work.

i put this in the subreport
WhilePrintingRecords;
Shared NumberVar GrandTotal;
GrandTotal := GrandTotal + {#SubCount} '#SubCount is a running total field

and this in the main report
WhilePrintingRecords;
Shared NumberVar GrandTotal;