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