Applying Interactive Sorting to Multiple Columns in Reporting Services

re: Applying Interactive Sorting to Multiple Columns in Reporting Services

David Wimbush — Thu, 17 Mar 2011 08:42:25 GMT

Wow! Thanks for sharing that one, Stacia. My users are going to love that. It's surprising how often something really good like this comes to light that just got left out of the documentation. Did you just find it by accident or something?

re: Applying Interactive Sorting to Multiple Columns in Reporting Services

GrumpyOldDBA — Thu, 17 Mar 2011 13:19:03 GMT

that's one I didn't know! btw interactive sorting was in sql 2005 SSRS and your trick works in ssrs2005 too - very useful - thankyou

re: Applying Interactive Sorting to Multiple Columns in Reporting Services

smisner — Thu, 17 Mar 2011 14:32:06 GMT

GrumpyOldDBA - thanks for letting me know. I looked at the versions associated with the topic in BOL and didn't see 2005 listed, and didn't have an instance handy. I guess I should have looked in my own book since I would have covered it!

David - I was teaching a class a few years ago (which now that I think of it was most probably an SSRS2005 class!) and one of the students pointed it out to me. I was not the one to uncover this. Frankly, none of my client implementations take advantage of this feature. It doesn't work well for all layouts, especially the layouts that my clients want!

re: Applying Interactive Sorting to Multiple Columns in Reporting Services

Fenix33 — Mon, 02 Jul 2012 23:05:27 GMT

I love you smisner! works a treat

re: Applying Interactive Sorting to Multiple Columns in Reporting Services

smisner — Mon, 02 Jul 2012 23:26:15 GMT

Happy to help! :)

re: Applying Interactive Sorting to Multiple Columns in Reporting Services

sia — Mon, 03 Sep 2012 15:49:28 GMT

Thanks, nice and simple..;)

re: Applying Interactive Sorting to Multiple Columns in Reporting Services

Gabszig — Wed, 14 Nov 2012 09:08:00 GMT

Wos, this is great, good find!