How can you disable crosstab row group sorting?

0
Is it possible to disable the sorting of crosstab row groups?
I have a crosstab table that is working as I want it to, but an alphabetical sort is being applied to the results.
In the properties settings for row groups there are only two options (ASC, DESC), but because my results are stored in mysql in the order they should be displayed this is causing a problem for me when the crosstab is run.
Any pointers to how to disable the sort would be appreciated. 
Ideally it would be nice to see a 'None' option in the sort properties :)
 
In case it helps, the mysql table is something like this...
Name.......Day.......Results
Fred.......1.........55
Fred.......2.........40
Fred.......3.........50
Fred.......4.........45
Fred.......5.........21
Andy.......1.........44
Andy.......2.........60
Andy.......3.........50
Andy.......4.........40
John.......1.........44
John.......2.........80
John.......3.........90
 
The crosstab output should be...
Name.........1.........2.........3.........4.........5
Fred.........55........40........50........45........21
Andy.........44........60........50........40
John.........44........80........90
 
The crosstab is coming out as...
Name.........1.........2.........3.........4.........5
Andy.........44........60........50........40
Fred.........55........40........50........45........21
John.........44........80........90
sg129's picture
96
Joined: May 14 2012 - 4:17am
Last seen: 9 years 1 month ago

1 Answer:

-2

 A bit of time and looking around I answered the question myself. 
I'm surprised nobody was able to answer, but if anyone else finds this thread, here is the answer...

This is how to display your crosstab results in the order they are stored in your database, disabling the ASC/DESC sort.
- In your report, right click on your crosstab element and click crosstab data.
- Highlight 'Data is pre sorted'

Simples...

sg129's picture
96
Joined: May 14 2012 - 4:17am
Last seen: 9 years 1 month ago

This steps is works for me. Thanks for help.
In your report, right click on your crosstab element and click crosstab data.
- Highlight 'Data is pre sorted'

pranjalsingh2588 - 6 years 9 months ago

Thank you very much. It works for me.

prakashpn123 - 5 years 8 months ago

This solution is work for me. Thanks for help. Thanks.

aungtuntun2012 - 5 years 8 months ago
show 1 more...

Thanks This works for me :)

gotoark - 3 years 3 months ago
Feedback
randomness