Hi, i'm hoping someone can help with a query I have... I am trying to build a Human Resources Hierachy report - Basically the report has staff names, details such as cost code, and department etc etc, and also their line manager. What I need to do is show a drill-down, starting at the top showing the hierachy for each employee...
For instance, the CEO will have 4 people reporting into him, they will have 8 people each reporting into them, the people reporting into them will have 10 people and so and so.
As an example... The key data I have to build hierachy report on is as follows (along with other fields is as follows):
Forename Surname LM Forename LM Surname
Joe Smith Paul Robinson
Dave Greedy Joe Smith
Ave Garnet Joe Smith
Margeret Simpson Doug Pitt
Steven Wheeler Malcom Tourly
Doug Pitt Graham Score
Andy Wiggins Joe Smith
Barry Charlie Freda McFarlin
Malcom Tourly Samson Bugatti
Adrian Neil Joe Smith
Farah Spoon Dave Greedy
Paul Underearth Ave Garnet
Biddy Small Paul Underearth
So I would like to produce a drill-down report that would everyone, and who reports into them, ensuring that we can make sure that everyone has a line manager, and that someway shape or form, they all eventually link into the CEO, so something like this:
Paul Robinson (CEO)
Joe Smith
Dave Greedy
Farah Spoon
Ave Garnet
Paul Undereath
Biddy Small
Andy Wiggins
Adrien Neil
Hope i've got accross what i'm trying to achieve, and will be hugely grateful for any advice on how to achieve this using Excel (i'm guessing somesort of Pivot Table might be the way forward)
Thank you!
UrbanHim
Crystal XI Report Writer
London
[small]What's good for a hangover?... Heavy drinking the night before!![/small]
For instance, the CEO will have 4 people reporting into him, they will have 8 people each reporting into them, the people reporting into them will have 10 people and so and so.
As an example... The key data I have to build hierachy report on is as follows (along with other fields is as follows):
Forename Surname LM Forename LM Surname
Joe Smith Paul Robinson
Dave Greedy Joe Smith
Ave Garnet Joe Smith
Margeret Simpson Doug Pitt
Steven Wheeler Malcom Tourly
Doug Pitt Graham Score
Andy Wiggins Joe Smith
Barry Charlie Freda McFarlin
Malcom Tourly Samson Bugatti
Adrian Neil Joe Smith
Farah Spoon Dave Greedy
Paul Underearth Ave Garnet
Biddy Small Paul Underearth
So I would like to produce a drill-down report that would everyone, and who reports into them, ensuring that we can make sure that everyone has a line manager, and that someway shape or form, they all eventually link into the CEO, so something like this:
Paul Robinson (CEO)
Joe Smith
Dave Greedy
Farah Spoon
Ave Garnet
Paul Undereath
Biddy Small
Andy Wiggins
Adrien Neil
Hope i've got accross what i'm trying to achieve, and will be hugely grateful for any advice on how to achieve this using Excel (i'm guessing somesort of Pivot Table might be the way forward)
Thank you!
UrbanHim
Crystal XI Report Writer
London
[small]What's good for a hangover?... Heavy drinking the night before!![/small]