Sort first then group

[ind123p]

I am using CR XI

This is what I really want to accomplish.

Sort first then group

If parameter is ascending, sort by compnay Ascending then group by Company Ascending

Company Employee
CompanyA XYZ
CompanyA PQR
CompanyA ABC
Company A 3
CompanyB LMN
CompanyB RST
Company B 2

If parameter is descending, sort by company descending then group by Company descending

CompanyB LMN
CompanyB RST
Company B 2
CompanyA XYZ
CompanyA PQR
CompanyA ABC
Company A 3

MY Problem: Whether ascending or descending I am getting this

Company Employee
CompanyA XYZ
CompanyA PQR
CompanyA ABC
Company A 3
CompanyB LMN
CompanyB RST
Company B 2

I know why.. because the group order is ascending.. I know I have to create a specified order. But I am not able to understand how to go about using the specified order.

 

[ind123p]

Folks,

I was able to solve the problem. This is what I did.

I entered the following code in the "Use a Formula as Group Sort order"

if {?sort} ="ASC" then
crAscendingorder
else
crDescendingorder

That did it.