Page on Group and Resetting Page Numbers
Posted on 2011-03-16
I have a report that has two groups. I want to be able to start a new page when group 1 changes, as well as have the page number reset. In the Section Expert of Group 1 heading, I check "New Page Before" and "Reset Page Number After". I have "Page n or m" in the Page Footer.
The result is...
Page 1 only contains the report header. No page number at the bottom.
Page 2 starts with the first group item. Page number at the bottom says "Page 2 of 2"
Page 3 starts with the second group item. Page number says "Page 1 of 1"
Page 4 starts with the third group item. Page number says "Page 1 of 1"
Page 5 continues the third group item. Page number says "Page 1 of 2"
And so on...
Two part question...
1. How do I get the first group item on the first page?
2. How do I reset the page numbers correctly?