Link to home
Start Free TrialLog in
Avatar of Larry Rungren
Larry RungrenFlag for United States of America

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?
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Taking your question title on board , and assuming your data is stored to represent the hierarchy then Crystal has a Hierarchical grouping option for such reports. CR Help has a big section on it.

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.
Avatar of Larry Rungren

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?
Avatar of Mike McCracken
Mike McCracken

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
1 level
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                     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
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Absolutely super. Simple, straight forward, with all needed to get the structure working,  thanks