asked on

Manager Employee Heirarchy

This is a 2 part question. Query and Reporting
My users need a report where they enter manager(s) name and i need to pull the data of the employees under him to the lowest level

Here is the way they want the report ot look like

Manager parameter : Davis Barela & Kim Wester
Initial view (notice the + sign next to Davis Barela's row)

      dept Employee Manager job dob
      -------------------------------------------------------
+      dept1 Jon Barrett Davis barela GM 5/12/76
      dept3 Brett Vaughn Kim Wester IC 5/12/80
      dept3 Fred Khali Kim Wester IC 5/12/80

When they click on the plus sign

      dept Employee Manager job dob
      -------------------------------------------------------
-      dept1 Jon Barrett Davis barela GM 5/12/76
+      dept2 Chris Weber Jon Barrett DM 5/12/77
      dept3 Atkul Harize Jon Barrett QA 5/12/73
      dept1 Kristin Dey Jon Barrett IC 5/12/72
      dept3 Jim Cook Jon Barrett WF 5/12/80
      dept3 Brett Vaughn Kim Wester IC 5/12/80
      dept3 Fred Khali Kim Wester IC 5/12/80

When they click on the plus sign again

      dept Employee Manager job dob
      -------------------------------------------------------
-      dept1 Jon Barrett Davis barela GM 5/12/76
-      dept2 Chris Weber Jon Barrett DM 5/12/77
      dept2 Sam Auer Chris Weber DM 5/12/77
      dept3 Atkul Harize Jon Barrett QA 5/12/73
      dept1 Kristin Dey Jon Barrett IC 5/12/72
      dept3 Jim Cook Jon Barrett WF 5/12/80
      dept3 Brett Vaughn Kim Wester IC 5/12/80
      dept3 Fred Khali Kim Wester IC 5/12/80

I started working on my query, but i don't know which format i need to get the data to fit this kind of report.

ASKER CERTIFIED SOLUTION

ibrusett

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Raju Srivatsavaye

ASKER

Ibrusett,

Thanks for the quick response. Actually this is the way i started my query. But i need to know the reporting services part of it and need to format the data from the SQL to get the +/- functionality.

Thanks

SOLUTION

Ken Selvia

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Raju Srivatsavaye

ASKER

kselvia,

"Add Level, Employee_ID, Employee_Name, Manager_ID as columns. Add a Column Group (select Matrix1 , Right Click, Add Column Group)"

what is the difference between a column and a column group ( i think they are same)

Thanks
Raju

Raju Srivatsavaye

ASKER

Hi,

I figured it out from this article http://www.sqlservercentral.com/articles/Development/reportingonhierarchicalrecursivedatausingreporting/2476/
Thanks for the help though. (i will share the points between you too :-) )

This is what i did for anybody those need this kind of report.
created a table
created a detailed grouping on the table row.
In the group, i grouped on Employee and set the parent group as manager.
In the visibility tab, set the visibility to hidden and toggle by dept textbox.

Thanks once again for your help

Raju

Raju Srivatsavaye

ASKER

I shared the points between you too. Thanks for the help.