Sorting, Including Interactive User Sorting

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>