O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Interactive sorting

  1. Adding interactive sorting is also a breeze. Let's go back to our SalesOrderDetailReport and add interactive sorting on the Order QTY column.
  2. Right-click on the header of the Order QTY column, then select Text Box Properties.
  3. Select the Interactive Sorting tab. Select the checkbox where it says Enable interactive sorting on this text box, and select Detail rows to sort.
  4. On the drop-down list where it says Sort by, select [OrderQTY].

    You can also sort by groups as indicated in the other options.

    Interactive sorting
  5. Click on OK when done.

Now, let's try our interactive sorting. Here's the before and after shot of the pre-sort and after sort:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required