Rank: Newbie
Groups: Registered
Joined: 8/28/2019(UTC) Posts: 1  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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
you may check https://sealreport.org/f....aspx?g=posts&t=2046so 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.
|
 1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/2/2019(UTC) Posts: 8  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.  However, when I load the files to the iis the order is based on 'Selling Price'  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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 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.
|
2 users thanked epf for this useful post.
|
|
|
|
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.
