How to aggregate data by page

CheeSeng

Hi all,

I have a problem designing my report, the following are description and requirements of the report:-

DataSet columns : acc_ref_code, customer_code, po_amount
'acc_ref_code' is used to group data. For each group of data, I need to display the group grand total. If a group contains more than 1 page of data, a 'page total' will need to be displayed at the end of the page.

Example:-

Account Ref. Code : Account 1
Customer Code Amount
Customer 1 XXXX
Customer 2 XXXX
Customer 3 XXXX
...
Page Total XXXXXX
<end of page 1>

Customer Code Amount
Customer 52 XXXX
Customer 53 XXXX
Customer 54 XXXX
Customer 55 XXXX
Grand Total XXXXXXXXX

I am able to achieve the group grand total but not able to figure out how to display the 'Page Total'. Any help or guidance will be highly appreciated.

Thanks.

Best Regards,
Chee Seng

mwilliams

Hi Chee Seng,

You will probably have to create a grouping, inside your other group, based on an interval that will fit to a page. You can then use the group footer for this group to display a "page total" at the end of each page.