How can I reorder the 3 lines - in progress/ in time/ overdue. That in time is on the bottom- overdue in the middle and in progress on the Top.
1 ACCEPTED SOLUTION
No directy way to do it.
Is your compliants field is a calculated column? If it is, you can try the following workaround.
Example below:
Say you need to change the Gender order from F -> M to M -> F and Gender info is stored in a calcuated column.
Select Enter Data to create a new Gender Table with an Order column that mark the order of M is higher than F.
Save the table and then create relationship between this new Gender table with the original table.
After that, go to the new Gender table, select Gender column and then select Sort by Column and choose by Order column.
Then go back to your report, use the Gender column from the new Gender table to replace the original gender column.
This time you can get the new order.
No directy way to do it.
Is your compliants field is a calculated column? If it is, you can try the following workaround.
Example below:
Say you need to change the Gender order from F -> M to M -> F and Gender info is stored in a calcuated column.
Select Enter Data to create a new Gender Table with an Order column that mark the order of M is higher than F.
Save the table and then create relationship between this new Gender table with the original table.
After that, go to the new Gender table, select Gender column and then select Sort by Column and choose by Order column.
Then go back to your report, use the Gender column from the new Gender table to replace the original gender column.
This time you can get the new order.
