Ordering the Report Details

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 page, group or report header item to enable a user to click the item adorner and sort the report details by the selected expression.

1. Open in report design view the SalesOrderDetails report that is used as subreport for the Invoice example report.
2. In report design view, select the Quantity group header textbox, to which we want to add an interactive sorting button.
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 Report name (SalesOrderDetails) from the drop down.
8. Click OK.
9. In Sort expressions drop-down select the field or write expression for which you are defining a sorting action For our example, set the expression to =Fields.OrderQty. Specifying a sort expression is required.
10. Click OK.

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