Ordering the Table Details

This document demonstrates how to enable interactive sorting with the Standalone Report Designer or with the Visual Studio Report Designer.

Prerequisites

To follow the steps in this guide, you need the following:

• A Telerik Reporting installation with an enabled Examples feature
• Microsoft SQL Server with AdventureWorks

Procedure

The following steps describe how to add an interactive sort button to a column header in the Detail Section of a report. This enables a user to click on the button and sort the table rows by the value displayed in that column.

1. Locate the Product Catalog sample report and open it with the Standalone Report Designer or with the Visual Studio Report Designer. Depending on the Report Designer of your choice, you will locate the Product Catalog sample report in one of the following folders:

   • Examples for the Standalone Report Designer - %PROGRAMFILES(x86)%\Progress\Telerik Reporting {Version}\Report Designer\Examples
   • Examples for the Visual Studio Report Designer – %PROGRAMFILES(x86)%\Progress\Telerik Reporting {Version}\Examples\CSharp\

   Replace {Version} in the Examples path with your Telerik Reporting version.

2. In the Report Designer, make sure you use Design View.

3. Select the List Price text box - this is the column header where we want to add an interactive sorting button.
4. In the Properties window, open the Action editor.
5. Select the Sorting action.
6. Click the Select sort targets button. The Edit Sorting Action targets window appears.
7. Click the New button to add a new target.
8. Select table1 (Table) in the drop-down and click OK.

9. In the Sort expressions drop-down menu, select the field that corresponds to the column for which you are defining a sorting action. In this case, use the =Fields.ListPrice expression and click OK.

   Specifying a sort expression is required.

To verify the sorting action:

1. Preview the report
2. Navigate to Bikes in the document map.
3. Click the List Price column interactive sorting button.