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
mu0523  
#1 Posted : Wednesday, August 28, 2019 8:23:52 AM(UTC)
mu0523

Rank: Newbie

Groups: Registered
Joined: 8/28/2019(UTC)
Posts: 1
Germany
Location: Tübingen

Thanks: 2 times
Hi there,

I enjoy using Seal Report, but I have a question regarding the sort order of a Chart JS view:

How can the columns in my bar chart have the same order like the data elements in my model? When I execute the view in the Seal Report Designer, this works, but as soon as I deploy to IIS, the order is mixed up. I have a Data Table above where the order is always correct (same model).

I assume that the order is determined by the OrderBy() function in the Chart JS view template's @foreach loop, but is there a posiblity to have the "natural" order from the model or is the order in ResultPage.ResultSerie already random?

Thanks
Tobias
epf  
#2 Posted : Wednesday, August 28, 2019 12:08:54 PM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
you may check https://sealreport.org/f....aspx?g=posts&t=2046
so if you have no splitter, the sort order is given by SortOrder of the data element of the serie: you may just change this

you can also define your Comparer as explain in the post.
good luck.
thanks 1 user thanked epf for this useful post.
mu0523 on 8/29/2019(UTC)
Haigda  
#3 Posted : Friday, October 25, 2019 1:36:44 PM(UTC)
Haigda

Rank: Newbie

Groups: Registered
Joined: 10/2/2019(UTC)
Posts: 8
United Kingdom
Location: Glasgow

Thanks: 4 times
Hi, I am having a similar issue with a very simple chart. In the model I have 'users' as the column and 'margin' and 'Selling Price' as the data elements. I have the Sort Order for all three set to 'Automatic Ascending' and in the Report Designer Render the order is correct, the 'margin' value sets the order.

UserPostedImage

However, when I load the files to the iis the order is based on 'Selling Price'

UserPostedImage

I have tried changing the Sort Order to only have the 'margin' ascending and the others to none but this does not seem to make a difference.

Any help greatly appreciated

Cheers,
David
epf  
#4 Posted : Saturday, October 26, 2019 7:11:51 AM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
Yes, we have noticed that the Web Report Server (IIS) re-sort list when the sort is not specified,
this is the bug 138 and will be fixed in 5.1 (hopefully published in November/December).
the source code in Github has already the fix.


thanks 2 users thanked epf for this useful post.
Haigda on 10/26/2019(UTC), mu0523 on 10/31/2019(UTC)
Users browsing this topic
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.