Telerik Reporting R1 2017

Sorting Table 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 sort button to a column header to enable a user to click the column header and sort the details rows in a table by the value displayed in that column.

  1. Open in report design view the Product Catalog example report.

  2. Select the table "List Price" text box located in column header 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 same Table as target from the drop down.

  8. Click OK.

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

    Specifying a sort expression is required.

  10. Click OK.

To verify the sorting action, preview the report, navigate to the Bikes with document map and then click the List Price column interactive sorting button.