Sort order and display order

It is a common requirement to display one field while sort by another. For example month names > Jan > Feb > Mar, etc should always be sorted by month number and not the month name.

Well its a simple fix to enable that:

Open RPD > Navigate to the "month name" in logical layer > open column properties > click on General Tab > Specify "Month number" in 'Sort Order Column'

Viola !! When you display Month Name in the report, it will be correctly sorted from Jan to Dec. If you see the query from session log, you will see both name and number columns used in the query.