SSRS report with three "levels" and collapse functionality

Question

I've been at it for hours (if not days) now, but I just don't understand how to create something like the image below. I created this image manually (with Pixlr) to show what the result should look like. Does anyone know of a tutorial to create a SSRS report looking like this? Or is there someone who can tell me how to get the three levels needed for this report. The data is obviously fake, but it's the way to do it that I would like to know. Thanks a million. Vincent.

Answer 1

You are looking for a stepped report. Here is a nice tutorial from Microsoft.

You gonna end up with the categories (Groups in RS) that looks like this:

Then the folding option (plus/minus sign) is a property you add on the groupings. For example the subcategory in the Row Groups pane, right click/Group Properties/ Visibility and then checkbox 'Display can be toggled by this report item' and choose the category (one level up)

Hope this helps :)