Page Totals incorrect

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
johns
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

Page Totals incorrect

Post by johns » Fri Jan 18, 2002 10:07 am

I have a report which give a sub total at the bottom of every page on a multi page report, however the page total uses the first figure from page 2 as well as all of the figures from page 1. This makes the running total at the bottom of page 1 incorrect. Is this a feature or have I done something wrong? I would be grateful if anyone could point out where I have gone wrong or the work around if it is a bug. Thanks in advance for any help offered.__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Page Totals incorrect

Post by kfleming » Fri Jan 18, 2002 2:39 pm

This can happen if you report has only group band lines and no record bands. It is caused by the way R&R manages its internal record pointer.__The workaround is to use a record band in place of the group footer and to control its printing logically so that only prints for the last member of the group. You can create two total fields that are counts and reset when the group changes. Make one of these pre-processed and then create a calc with expression TOTA=TOTB and use this calc to control the record band.______Kathleen__R&R Support

Post Reply