ReportServer Forum

aguiral

Member

Registered: 2017-11-30

MariaDB behaviour

Hello,

as far as I have experienced, mariadb and subqueries behaviour are noticeably different from other databases.

Please check this document

https://drive.google.com/file/d/1aFjN33 … sp=sharing

where I have tried to explain mariadb 'order by' behaviour.

Knowing that, is it possible to set up/trick ReportServer to transpose the 'order by ' clause to the outer query statement ?

Regards

Alfredo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: MariaDB behaviour

Hi Alfredo,

check here: https://reportserver.net/en/guides/user … mic-Lists/
6.3. Alias, Sorting and Hidden Columns

You can easily select the columns you want to sort by in the list configuration.

Regards,
Eduardo

aguiral

Member

Registered: 2017-11-30

Re: MariaDB behaviour

Hi Eduardo,

thanks for your quick answer but I'm afraid that a 'normal' sort action for dynamic list does not work.

It is due to the 'special' way of manage subqueries of mariaDB engine :

https://mariadb.com/kb/en/library/why-i … y-ignored/

Cheers

Alfredo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: MariaDB behaviour

Hi Alfredo,

when you create a dynamic list and sort it using ReportServer functionality, your sorting fields will not get in the inner query.
Don't write in your query: " order by 1 desc". This is, as you discovered, not reliable, not only in MariaDB.

Use reportserver's "sort by" functionality. Again, check here: https://reportserver.net/en/guides/user … mic-Lists/
Section 6.3. Alias, Sorting and Hidden Columns

"The order of records in the final report can be changed by selecting an order for individual columns (under "order"). If an order is configured for more than one column, the order of the earlier column is obeyed first."

Regards,
Eduardo

aguiral

Member

Registered: 2017-11-30

Re: MariaDB behaviour

Hi Eduardo,

perhaps I'm not understanding you but no success ...

Check, if possible, my shared document upstream (I have updated it, see page 2)

Thanks indeed

Alfredo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: MariaDB behaviour

Hi Alfredo,

thank you for your updates. We will look into this.

Regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: MariaDB behaviour

Hi Alfredo,

fyi, I raised ticket RS-2959 for this.

Regards,
Eduardo

aguiral

Member

Registered: 2017-11-30

Re: MariaDB behaviour

Thanks a lot Eduardo.