Grouping: Listing Details Across, Then Down Page

[LifespanWriter]

I have a question that I couldn't fine under keyword search... Someone has requested a report from me to show employee schedule data grouped by shift then by department. In each group, they want to see the details of Employee_ID, Employee_Name, Start_Time, End_Time, Skill. The problem is, they want to see the above details of at least 2-4 departments printed across the page. They want this to replace the report they'll be losing when we switch over to a new time and attendance system. Is this possible in Crystal 8.5 or XI? This is an example of what they want it to look like:

DAY Shift

Dept. # Dept. #
ID, Name, Start/End, Skill ID, Name, Start/End, Skill
ID, Name, Start/End, Skill ID, Name, Start/End, Skill
ID, Name, Start/End, Skill ID, Name, Start/End, Skill
ID, Name, Start/End, Skill ID, Name, Start/End, Skill

EVENING Shift

Dept. # Dept. #
ID, Name, Start/End, Skill ID, Name, Start/End, Skill
ID, Name, Start/End, Skill ID, Name, Start/End, Skill
ID, Name, Start/End, Skill ID, Name, Start/End, Skill

I'd appreciate any assistance I can get!
Thanks much!


Richard Sanders
Payroll/HR Systems Specialist
Lifespan Corporate Services
Providence, RI

 

[synapsevampire]

Sure, group by the Shift and then right click the details and select section expert->Format with multiple columns.

Works with either version.

You might also use the mailing label wizard in either version.

-k

 

[LifespanWriter]

Thanks for the response! However, I just got a chance to try this and it didn't work... Could I be missing something? I even tried putting in the header and details again next to the first ones, and all that did was repeat the same exact information in a second column. Am I supposed to put anything else into the report after grouping by shift, right clicking on the details and then using the selection expert to format with multiple columns?

~Rich


Richard Sanders
Payroll/HR Systems Specialist
Lifespan Corporate Services
Providence, RI

 

[lbass]

In the section expert, after checking "format with multiple columns", go to the new layout tab that appears->set the width and gap, down then across, and check "format groups with multiple columns". I don't think you can selectively format only some groups with this, so you might need to use a subreport with the departments and details where you use the columns, and then place that in the group footer for shift.

-LB