Larry Rungren
asked on
Crystal Reports 9 - Generating a hierarchal report
Need to generate a report that looks like
a mmmmmmmmm
b nnsnsnsnsnsns
f mamamamamama
j ccccccccccccv
total
total
But it needs to run 6 levels deep and I don't see a way to create reports in tree fashion.
Is this possible? and if so does anyone have an example?
a mmmmmmmmm
b nnsnsnsnsnsns
f mamamamamama
j ccccccccccccv
total
total
But it needs to run 6 levels deep and I don't see a way to create reports in tree fashion.
Is this possible? and if so does anyone have an example?
ASKER
Let me be more precise.
I decide to sell a product line for a multi-level marketing group.
I am consultant 100
I recruit 3 people, consultant 120, 130, and 140
Consultants 120 recruits 123, and 127 and number 130 recruits 139 and 160, and 140 recruits 165
database table has columns for Id, and recruited by id
I want to display:
100 Jeff Kingston 100.00
120 Chris Fleming 100.00
123 Jason Curran 65.00
127 Sue Hoey 145.00
Total for 120 310.00
130 Annette Turcotte 85.00
139 David Williams 15.00
160 Nick Sims 270.00
Total for 130 370.00
140 Jonathan Small 450.00
165 Mark Woodbury 120.00
Total for 140 570.00
Total for 100 1,350.00
As these individuals recruit others people the grouping and number of levels increase in depth
Record format
ID char 10
Name char 50
Sales Level int
Sales level id - in the above case 100
Recruited by ID char 10
In your knowledge will this structure be suitable for the hierarchical grouping you mention?
I decide to sell a product line for a multi-level marketing group.
I am consultant 100
I recruit 3 people, consultant 120, 130, and 140
Consultants 120 recruits 123, and 127 and number 130 recruits 139 and 160, and 140 recruits 165
database table has columns for Id, and recruited by id
I want to display:
100 Jeff Kingston 100.00
120 Chris Fleming 100.00
123 Jason Curran 65.00
127 Sue Hoey 145.00
Total for 120 310.00
130 Annette Turcotte 85.00
139 David Williams 15.00
160 Nick Sims 270.00
Total for 130 370.00
140 Jonathan Small 450.00
165 Mark Woodbury 120.00
Total for 140 570.00
Total for 100 1,350.00
As these individuals recruit others people the grouping and number of levels increase in depth
Record format
ID char 10
Name char 50
Sales Level int
Sales level id - in the above case 100
Recruited by ID char 10
In your knowledge will this structure be suitable for the hierarchical grouping you mention?
Have you looked at the hierarchical reporting capcbility of Crystal?
The recruited by would be the hierarchy link
What do top level people have in th elast 2 fields?
mlmcc
The recruited by would be the hierarchy link
What do top level people have in th elast 2 fields?
mlmcc
ASKER
1 level
0 recruited by
0 recruited by
This is the data you have in the table?
ID Name Sales Level Sales level id Recruited by ID
100 Jeff Kingston $100 1 0
120 Chris Fleming 100.00 2 100
123 Jason Curran 65.00 3 123
127 Sue Hoey 145.00 3 123
130 Annette Turcotte 85.00 2 100
139 David Williams 15.00 3 130
160 Nick Sims 270.00 3 130
140 Jonathan Small 450.00 2 100
165 Mark Woodbury 120.00 3 140
mlmcc
ID Name Sales Level Sales level id Recruited by ID
100 Jeff Kingston $100 1 0
120 Chris Fleming 100.00 2 100
123 Jason Curran 65.00 3 123
127 Sue Hoey 145.00 3 123
130 Annette Turcotte 85.00 2 100
139 David Williams 15.00 3 130
160 Nick Sims 270.00 3 130
140 Jonathan Small 450.00 2 100
165 Mark Woodbury 120.00 3 140
mlmcc
ASKER
ID Name Sales Level Sales level id Recruited by ID
100 Jeff Kingston $100 1 0
120 Chris Fleming 100.00 2 100
123 Jason Curran 65.00 3 120
127 Sue Hoey 145.00 3 120
130 Annette Turcotte 85.00 2 100
139 David Williams 15.00 3 130
160 Nick Sims 270.00 3 130
140 Jonathan Small 450.00 2 100
165 Mark Woodbury 120.00 3 140
Difference on id 123 and 127 Recruited by s/b 120
100 Jeff Kingston $100 1 0
120 Chris Fleming 100.00 2 100
123 Jason Curran 65.00 3 120
127 Sue Hoey 145.00 3 120
130 Annette Turcotte 85.00 2 100
139 David Williams 15.00 3 130
160 Nick Sims 270.00 3 130
140 Jonathan Small 450.00 2 100
165 Mark Woodbury 120.00 3 140
Difference on id 123 and 127 Recruited by s/b 120
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Absolutely super. Simple, straight forward, with all needed to get the structure working, thanks
However it is not possible to deduce from your example that this is actually a hierarchical grouping. It could just as easily represent a standard multi-level grouping structure.