Printing Reports

[Carly]

I have got a 20+ page report which is sorted on Cost Centre and I would like to start a new page when it gets to a different Cost Centre.

I noticed the following on another post:

Open report in design view and right click in the detail area. Select 'Sorting ang grouping'. Group header = YES, Group On = Each Value, Keep together = Whole Group

which works on some Cost Centres but not all.

JAN-BHS goes on one page but JAN-CBU and JAN-CFC group together. Is there anyway of splitting them?

Regards
Carly

 

[MattS]

If you've set up a group header for Cost Centre, right click on it and look at the properties. You'll find page break options - try selecting 'Before Each Section'.

HTH.

Matt.

 

[Carly]

Thanks that works exactly how I wanted it to

Cheers

Carly