Ragged Hierarchies

[smither]

I was wondering if anyone has worked with ragged hierarchies before. If so, I was wondering how you were able to report from it. In general I have a hierarchy that looks like this.

1000 (lvl 3)
1100 (lvl 4)
1110 (lvl 5)
1120 (lvl 5)
1200 (lvl 4)
1210 (lvl 5)
1215 (lvl 6)
1216 (lvl 6)
1220 (lvl 5)
1300 (lvl 4)
.
.
etc.

It goes down several a couple of more levels and does have a maximum number of levels. The problem is getting subtotals for each of the different levels. Depending on who the audience is the report needs to be able able to run at different levels. If you are a manager you would look run the report for say level 5 and everything under it would aggregate upwards.

Thanks
S

 

[satinsilhouette]

Did you look at group hierarchies in CR?

Thanks so much!
satinsilhouette

 

[lbass]

You could create formulas, one for each level, like this, assuming the field is a 4-digit number:

//{@lvl3}:
int({table.number}/1000)*1000

//{@lvl4}:
int({table.number}/100)*100

//{@lvl5}:
int({table.number}/10)*10

Level 6 would = {table.number}.

Insert a group on each of these, in this order and then you can insert summaries on detail fields at each group level. You should then be able to use conditional formulas to suppress groups depending upon the audience. Not sure how you are determining that--you could use a parameter.

-LB