Access 2010 report - detail format event over page break
I have an access 2010 report. On the detail format event I collect some totals. The totals weren't quite right so I added some debug.print statements to track what was happening. It seems that when the detail section goes over a page the detail line at the top of the second page is formatted twice. ie. the detail-format event is triggered twice so that amount is added to the total twice.
The code in the detail_Format event is something like: TotalAmt - TotalAmt + ThisAmt
So, TotalAmt is always equal to what it should be plus the 2nd page first item added in again. If I change where the page break happens the total changes accordingly.
Is this a bug? Any ideas how to fix this? I know I can use sum([field]) to total the detail section automatically but I want to do other things with the totals I collect.
The code in the detail_Format event is something like: TotalAmt - TotalAmt + ThisAmt
So, TotalAmt is always equal to what it should be plus the 2nd page first item added in again. If I change where the page break happens the total changes accordingly.
Is this a bug? Any ideas how to fix this? I know I can use sum([field]) to total the detail section automatically but I want to do other things with the totals I collect.
Can you upload sample DB and show expected result? You can save current value of some unique field and do not add value to total if this value was not changed from previous event
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As LSM has said, this is not unexpected and often the report engine will retreat up the page to refomat it.
Besides the Format event, the print even may occur multiple times as well.
The simplest then is to check the FormatCount as LSM suggested. An alternative is to use the OnRetreat event to subtract the total back out.
Jim.
Besides the Format event, the print even may occur multiple times as well.
The simplest then is to check the FormatCount as LSM suggested. An alternative is to use the OnRetreat event to subtract the total back out.
Jim.
ASKER
Great. Problem solved. Thanks.
ASKER
Perhaps the detail_Format event is not the right place to collect the totals? But report OnCurrent event doesn't work. So is there another event I can use to step through each record in the source?