Group Headers get Mixed

arthurmq

Board Regular
Joined
May 29, 2004
Messages
81
Hi, I created a report containing a Report Header, and a Page Header including 10 different Group Headers. The reason I created these 10 Group Headers is because I want to hide any Group that contains no data. The report should show a record per page containing from 1 to 10 Groups depending of the data on the record.
The problem I encountered is that when I execute the report some of the Groups Header from one record get mixed with the Groups of the next record/page. Any idea how to fix this?

Thank you
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Hi, I think we need some more information before we can help. Is the report based on a query or a table? What are the variables on the report? And can you explain specifically how the sorting & grouping has been set up? (In the report design Click View -> Sorting and Grouping).
Andrew :)
 
Upvote 0

Forum statistics

Threads
1,221,825
Messages
6,162,190
Members
451,752
Latest member
majbizzaki

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top