BrianFord
asked on
Sorting problem in SQL Server Reporting Services
I have an SSRS report which is not sorting the data as I expect it.
The SQL query has an order by on a date column in DESCENDING order and when I run the query everything is fne, however when I preview or deploy the report it is orderd by the date column in ASCENDING order.
Has anyone come across this before, what am I missing??
see screenshots, one shows the query and reults in teh Data tab and the other is the resulting report
Thanks
Data.jpg
report.jpg
The SQL query has an order by on a date column in DESCENDING order and when I run the query everything is fne, however when I preview or deploy the report it is orderd by the date column in ASCENDING order.
Has anyone come across this before, what am I missing??
see screenshots, one shows the query and reults in teh Data tab and the other is the resulting report
Thanks
Data.jpg
report.jpg
Are you grouping on Date? If so, are you setting the sort on the details or within the group? It should be set within he group.
ASKER
the sort is actually being done in the underlying sql view and this can be seen in the first screenshot although I am grouping by the date in the report, how do I change the sort order in the report grouping?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, it now works :)
Make sure you don't have sorting saved in the report.
Gary