Sum up summaries from a main report w/ summaies of sub report 1

[gyro1107]

I have written a report that uses formulas to select data based on different criteria. I have created summaries in each footer for each formula. The detail is suppressed so only the footer summaries appear. The summaries are then summed by the first group in the report. I have two sub reports that follow the same pattern. I need to know if it is possible to sum up the summaries from the main report with those of the two sub reports to produce a grand total.

 

[paulmarr]

Sure Gyro,

By storing the values of the totals into a shared variable, the main report as well as all subreports can see and have access to this variable. You would write something like:

shared numbervar gtotal := 0;

gtotal : = gtotal + {summary value};

Then access the same variable in the sub report by:

shared numbervar gtotal;

and then add subtract or display the value!

Cheers,

paulmarr@arcom.com.au

 

[KJSDAD]

Be careful there is a size limitation on the amount of data that can reside in your shared variables within your sub report formulas. You might have to create several formulas in your sub report if you have say 10 seperate totals you want to bring back.

 

[jjanon]

Is there a way to print only the group footers (subtotals) and the report footer(grand totals) without the blank spaces (left after hiding the detail lines)?

Thanks in advance

 

[agray123]

Sure, just shrink down the detail section size in the design window to as small as possible