SSRS Report Builder Part 5.2 - Sorting and Interactive Sorting in Tables

By Andrew Gould

[mahmud]

after going through multiple documents, and videos whole day, this video helped me to solve the problem, , thank you for sharing knowldedge

[Maguirerichardson]

So helpful - brilliantly explained - thanks

[CavScout]

Awesome. This is exactly what I needed to see. Thank you

[alxvseti]

10:36 Interactive Sorting
12:01 Applying Interactive Sorting to Other Columns

[jennyferhubac]

Hi, thank you for the video with great explanation. One question, I have this report with a tablix that has a row group. I implemented the interactive sort and it works fine within the group. How do I make it work for the entire data. For example, I grouped by Product Category, but when I sort Product Name it only sort within the specific category, I would like the sort to work regardless of the group. Is that possible?

[plasmacannon]

i have a question: say i had one column with shop names, then an a category type (shoes, hats, etc) and then the revenue by that shop in that category. how can i sort by the shops and then have a recurring sort in the category (ie always shoes, then hats, then ...) while the sub category isnt in a logical order (say alphabetically, e.g. i want the final category to be other)?

[abdullahquhtani]

Excellent But how to make interactive sorting if there are nested groups and how to avoid auto collapse of groups when doing so ??

[hisoka]

The video was helpful however how do you create a drop down menu so the user can select which row to sort by by clicking on a drop down option.

[salaiarunmanijb]

How to Sort MMM-YY(Month-YY) format in report builder.