This topic is locked

Report GROUP BY and sorting

2/2/2021 3:41:09 PM
ASPRunner.NET General questions
E
erosolmi author

Hi all,
I'm using ASPRunner 10.5 build 36598
I'm creating a report with a group field (Year of a sale campaign) and I would like to sort it descending.
I'm not able to find any way to sort by that field.

Query is already sorted by that field but seems that the group report option change it into ascending by default.
Thanks a lot

Eros

admin 2/9/2021

ASPRunner.NET should be able to understand ORDER BY from the SQL query and apply it to the report.
Show us your SQL Query? Does ASPRunner.NET able to parse it on the SQL Query screen?