This content has been marked as final. Show 5 replies
without month code in both report & repository.means???
Answers--->If u want to do it in prompt convert the results to sql and use order by date column
Rpd---->Double click on logical column-->Sort order column name-->Set-->any date column(yyyy/mm) format
Pull a date column in report put asc order on that one ...hide that column
this can be one way too as i followed the same in one of the requirement.
Take another column and in the formula.use the case clause as below.
Case when month='Jan' then '01' else case when month='Feb' then '02' else ..... end end
Do the above for all 12 months.
Hide this column and sort on this column..
This will sort the month as you need.