You are not logged in.
Pages: 1
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
Offline
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
Offline
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
Offline
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
Offline
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
Offline
Hi Alfredo,
thank you for your updates. We will look into this.
Regards,
Eduardo
Offline
Hi Alfredo,
fyi, I raised ticket RS-2959 for this.
Regards,
Eduardo
Offline
Thanks a lot Eduardo.
Offline
Pages: 1