Hierarchical report in SSRS to show users and their managers (CRM)


Hi,

Just created a simple SSRS report that shows the Hierarchy of the users and their manager.

This is how the report looks like

The DataSet query used

Select the row, right click and select group properties option

Select Grouping based on systemuserid

Toggle the visibility based on FullName

Select parentsystemuserid as Recursive Parent from the Advanced option

Set the Left Padding property for the fullname TextBox.

Set the expression for level as Level()

The posts from which I learned creating the hierarchical reports

http://blog.infotoad.com/post/2009/08/10/Working-with-a-Recursive-Hierarchy-Group-in-SQL-Reporting-Services-2008.aspx

http://blog.davyknuysen.be/2010/04/16/parent-child-hierarchies-in-reporting-services/

Bye.

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

3 thoughts on “Hierarchical report in SSRS to show users and their managers (CRM)”

  1. Hi,

    Can you please share the SQL query to find the Hierarchy of the users and their manager. I also need to build a similar report.

    Thanks in advance.

    Like

  2. Hi Nishant,

    I have created recursive ssrs report successfully, I want to apply search option of “full name” on top of that report, when I am applying the parameter search then it is giving result but not with hierarchy. can you suggest me how I would get the result with search having hierarchy.

    Like

Please share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.