In SSRS 2005, three options are available to sort results on a report: -
Make the data source (database) sort data on data retrieval by using an ORDER BY clause. -
Make SSRS sort data during report generation. SSRS sorts items that have the Sorting property defined. -
Use the new, interactive sort functionality for HTML-rendered reports only. This functionality makes SSRS regenerate a report with a new direction: ascending or descending. The RDL that describes sorting is as follows : <Sorting> <SortBy> <SortExpression>=Fields!Name.Value</SortExpression> <Direction>Ascending</Direction> </SortBy> </Sorting> |