Ordering Multiple Items/Groups

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 a parent for all targets item to enable a user to click the item adorner and sort the target data items/groups by the selected expression.

1. Open in report design view the Dashboard example report.
2. Select item to which you want to add an interactive sorting button. The selected item should be parent to the target groups/data items. For this how to use the report header section text box with Quaterly Sales 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 group/data item name from the drop down. For this report use SalesPersonFullName (TableGroup).
8. Click OK.
9. Click New to add a new target.
10. Select the StoreName (TableGroup).
11. Click OK.
12. In Sort expressions drop-down select the field or write expression for which you are defining a sorting action. In this case, you have to use the =Sum(Fields.LineTotal) expression. Specifying a sort expression is required.
13. Click OK.

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