I am working on a report that needs to display across rather than down. I can get the data to display across by setting the columns value to 5 in the page setup, however this only applies to the detail section, and therefore the grouping data is being repeated for every set of sub data. Is there a way to set the columns for a header or group section of a report? Thanks
Example (wrong)
ISSUE 1 VOLUME 2 ISSUE 1 VOLUME 3
Pillar 1 Pillar 1
ISSUE 1 VOLUME 2 ISSUE 1 VOLUME 3
Pillar 2 Pillar 2
Example (goal)
ISSUE 1 VOLUME 2 ISSUE 1 VOLUME 3
Pillar 1 Pillar 1
Pillar 2 Pillar 2
Pillar 3 Pillar 3
Example (wrong)
ISSUE 1 VOLUME 2 ISSUE 1 VOLUME 3
Pillar 1 Pillar 1
ISSUE 1 VOLUME 2 ISSUE 1 VOLUME 3
Pillar 2 Pillar 2
Example (goal)
ISSUE 1 VOLUME 2 ISSUE 1 VOLUME 3
Pillar 1 Pillar 1
Pillar 2 Pillar 2
Pillar 3 Pillar 3