Grand Totals on Reports

Can anyone please advise how to get the Grand Total on a report to print
below the data being calculated and not on the next page.

The report I have subtotals by business unit (in this case it's only about
12 lines long) but the grand total is printing on the second page.

I have put the grand total and it's event rules are in a report footer.

Any help would be appreciated.


Thanks

Malcolm

OW XE SP13

Hi Malcolm !

The report Footer section ALWAYS print on a blank page at the end of the report, and there's nothing that you can do about it if you use a report footer.

Since you already have Event Rules to Calculate the grand Total, create a new section in your report and assign NO BUSINESS VIEW. Then put your Grand Total Event Rules in this section.

You don't need to put this section conditional, since this section is the last one it will be run at the end.

Christian Audet



Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)

Hi Malcolm,

If you can find a field that is constant for all records on that report (like Company or some unused Category Code), put that field on top of data sequencing and make subtotal on that field. Subtotal will be printed only on the end of report.

Hope this helps,

Bojan.