PageNo() and Lastpage()

[Thomas_Kehl_(Guest)]

Hello____I have in a pagefooter-line a condition { pageno()=lastpage() }. That works good, but when I insert database-fields, they aren^t displayed in the report. Static text-fields and lines are displayed.__What^s the reason for this problem? And how can I avoid that?____Thanks__Thomas Kehl

[kfleming]

My guess is that R&R determines it is on the last page and thus past all of the data records for the report. Is the idea that you need to print certain data only on the last page and at the footer?____If so, create a calculated field with expression 1 and make this your first group field with swap footer checked.__Then on your report, create a blank page footer line and a group 1 footer with your data fields.__The group will break at the end of the report so on the last page you will get the group 1 footer in place of the blank page footer that will be on all previous page.____Kathleen__R&R Support