Cross-Tab sorting question

[vshapiro]

In my Cross-tab I need to have a columns using Status_Description(and it sorted alpha). I need to sorted columns by Status_Sequence field. How can I do this??

These two fields are corresponding. I can get a columns using Status_Sequence but column names in the report should be Descriptions

 

[lbass]

You could use {Status_Sequence} for the column field, and then click on it, select "Group Options" and then choose "Customize Group Name Field" and choose {Status_Descriptions} for the field.

-LB