Seal Report Forum
»
Report Edition
»
Reports
»
Problem with sorting numbers in report
Rank: Newbie
Groups: Registered
Joined: 2/27/2019(UTC) Posts: 4 
|
Hello everone, I am new member of the forume.
I have a problem with sorting columns contains numbers, even a set in report designer column type numebric, is sorting in correct 1,10,100,11 itd. Could you helo me in this matter?
The same issue is when export to HTML, seems to be still columns is consider as Text instead Numeric.
Best regards
Robert
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Normally the sort order is done by SQL (check your SQL statement of your model to see if the result is correct in SQL).
So be sure that the SQL type returned by your query is a number and not a char.
SR can also order by itself when displaying cross tab, is that the case for you ?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 2/27/2019(UTC) Posts: 4
|
Yes you right, I have corrected it and now working faine. Thanks for prompt replay
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 2/27/2019(UTC) Posts: 4
|
When I export data to HTML sortin is not working for columns contains numer, can I correct it somehow?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
It seems to work, what do you mean by Export to HTML ?
Just note that the dynamic filtering/sorting done after on the data table may not be taken into account.
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
Problem with sorting numbers in report
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
