I am trying to figure out how to page break in a report. Here is what I am doing. First the user selects from options (6 options) on what to sort by. The selection is then read into a report and I have used a case sort option. If option 1 then print in order by 1, if option 2 then print in order by 2 then 1, if option 3 print in order by 3 then 1, if option 4 print in order by 4 then 1..etc. up to 6 options. Now I need to page break after each group (sort by first option..1.2.3.4.5or6) keeping them all together and to print out on different pages when it is a new group. How do I (either in macro or module) accomplish this. I have tried the KeepTogether method, but feel I am doing it wrong. Can anyone help?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Page break in report after SortOrder Grouping
- Thread starter Sylvialn
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
