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.

1-column-sorting

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

2-column-sorting

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

3-column-sorting

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.

4-column-sorting

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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