NEED HELP SORTING (CR XI)

[jpeters01]

I need to group by RX Number (which are IV solutions administered together) and sort alphabetically using the Description field, i.e. I just can't get this to work.

IV Description RX#

Insulin 26
Sodium Bicarbonate 33
D5W 55
D5W 33
Vasopressin 55
Calcium 40

I need to show like this:

Calcium 40

D5W 33
Sodium Bicarbonate 33

D5W 55
Vasopressin 55

Insulin 26

Hoping you can help me with this...

 

[lbass]

Insert a group on {table.rx#}. Then select the IVdesc field in the detail section and right click and insert a minimum on it at the group level. Then go to report->group sort-> and select maximum of {table.IVdesc} as your group sort field->ascending order.

-LB