Adding dynamic sorting
It is incredibly easy to add sorting to the table. Open any report which contains
the table. Navigate to the
Layout tab of the report designer. Click
in the cell labeled
First Name in the header of the table. Right-click
and select
Properties. Switch to the
Interactive Sort
tab. Check the checkbox for 'Add an interactive sort action to this textbox'. Next,
set the Sort expression to the value that is displayed in the column – in this case
=Fields!FirstName.Value. Now repeat this process for the rest of
the report.
Preview the report, and you should have interactive sorting on
each column.
