Not Sorting By Numbers Correctly

[ericp]

I have a report where I'm trying to sort by an Amendment Number. It seems to always be sorting by string only no matter what type I set the datasource to

For some reason, the output when I sort by ascending is showing up as:

100000
11
12
13
14
15
7
8
9

Instead of:

7
8
9
11
12
13
14
15
100000

[ericp]

Also attached my sample report.

I ensured that the type of my source is changed to INT, but it still seems to be sorting by String.

[Lech Kulikowski]

Hello,

Please send us a sample report with test data for analysis.

Thank you.

[ericp]

Hi Lech, please see the attached-

[Lech Kulikowski]

Hello,

In your JSON, your column is stored as a string:
"Amendment#": "7"
for numeric should be:
"Amendment#": 7

Also, in your report you can use the following expression for sorting:
(decimal)(Projects.Amendment_)

Thank you.

[ericp]

Hey Lech, I tried using both (Decimal)(Projects.Amendment_) and {(Decimal)(Projects.Amendment_)}, but it still doesn't seem to be formatting properly.

As for the decimal you can see that i changed the type to decimal- doesn't that automatically make the "Amendment#" turn into 7 instead of "7"?

Are you able to send the report of it working? Thanks!

[Lech Kulikowski]

Hello,

Please check the modified report.

Thank you.