Column sort not working for dynamic list

Aniello · 2018-12-05 08:27:56

There seems to be a problem with sorting columns when previewing a dynamic list report. E.g. can't sort columns in the Audit Log and for own dynamic list reports. Currently running latest RS EE (Evaluation).

eduardo · 2018-12-05 09:57:35

Hi Aniello,

which database are you using in your dynamic lists? Did you perform a bitnami or a manual installation?

Regards,
Eduardo

Aniello · 2018-12-05 21:28:10

Hi Eduardo

Default Bitnami installation - using installed Audit Log report as an example

Last edited by Aniello (2018-12-05 21:29:27)

eduardo · 2018-12-06 07:58:18

Hi Aniello,

check the demo system: https://reportserver.net/de/demo/. User: demoadmin, demoadmin.

The sorting is working here. For example open the T_AGG_CUSTOMER - Basis report, its variant: Customers with negative account balance
It is sorted by default by "CUS_CUSTOMERNAME" descending. You can change this and it works.
Can you please check if you are doing the same ?

Regards,
Eduardo

eduardo · 2018-12-06 10:53:50

Hi Aniello,

we just tried to sort with the default bitnami installation 3.0.5 version, audit log report, and it works in our environment. How exactly are you sorting your fields? Can you send a screenshot ?

Regards,
Eduardo

Aniello · 2018-12-20 10:22:36

Hi Eduardo

Just returned so picking this up again as we need to make a buying decision soon. Basically, sorting doesn't work on my local Bitnami RS EE install (Macbook) and neither on one of our Centos servers. I created a custom Dynamic List report when I noticed that - using Preview - I then thought I would just try to Preview and then sort one of the installed reports (Audit Log) - with same effect.

I did try your demo server and there it works ..... we are a bit stuck now - filtering works fine.

rs-sort

Regards
Aniello

Last edited by Aniello (2018-12-20 11:20:00)

eduardo · 2018-12-20 11:46:29

Hi Aniello,

this is very strange. Which datasource is your audit_log dynamic list pointing to? Is it the default mariaDb installed with bitnami? Can you please send a screenshot of the datasource configuration?

Did you perform an upgrade or did you directly install the 3.0.5 bitnami package ?

Regards,
Eduardo

eduardo · 2018-12-20 12:27:30

Hi Aniello,

we are seeing the problem in certain test cases. I will update here when I have more information.

Regards,
Eduardo

eduardo · 2018-12-20 13:24:44

Hi Aniello,

this only seems to be happening with MariaDB. MariaDB is the default Bitnami database. If you create a datasource pointing to another database, even MySQL, does the sorting work? We are currently only seeing this with MariaDB / Bitnami.
Fyi: we raised ticket RS-3230 for this.

Regards,
Eduardo

Aniello · 2018-12-20 13:49:10

Hi Eduardo

You are right - no issues with sort when running on MySQL.

MariaDB is what we are using in production so we won't be able to change DB.

Regards

Aniello

eduardo · 2018-12-20 14:18:19

Hi Aniello,

"MariaDB is what we are using in production so we won't be able to change DB."
-> Do you mean you use MariaDB as an internal reportserver database, or do you use MariaDB in your production databases (customers, etc).

Regards,
Eduardo

Aniello · 2018-12-20 14:50:05

Hi Eduardo

MariaDB is used for both internal reportserver db and also in production databases - we use Galera clustering...

if it helps, I think the issue might be with some differences in 'order by' between MySQL and MariaDB - have a look here: https://sujithjay.com/2017/12/01/Order- … aDB-MySQL/

Regards
Aniello

Last edited by Aniello (2018-12-20 14:55:09)

eduardo · 2019-01-02 09:45:46

Hi Aniello,

fyi, we are seeing the problem and are trying some approaches in order to fix this. We will update this thread when we have more information. This should be corrected in the next reportserver version, available the latest at the end of january.

Regards,
Eduardo

eduardo · 2019-01-08 10:38:12

Hi Aniello,

we fixed this and the fix will be available with reportserver 3.0.6. I sent you a patch for 3.0.5 per email, please test it and let us know if this works for you.

Regards,
Eduardo

Aniello · 2019-01-13 14:24:35

Hi Eduardo

Thank you for the fix - we tested this and sorting MariaDB columns now works fine.

Best Regards
Aniello

eduardo · 2019-03-13 10:55:28

Hi Aniello,

ReportServer 3.0.6 is released and this is available now as you can read in the release notes: https://reportserver.net/releasenotes/RS3.0.6.html

RS-3230 Bug Dynamic list sorting is not working with MariaDB

Regards,
Eduardo

ReportServer Forum

#1 2018-12-05 08:27:56

Column sort not working for dynamic list

#2 2018-12-05 09:57:35

Re: Column sort not working for dynamic list

#3 2018-12-05 21:28:10

Re: Column sort not working for dynamic list

#4 2018-12-06 07:58:18

Re: Column sort not working for dynamic list

#5 2018-12-06 10:53:50

Re: Column sort not working for dynamic list

#6 2018-12-20 10:22:36

Re: Column sort not working for dynamic list

#7 2018-12-20 11:46:29

Re: Column sort not working for dynamic list

#8 2018-12-20 12:27:30

Re: Column sort not working for dynamic list

#9 2018-12-20 13:24:44

Re: Column sort not working for dynamic list

#10 2018-12-20 13:49:10

Re: Column sort not working for dynamic list

#11 2018-12-20 14:18:19

Re: Column sort not working for dynamic list

#12 2018-12-20 14:50:05

Re: Column sort not working for dynamic list

#13 2019-01-02 09:45:46

Re: Column sort not working for dynamic list

#14 2019-01-08 10:38:12

Re: Column sort not working for dynamic list

#15 2019-01-13 14:24:35

Re: Column sort not working for dynamic list

#16 2019-03-13 10:55:28

Re: Column sort not working for dynamic list

Board footer