splitting a group into columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this report that has too much white space in it:

MonthA
CompanyA
CompanyB etc
MonthB
CompanyA
CompanyB


I want it to look like this:
MonthA
CompanyA CompanyB
CompanyC CompanyD etc
 
Have you consider using the Page Setup to print multiple columns that
display across then down?
 
Yeah messed around with that. For some reason, if I split the report into
two columns, the company footer (which has totals) gets put into the right
column, while the company header stays in the left. This doesn't exactly
help my clear up white space in the report. Having the columns set to down
then across helps with the white space, can be confusing to look at. I'd
really like the information to go across, then down.
 
Base your main report on only the MonthA field with no details regarding
Companies. Make the main report into a single column. Create a subreport
with the MonthA field as well as the Company field. Set this subreport to
display multiple columns across then down.

Add the subreport to the detail section of the main report and set the Link
Master/Child properties to the MonthA field.
 
Back
Top