Sorting a Group Report

[tmozer]

I created a fairly simple report that groups analysts by their user ID and does a count (total) of all of the assignments completed for a specified time period. Along with their name, it also list their unit and laboratory, like so:


Donna L. Koxxxxx East Lab 15 DRUG Cases
Brandon M. Pxxxx Central Lab 24 DRUG Cases
Susan L. Txxxx East Lab 26 TOX Cases
Allison M. Lxxx Central Lab 3 CRIM Cases
Nancy Malik Axxx North Lab 72 DRUG Cases

The name is derived in the grouping from the UserID, the lab is derived from a formula (if LabCode="E" then "East Lab) and the Unit (type of case) is directly from the table.

I would like the ouput to be sorted by unit and then LabCode (laboratory). In CR 8.5 I cannot find a way to do that.....


Heather A. GarohSouth Lab 38 DRUG Cases

 

[lbass]

Insert a group on unit and another group on lab. Go to report->change group expert and use the directional arrows to make unit your highest order group, followed by lab, and then by user ID. If you want to, you can suppress the group headers and footers for unit and lab.

Or, instead of going to the change group expert, you can also move groups by clicking and dragging on the gray area to the left of the report canvas while in design mode.

-LB

 

[tmozer]

That worked great. I could swear I try to do that before, but must have been going about it incorrectly. Thanks for your help!