We help IT Professionals succeed at work.

Columns of Data in Crystal Reports

rporter45
rporter45 used Ask the Experts™
on
Good morning, I have a very simple report that generates a large amount of data spanning over 20 pages that are grouped together by a code (eg. Alumni, Donor) and the data below refers to state/province and their respective counts.
eg.
Alumni 467
ON  228
xx xx
xx xx

Rather than top-to-bottom, can I have the data run in columns to use up the empty space on the page (right to left?).  The report size will then be reduced dramatically and will be more meaningful to see the details together.

Thank you in advance for your help with this!

cms
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Assuming the data is all in the Details section, then go to the section expert and check Format with Multiple columns.
You will then get an extra tab that lets you specify the column width and allows you to set the Across then down/ down then across option.  In a main report you can use either option; in a subreport you can only use Across then down.

Author

Commented:
Hi there,

I had to make another requested change and there are actually two grouping levels and unfortunately the information is contained within the second grouping.  Is there a way to do this when the details are located in the group header2?  Or, maybe I should look at reconstructing the report?

thanks very much for the quick response,

cms
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Once you use multiple columns in the detail section, a new option appears in the group header which is to use multiple columns there also.  Give it a try.

mlmcc

Author

Commented:
I was unsuccessful unfortunately, In details, I checked off Multiple Columns and then went back into the group header and no such check box was available there.

I have included screen shots for easy view,

Thanks very much!
cms
Columns.docx
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Sorry bad memory.  It is on the LAYOUT tab after you choose multiple columns.

mlmcc

Commented:
Hi Have you tried doing a cross tab report?
http://www.youtube.com/watch?v=Vp3_Vy1eSXo

Author

Commented:
Worked quite well - thank you!

cms