You can make columns in an SQL Server Reporting Services report sortable, which adds little up and down arrows next to the column header.  To do this, when editing the report in Visual Studio go to the Layout view and right click the table header cell and choose Properties.  Go to the Interactive Sort tab, check Add and interactive sort action to this textbox, and select a sort expression, usually Fields!FieldName.Value.  Do this for each column you want to be sortable, preview it to test and sort until your heart's content.

Comments are closed.