Adding interactive sorting on reports

After a classic report is generated, no change can be made on the sorting of data, whereas an RDLC report offers the option of interactive sorting. The following recipe will guide you to add interactive sorting on a report.

How to do it...

  1. First, create a report by following the Creating an RDLC report recipe.
  2. Open the report in the designer mode and navigate to View | Layout (Alt + V, Y) to alter the report visual layout.
  3. Right-click on the No. Customer cell and select Table Box Properties.
  4. Select the Interactive Sorting tab.
  5. Under Change interactive sort options for the text box, select the Enable interactive sorting on this text box checkbox:
    How to do it...
  6. In the Sort by drop-down list, select the No_Customer field. Click on OK to close the properties window:
    How to do it...
  7. Right-click on the Name cell and select Table Box Properties.
  8. Select the Interactive Sorting tab.
  9. Under Change interactive sort options for the text box, select the Enable interactive sorting on this text box checkbox.
  10. In the Sort by drop-down list, select the Name_Customer field. Click on OK to close the properties window.
  11. Save and close the report.
  12. On execution of the report, you should see a window similar to the following screenshot:
    How to do it...

How it works...

Interactive sorting will enable users to interactively change the sort order for the data columns. To change the sort order between ascending and descending order, select the sort control button in the column header.

See also

  • Adding custom filters to the Request Page
  • Setting filters when report is loaded
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.189.182.96