Footer going on wrong page and page numbering incorrect

[bitsyspider]

Hi everyone,

I have a weird report problem. I have a report with two group footers, page footer and a report footer. I have calculations in each group footer and am forcing a new page after the second group footer so that each office's info will be on it's own page. I have a page footer which has the standard page and pages in it and a report footer that calculates the report total.

The report works correctly in print preview but then is incorrect in print or exporting to rtf. It forces a new page, prints the report footer on a new page and is numbering wrong i.e.. page 26 of 25. I put code in the on format property of the group

If Me.txtPage = Me.txtPages Then
Reports!rptDQBErrorSummarySAC.Section(6).ForceNewPage = 0
Else
Reports!rptDQBErrorSummarySAC.Section(6).ForceNewPage = 2
End If

Any ideas?

 

[genomon]

Try the print event instead of the format event. The format event fires multiple times per section, whereas the print event does so once.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."