July 13, 2009 at 5:51 am
Hi all,
Ive created a recursive hierarchy report based on employees reporting to bosses.
Each employee who has subordinate employees will appear unexpanded with a "plus (+)" symbol beside their name.
Each employee (including bosses) has associated expenses under 5 categories.
I can currently display the above, but I am required to make the following changes.
The expenses figures for a boss employee with subordinate employees, will all be totals of the bosses expenses PLUS the expenses for each subordinate employee...
subordinate employees CAN in turn have their OWN subordinates.
To make it more complicated, when you expand a boss employee, they want one of the subordinate indented rows to also contain the expanded boss employees individual expenses.
Therefore
if a boss, employee 1 has subordinate employees 2 and 3
and employee 3 is also a lower level boss and has a subordinate - employee 4
and each of their individual expenses were as follows:
employee1 €100 employee2 €240 employee 3 €160 employee 4 €200
on the report it CURRENTLY appears as follows
+Employee1 100
when you expand it it appears as follows
- Employee1 100
Employee2 240
+ Employee3 160
and fully expanded
- Employee1 100
Employee2 240
Employee3 160
- Employee4 200
Im required to have it appear as follows:
+Employee1 700
when you expand it it appears as follows
- Employee1 700
Employee1 100
Employee2 240
+ Employee3 360
and fully expanded
- Employee1 700
Employee1 100
Employee2 240
- Employee3 360
Employee3 160
Employee4 200
What sort of grouping do I need to do on this?
Ive already used a detail group with child and parent dependency for the expanding hierarchy, but i assume i need to group of sum the totals too within this hierarchy?
any help or pointers are greatly appreciated. :unsure:
July 13, 2009 at 10:57 am
Could you post some sample data to test with? Use the format in the first link in my signature line.
If you post the code you are using to get the Counts that might help too.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply