With the NAV Classic client you can sort data only based on keys that currently exist in the database. The RoleTailored client allows you to sort on any column that is displayed on the report.
Build the report layout as described in the Building the report layout recipe.
Click on View | Layout.
Change the layout so that the data is presented in columns. You can do this by deleting the existing table and dragging a new one from the toolbox to the Body section.
The result should look similar to the following screenshot:
Right-click on the Table Header cell for the Customer No. field and go to Properties.
Click on the Interactive Sort tab.
Check the box for Add an interactive sort action to this textbox.
In the Sort expression: select the Customer No. field.
The properties should be set as follows:
Repeat for the Customer Name textbox.
Compile, save, and close the report layout.
Compile, save, and close the report.
When you run the report you will notice two...