i have Day column where i get day names as Mon Day to Sun Day, but when they are not in sort Order from Monday to Sunday... i am getting as in gigag saturday thursday monaday... in this order. how can i get sort these columns in Subject area so that even though i create n no.of reports i can get sot day names in all reports.
Can some one help me...
Have a column and pull it in the rpd for sorting purpose with 1,2,3,...for corresponding days and check the sort order for the days column based on the sorting column.
Or you can also have this column pulled in presentation layer and use the column always when days column is used and sort it.
Hope this helped/ answered
You can sort the column based on another column @RPD
BMM layer--->properties of the day of the week-->General--->Sort order column ---->day_number_of_week--->then data will display as required....
But the day_number_of_week monday should be 1 and sunday should be 7........
mark if helpful/correct....