Group By seperated by page... 2

[BFreshour]

Is there anyway to make a report seperate the 'Group By' categories into different pages? For example:

Instead of...

User1		5
User1		10
User1		15
User2		7
User2		10
User2		50

all on one page, we would insert a page break after the last User1 so that each Group started a new page.

 

[PaulBricker]

Create a User Header in your report. Add a textbox and set the control source to User. Then set the Force New Page Property to Before Section. If you don't want to see the data that way, you can set the Visible property for the textbox to No and just shrink up the section. Or you can use the header and get rid of the User value in the detail section.
Post back if you have problems.

Paul

 

[muffingal]

Thanks, Paul! It works perfect! I gave ya a star!