Ordering the Crosstab Top-Level Group
Prerequisites:
- 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.
- Click OK.
- 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, that would be
=Fields.ProductCategory
. Specifying a sort expression is required. - Click OK.
To verify the sorting action, preview the report, and then click the interactive sorting button.