Raju Srivatsavaye
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
"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
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
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
ASKER
I shared the points between you too. Thanks for the help.
ASKER
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