Sorting issue

View previous topic View next topic Go down

Sorting issue

Post  Bari on Mon Jul 18, 2011 9:01 am


I have list report and have a column Category which has "New Store" and "Old Store”. This report is mainly developed through

Sql Query. The Problem is when i drag Category column it comes as New Store and Old Store where as the requirement is that it

Old stores should come first. What i did is I dragged a data item and wrote expression if([sql][Category]= 'Same Store') then (1) else (2)

and then cut the column from report page and sorted category as descending, it did the trick and met the requirement. My question is when i am sorting as ascending it is same old thing where as ascending should have worked. I am confused, what is going on here. Could gurus please explain. Thanks.


Posts : 2
Join date : 2011-05-12

View user profile

Back to top Go down

Re: Sorting issue

Post  VHF on Mon Jul 18, 2011 11:13 am

What database platform and reporting tool are you using?


Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum