SSRS report with three "levels" and collapse functionality
-
Hi. 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.
-
Just getting the drill-down isn't actually all that difficult.
1.) Be sure to have a group in your tablix for each level
2.) Add a separate column to your tablix for each level that needs the ability to drill down to a lower level. This column will be used to hold the drill down button.
3.) In your details section have a row whose visibility is controlled by the text box for the drill down button for the next higher level.
4.) In your innermost group section, that row's visibility is controlled by the text box for the drill down button for the next higher level.
5.) Repeat for the next level up, as needed.More detail can be found easily searching for SSRS drill-down.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply