I have a report that is sectioned on District, with 2 separate lists under the sections.
The first list is a summary for District while the second is a detailed list by Site. The client has requested that the Detailed list Page Break on District and Site.
When I set the Page Set to group on District and then Site, however, I the Summary List
Desired:
District A ---Section
District A Summary ---List 1
Site X Detail ---List 2
---------page break-------------
Site Y Detail ---List 2
-------------page break--------------
District B
District B Summary ---List 1
Site M Detail ---List 2
---------page break-------------
Site N Detail ---List 2
What I'm seeing with the Page Set marked to break on District and Site:
District A ---Section
District A Summary for only Site X ---List 1
Site X Detail ---List 2
---------page break-------------
District A Summary for only Site Y ---List 1
Site Y Detail ---List 2
-------------page break--------------
District B
District B Summary for only Site M ---List 1
Site M Detail ---List 2
---------page break-------------
District B Summary for only Site N ---List 1
Site N Detail ---List 2
Any help would be very much appreciated!