Just created a simple SSRS report that shows the Hierarchy of the users and their manager.
This is how the report looks like
![](https://nishantrana.files.wordpress.com/2012/04/042912_0706_hierarchica1.png?w=840)
The DataSet query used
![](https://nishantrana.files.wordpress.com/2012/04/042912_0706_hierarchica2.png?w=840)
Select the row, right click and select group properties option
![](https://nishantrana.files.wordpress.com/2012/04/042912_0706_hierarchica3.png?w=840)
Select Grouping based on systemuserid
![](https://nishantrana.files.wordpress.com/2012/04/042912_0706_hierarchica4.png?w=840)
Toggle the visibility based on FullName
![](https://nishantrana.files.wordpress.com/2012/04/042912_0706_hierarchica5.png?w=840)
Select parentsystemuserid as Recursive Parent from the Advanced option
![](https://nishantrana.files.wordpress.com/2012/04/042912_0706_hierarchica6.png?w=840)
Set the Left Padding property for the fullname TextBox.
![](https://nishantrana.files.wordpress.com/2012/04/042912_0706_hierarchica7.png?w=840)
![](https://nishantrana.files.wordpress.com/2012/04/042912_0706_hierarchica8.png?w=840)
Set the expression for level as Level()
![](https://nishantrana.files.wordpress.com/2012/04/042912_0706_hierarchica9.png?w=840)
The posts from which I learned creating the hierarchical rep
No comments:
Post a Comment