Enabling Tree View and customizing it to pass parameters to data region on user selection
Requirement: To enable a tree view in the report to browse the different hierarchies. On selection of the value at any hierarchy the corresponding data shall be shown in the tablix.
The following sample was tried using the Adventure Works data in SQL Server 2008 Reporting Services.
My first challenge was to establish the tree structure .
I did that in a matter of seconds ,but I was told to have the data in one column only . LI did some browsing and I came up with the following solution.
Right click on the last hierarchy level
Then select Insert Rows -> Outside GroupAbove
You will get a new texbox above .Copy the value from the previous column (towards the left ) in to this texbox.
