Crystal Reports 2011 Cross Tab multiple columns in a sub-report?

[PatchesPete]

I have a report that has a subreport in the report header that contains a cross-tab. This cross-tab pulls all members that work in a particular department (chosen via a parameter) and displays their name vertically down the page. Report needs to be one page only. One particular department has many members which makes the detail of the report go to a second page. Is there a way to generate multiple columns if there are more members than will fit into the first column? Something like this? Disregard the periods between the names. I put them there as spacers only for this post. Will not be part of the report.

LastName, David..........LastName, Pat
LastName, Diane..........LastName, Paul
LastName, Edward........LastName, Timothy
LastName, Joan............LastName, Wendy
LastName, Julie
LastName, Justin

 

[pmax9999]

I can't remember which version of CR implemented multiple columns for the details section, but certainly in CR11 and beyond it is available. Go to Details section in Section Expert, select Format with multiple columns and set the Layout to Down then across.

Hope this helps

Cheers
Pete

 

[PatchesPete]

Unfortunately, this is not in the Details section but in the Report Header. Format with multiple columns is not an option there. Users are able to select the department from a parameter and the cross-tab returns the employee names vertically and places them in the Report Header.

 

[PatchesPete]

I figured it out. I moved the employee name to the detail section of the sub-report and hid the remainder of the cross-tab that was in the report header of the sub-report. I could then edit the employee name to display in columns since it was now a detail line. I now display the employee names in 2 columns and the report now fits on one page.