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.

1. Open in report design view the Product Sales example report.
2. In report design view, select the crosstab corner with (USD IN THOUSANDS) text.
3. From Properties window open the Actions editor.
4. Select Sorting option.
5. Click Edit sort targets button to open Edit Sorting Action targets editor.
6. Click New to add a new target.
7. Select the target dynamic group (ProductCategory) from the drop down.
8. Click OK.
9. 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.
10. Click OK.

To verify the sorting action, preview the report, and then click the interactive sorting button.