Page Break On Group Value Change 1

[jmeadows7]

Although I've written some complex reports and graphs, I seem to be missing something that should be simple.
I want the report to break each time a group changes.
i.e. The report is as follows:

Transportation Type
Salesperson
Ship Dt Freight MBF From To

Whenever the salesperson changes I want a page break.
Whenever the Transportation Type changes, I want a page break.

Any ideas? I checked FAQs and didn't see anything jump out at me.

I haven't tried code yet - thought there might be an easy setting before I go behind the scenes.

Thanks!

 

[jmeadows7]

Oh yeah, I didn't add that I have tried the following on the grouping options:
Transportation type:
Group Header Yes
Group Footer Yes
Group On Each Value
Group Interval 1
Keep Together Whole Group

the same settings apply to salesperson- I thought that this would page break it at salesperson - but if a salesperson's data doesn't take up the whole page, then the next salesperson's data is appended to the same page.

 

[ZmrAbdulla]

Did you try playing with "Force New page" for each group

Click on the group > properties > Format > Force New Page

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[jmeadows7]

Thanks - had forgotten about those properties - haven't had to use them in a couple of years.