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?
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)?
You could create a calculated column using either a CASE expression in the SQL select statement or the SWITCH function in the expression builder to calculate the sort order you want. For example: =Switch( Fields!ProductType.Value = "Shoes", 1, Fields!ProductType.Value = "Hats", 2, True, 3) You can then sort by this new column. Here's the video on the Switch function th-cam.com/video/eWYltHUr9-0/w-d-xo.html Hope it helps!
Hi! On the Interactive Sorting page of the Text Box Properties dialog box you can choose whether clicking the text box should affect detail rows or groups. If you choose groups, you can choose which group to apply the sorting too. The group won't auto-collapse if you click the interactive sorting button (or at least it shouldn't). Try setting the Hidden property of the tablix members to False if you're having trouble with this. I hope it helps!
Hi, the technique you can use to do this is described in this video th-cam.com/video/vgtVJf21EXU/w-d-xo.html The video shows how to create a dynamic matrix using Visual Studio but you can replicate the technique in Report Builder easily enough. I hope that helps!
Hi! You'll need an expression (either in a calculated field or in the sort expression) which formats the date as YYYYMM and then use this to sort. Hope it helps!
after going through multiple documents, and videos whole day, this video helped me to solve the problem,, thank you for sharing knowldedge
Happy to hear that it helped you, thanks for watching!
So helpful - brilliantly explained - thanks
Thanks, happy to hear that it helped!
Awesome. This is exactly what I needed to see. Thank you
You're very welcome, happy to hear you found it useful!
10:36 Interactive Sorting
12:01 Applying Interactive Sorting to Other Columns
Thank you,
You're welcome Anton, thanks for watching!
Thank u
You're welcome, thanks for watching!
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?
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)?
You could create a calculated column using either a CASE expression in the SQL select statement or the SWITCH function in the expression builder to calculate the sort order you want. For example:
=Switch(
Fields!ProductType.Value = "Shoes", 1,
Fields!ProductType.Value = "Hats", 2,
True, 3)
You can then sort by this new column. Here's the video on the Switch function th-cam.com/video/eWYltHUr9-0/w-d-xo.html
Hope it helps!
great
Thank you Volkan!
Excellent But how to make interactive sorting if there are nested groups and how to avoid auto collapse of groups when doing so ??
Hi! On the Interactive Sorting page of the Text Box Properties dialog box you can choose whether clicking the text box should affect detail rows or groups. If you choose groups, you can choose which group to apply the sorting too. The group won't auto-collapse if you click the interactive sorting button (or at least it shouldn't). Try setting the Hidden property of the tablix members to False if you're having trouble with this. I hope it helps!
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.
Hi, the technique you can use to do this is described in this video th-cam.com/video/vgtVJf21EXU/w-d-xo.html
The video shows how to create a dynamic matrix using Visual Studio but you can replicate the technique in Report Builder easily enough.
I hope that helps!
How to Sort MMM-YY(Month-YY) format in report builder.
Hi! You'll need an expression (either in a calculated field or in the sort expression) which formats the date as YYYYMM and then use this to sort. Hope it helps!