SSRS: Column Sorting

Applying sort ability to columns.

When report data exceeded many pages, it’s important to provide a mechanism for users to easily change the sequence of the rows.

I’l begin with an existing report which displays 7 pages of data concerning employee sick hours.


To apply a sort to the Title column, I’ll configure Interactive Sorting on its textbox properties.


Upon executing the report, I now see arrows in the column header which provide sorting capability.


When I click the arrow, it sorts the records alphabetically, from A-Z.
To sort the records Z-A, I just click the arrow again.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s