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 sorting button to crosstab header (top-level static group or corner item) to enable interactive sort for top level group in a crosstab. The order of the child groups remains unchanged.
Open in report design view the Product Sales example report.
In report design view, select the crosstab corner with (USD IN THOUSANDS) text;
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 target dynamic group (ProductCategory) from the drop down.
In the Sort expressions drop-down select the field that corresponds to the column for which you are defining a sorting action. In this example this is =Fields.ProductCategory.
Specifying a sort expression is required.
To verify the sorting action, preview the report, and then click the interactive sorting button.