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.