Skip to Content
0
Former Member
Nov 25, 2009 at 10:14 PM

Cross-tab Column Order

25 Views

I am trying to generate a cross tab that has months as the rows and scenerios as the columns. The scenerio data is string data that starts with a number. I want it to appear as follows:

1_xxx, 2_xxx, ... 10_xxx, 11_xxx ...

what I get is:

1_xxx, 10_xxx, 2_xxx, ... 11_xxx ...

I am using CR XI and have exhausted what I can find to set order based on a substring. I have even created an order by clause in my SQL but the cross tab seems to reject it.

Any help would be apreciated. Thanks in advance.