Ordering of data in Crosstab.

[smita.patil]

Hi,

I have used order by clause in my crosstab query and checked "Data is pre-sorted" check box for the crosstab.However I am getting wrong data.For some sets of data the crosstab displays right with correct data, for others it is giving 0 and extra rows in crosstab.

Then I removed the data pre-sorted check and tried to apply Order by expression to one of my Row variables.But that does not work either.

Order by expression does not accept my crosstab query output field, hence I introduced a measure in crosstab(calculation:nothing) width, height 0 for this measure and tried to order my row group by this measure.But again this is not helping and I am not getting sorted data.

Please guide me through this.

Regards,

Smita

[ajinkya_c]

Hi,

I also faced same issue but I managed the sorting from crosstab query. I was checked with option order by expression and comparator expression but it not works as i wanted. If you able to do with these option then please let me know how you do that.

Also let me know which version you are using? it may solve in latest versions

Thanks,

Ajinkya