Script Report Column Sorting

The below screenshot shows a Script Report… When I try to sort the ‘Rate’ column this is how it is sorted…
It should be sorted as 10.00, 11.00, 100.00 instead of 10.00, 100.00, 11.00
Why is it sorted this way and how should I try changing it to the order I want?
Kindly help. TIA!

If you click on the column heading “Rate” in this case, it should sort automatically. You can try to see if it works for you.

@Pawan, the column as seen in the screenshot appears after I have clicked on the column, that is after I have sorted it by clicking on it this is the result it shows. That is why I’m concerned about the sorting

it’s on all reports or only this specific report?

i guess if it’s script report, you need to change the datatype for rate column. it’ll work fine.

1 Like

@adnan Thanks for the reply… I have used datatype ‘Float’ for this column… What should I change it to?

with float this should work fine. it’s only one column or you have issue with all columns?

It appears on other columns too… In my example, the ‘Total’ column also behaves the same way

The datatype for the column is ‘Float’ but the custom DocType had it as ‘Data’… Changing it to ‘Float’ resolved the issue. Thanks for the help @adnan

you are welcome…

Please mark it as closed