Sorting data in crosstab report

[mukesh]

Hi all,

Have u ever tried to sort data in cross tab(CT) report?
If yes..then u must have broken ur heads..
There is no way u can sort data in CT report..
But ..no worry..with some little manipulation u can do this.

Well the soln is using rank..just add one more colum to report with formula..rank(catalog field name to sort)...then u can sort this column.

This is a very useful tip..do try it..

thanx for reading...Bye for now

Regards
mukesh

 

[CosmicNerd]

I hate seeing posts with 0 replies, even if it's two years ago!

Do you know how to get the ranking to appear in unsorted order, by any chance?