Make columns in report details but not in group headers

[Guest]

I have a report that has a group header section and a detail section. The
detail section is a single list of names.
I want to display the detail section only as multi-columns but keep the
group header section as a single column. In this way I will reduce the number
of pages of the report.

 

[Marshall Barton]

I have a report that has a group header section and a detail section. The
detail section is a single list of names.
I want to display the detail section only as multi-columns but keep the
group header section as a single column. In this way I will reduce the number
of pages of the report.

You'll need to create two queries. The main query would
only return the grouping field and related values without
any duplicate records. The second query would return the
name and grouping id field.

Once you get the queries working properly, Create a main
report base in the main query with the data in the detail
section.

Then create a second report for the names. Set this
report's Columns to however many you need and be sure to
select Across then Down.

Now, add the second report to the main report's detail
section and set the Link Master/Child properties to the
grouping id field.