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
jakub  
#1 Posted : Monday, May 9, 2016 3:38:59 PM(UTC)
jakub

Rank: Newbie

Groups: Registered
Joined: 4/28/2016(UTC)
Posts: 1
Location: Prague

Thanks: 2 times
Hi,

I just trying to change order of pages in my report. Here is example:

I got 5 pages:
A
B
C
D
E

and i want to show them in custom order. E.g.:

C
E
A
B
D

How can i do it?
epf  
#2 Posted : Tuesday, May 10, 2016 7:42:41 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 model table is sorted by SQL: this is controlled by the property "Sort Order" of each element displayed...
You can then view the SQL generated with the ORDER BY clause.

You can modify the ORDER BY clause of the model by editing the model property "Order By Clause" (you can add here column that are not shown in the report)

If you can not have your sort done by SQL, you have other option:
Create an enumerated list on the element you want to sort, in the enum list definition, you can define your custom sort order.

Another option is to use the model "Post Load Script" to modify your DataTable as you like...


Good luck.

thanks 1 user thanked epf for this useful post.
jakub on 5/10/2016(UTC)
Users browsing this topic
Guest
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.