Implementing Sorting in your Reporting Services Report

Adding the ability to sort data in a report is a definite usability enhancement, but Reporting Services can do more than just single column sorting. Join the leader of the Tampa SQL Group as she shows you how to customize sorts that will wow your customers!

Pam Shaw has been in IT for over 27 years. For the last 8 years, She has been working with SQL Server, first 2000 and then 2005. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS.

Venkata Taduri on 2/27/2009

Good stuff

01EFFB45CF on 4/20/2009

Keep 'em coming. Easy, hard, it's a good mix.

David Stein on 4/20/2009

I really wish she would speak up.

thomas taylor on 4/20/2009

great

Marc Moshman on 4/20/2009

example didn't hang together with the description, or it happened but I didn't see it because the video moved by a bit quickly

Paul on 4/20/2009

Good tip for me, a newbie developer!

david on 4/21/2009

Great video, nice clear explanation.

adalberto on 4/24/2009

good tip , thanks

Prasanna Prabhu on 5/1/2009

With sorting enabled on "Title" column it was very simple to understand that SORT was only on 1 column, but with other 2 columns (Genre & Location) the SORTING was done on multiple columns. Say, me as an end-user who will be viewing/reading this report for the 1st time, how will I know that SORTING is defined on multiple column (2 in this case) when I click SORT on "Genre" on "Location". Is there any visual way of displaying that information. I wish your video covered that aspects too. No complaint, but liked your video.

Dipak Saha on 5/1/2009

Nice video.

Charlie Bruno on 3/2/2010

I learned something new. Informative and useful.

ioana on 4/13/2010

short and concise not much to learn but it is a good 2 minutes spent

Kimala on 8/25/2010

It's a good simple 'How to' video

Brynn Binnell on 9/14/2011

She sounds half asleep

Paul on 9/14/2011

Basic stuff, good info for newbies, nice refresher for those that haven't worked with Reporting Services in awhile. Thank you!

Alex Fredrich on 9/14/2011

Just what I was looking for! Thanks

Vamsi on 9/14/2011

good

Shaunna Shelton on 9/14/2011

An easier way is to just user interactive sort.

Leonard Peoples on 9/14/2011

Very nice. And its easy too. Thanks for sharing

Rajiv Gupta on 9/15/2011

Answer is wrong!

John O'Sullivan on 9/15/2011

excellent tip

SQLWayne on 9/15/2011

This was a nice simple explanation. What I would like to know is if/how this can be done on a matrix.

Maurice Ivory on 2/22/2012

I enjoyed this video.