I have a set of nested groups on my report that are for the most part working as needed. Each group has a corresponding Header section which lists the appropriate info for the group, and the Detail section displays the appropriate info for the groups. There is an unwanted behavior, however, with how often the outermost group header is displaying. In general, my requirement is to display the data like:
Week 1 (Jan 1 - Jan 7) Group Header
Product Category 1 Group Header
Product 1 Detail
Product 2 Detail
Product Category 2 Group Header
Product 3 Detail
Product 4 Detail
Product Category 3 Group Header
Product 5 Detail
Product 6 Detail
Week 2 (Jan 8 - Jan 14) Group Header
Product Category 1 Group Header
Product 1 Detail
etc
The output I'm getting, however is:
Week 1 (Jan 1 - Jan 7) Group Header
Product Category 1 Group Header
Product 1 Detail
Product 2 Detail
Week 1 (Jan 1 - Jan 7) Group Header (UNWANTED LINE)
Product Category 2 Group Header
Product 3 Detail
Product 4 Detail
Week 1 (Jan 1 - Jan 7) Group Header (UNWANTED LINE)
Product Category 3 Group Header
Product 5 Detail
Product 6 Detail
Week 2 (Jan 8 - Jan 14) Group Header
Product Category 1 Group Header
Product 1 Detail
etc
Is there a way to control where/when the outermost group header appears? I don't need this outermost group header to repeat every time the inner group header changes, only at the beginning of each of the outermost groups. Is this something that has to be done programmatically, or is there a report setting that controls this?
Thanks!