I'm using a Cross Tab Report with rows with names like 'Q1', 'Q2', 'Q7', 'Q10' etc.
However, they're in alphabetical order such as:
Q1
Q10
Q2
Q7
However, I want:
Q1
Q2
Q7
Q10
Is there any way to specify the order of rows?
Quick and effective.
PowerUser
2009-09-16 14:11:24
Unfortunately this wouldn't be acceptable to the user, but thanks for the suggestion.
DavidStein
2009-09-16 15:00:33
+2
A:
Use a crystal formula to return the Q1, Q2, etc as only the number and as an integer. Group on this formula in the cross-tab, but use the original field as the Group name.
CodeByMoonlight
2009-09-15 18:20:46
I actually find this solution quicker than modifying the original query.
CodeByMoonlight
2009-09-16 16:50:46