logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
RobertG  
#1 Posted : Wednesday, February 27, 2019 9:08:55 AM(UTC)
RobertG

Rank: Newbie

Groups: Registered
Joined: 2/27/2019(UTC)
Posts: 4
Poland

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
epf  
#2 Posted : Wednesday, February 27, 2019 9:16:12 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

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 ?
RobertG  
#3 Posted : Wednesday, February 27, 2019 9:23:49 AM(UTC)
RobertG

Rank: Newbie

Groups: Registered
Joined: 2/27/2019(UTC)
Posts: 4
Poland

Yes you right, I have corrected it and now working faine. Thanks for prompt replay
RobertG  
#4 Posted : Wednesday, February 27, 2019 11:20:23 AM(UTC)
RobertG

Rank: Newbie

Groups: Registered
Joined: 2/27/2019(UTC)
Posts: 4
Poland

When I export data to HTML sortin is not working for columns contains numer, can I correct it somehow?
epf  
#5 Posted : Friday, March 1, 2019 2:44:37 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

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.
Users browsing this topic
Guest (3)
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.