Reporting installation with the Examples feature
MS SQL server with AdventureWorks
The examples are located in (Replace: Reporting X with your installation version)
Standalone Report Designer - %PROGRAMFILES(x86)%\Reporting X\Report Designer\Examples
Visual Studio Integrated Designer – %PROGRAMFILES(x86)%\Reporting X\Examples\CSharp\
Add an interactive sort button to a column header to enable a user to click the column header and sort the details rows in a table by the value displayed in that column.
Open in report design view the Product Catalog example report.
Select the table "List Price" text box located in column header to which we want to add an interactive sorting button.
From Properties window open the Actions editor.
Select Sorting option.
Click Edit sort targets button to open Edit Sorting Action targets editor.
Click New to add a new target.
Select the same Table as target from the drop down.
In Sort expressions drop-down select the field that corresponds to the column for which you are defining a sorting action. In this case use the =Fields.ListPrice expression.
Specifying a sort expression is required.
To verify the sorting action, preview the report, navigate to the Bikes with document map and then click the List Price column interactive sorting button.