October 28, 2014 at 1:01 pm
SSRS 2008 rS
I have a list of properties in a table which I need to assign to arbitrary groups which I can expand and collapse. That is I have a long list of properties which I want to cluster together into a grouping which has a name that I make up and then I need to be able to drill into each of those groups with the + sign.
eg. expanded
+'Region A' 5
Property Bling 3
Property Blang 1
Property Bloom 1
collapsed
-'Region A' 5
IN excel this is possible selecting the items to group, either by clicking and dragging, and then right clicking the selected items, pointing to Group and Show Details on the shortcut menu, and then click Group.
I know I can make changes to sql query to do this grouping, but I want to know how to do in SSRS. How to do this in SSRS or what search terms do I need to google on to find instructions?
November 26, 2014 at 5:00 am
You just need a group, always on the same field?
Right click on the detail row -> Add Group -> Row Group -> Parent Group... and choose the field you're grouping on.
For toggle expand/collapse, right click the detail row again -> Row Visibility -> Choose your desired options.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply