Print page of page on group footer, not pagefooter
Is there a way to print page of page on a group footer of a report, not the page footer? In other words, say I have a report grouped by salesperson... I'd like each salesperson's information to start on a new page of the report and have that group have it's own page of page information starting with 1 printed on the group footer.
Can this be done?
Can this be done?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jim,
WOW! Thanks. I only have one issue. The report has a report footer. For some reason the last group says page 1 of 2, there is only one page for the group), because it's counting the report footer, which is a page of its own, as the 2nd page even though it shouldn't be counted in the groups x of x text box.
??
WOW! Thanks. I only have one issue. The report has a report footer. For some reason the last group says page 1 of 2, there is only one page for the group), because it's counting the report footer, which is a page of its own, as the 2nd page even though it shouldn't be counted in the groups x of x text box.
??
That is more or less correct; the last group occupies the last two pages of the report because there is no next group.
another way to say that; if the report footer had fallen on the same page as the group footer, then the group would read 1 of 1.
Jim.
another way to say that; if the report footer had fallen on the same page as the group footer, then the group would read 1 of 1.
Jim.
=[Page] & " of " & [Pages]
Then, in your group footer, refer to that:
=[txtPageInfo]
/gustav