can we avoid order by for row group properties in crosstab report

0

can we avoid order by  for row group properties in crosstab report

singh758's picture
Joined: Oct 22 2012 - 7:20am
Last seen: 5 years 5 months ago

2 Answers:

0

If you maintain order by in the query then also crosstab row group not take order by sequence in the query it will take order by from the rowgroup properties.

I think if you want custom sort then check with comaparator operator and order by expression may be solve your requirement. 

ajinkya_c's picture
976
Joined: Aug 29 2012 - 6:13am
Last seen: 2 years 5 months ago

in cross tab there is properties data is pre-shorted but when i checked that option i got java heap error..

singh758 - 6 years 5 months ago

right click cross tab-->crosstabdata-->select the checkbox "data is pre-sorted".

vaibhav.lather - 5 years 6 months ago
0

right click cross tab-->crosstabdata-->select the checkbox "data is pre-sorted".

vaibhav.lather's picture
Joined: Aug 23 2013 - 3:38am
Last seen: 4 years 2 months ago
Feedback