Recursive Calling Subreports

[ralphred]

I'm using CRXIr2 and calling a report for a products components. The components themselves may have sub components up to 7 layers.

ex. Prod1 contains Comp1, Comp2, Comp3 -> Comp3 Contains SubComp1, SubComp2......and so on, with the subcomponents possibly containing more subcomponents.

All the information on the parts and components are in one big table, and breaking the table up is not possible at the moment.

Is there anyway to have it so that the user enters a Product Number, and it displays all the Components and Subcomponents, etc.. all in one report.
Like
Prod
>Comp
>> Subcomp
>>>Sub-SubComp

I have it so that it can display 3 levels as I can't get a sub-report in a sub-report.


Thank you
James

[Crystal Fire]

Try setting up a parameter of Product Number. Using the same parameter in the subreports also.

[JaganEllis]

Have you looked in the help at Hierarchical reports?

[ralphred]

The parameter is fine, it takes it in and passes it to the sub-report, the problem is that you cant have a sub-report in a sub-report. So I can only go 2-3 layers down into the product components, when some have 7 layers.

I am looking into the hierarchy reports, but it seems to be the same sort of problem, I can't have multiple layers. If you know of a different trick with the hierarchy please let me know, but I can only seem to get the same as a sub-report.

To help clear up, there are two fields, prod-parent, and prod-child. User enters a parent and it finds all children. Children can be parents of Children and so on, up to 7 levels, and thats what im trying to see.
>1
>>2
>>>3
>>2
>>2
>>>3
>>>>4

So each child has its children underneath.

Thanks

[ralphred]

Ok after doing the Hierarchy it does work if I don't use any parameters. It gives exactly what I want, the only thing is that with thousands of products and parts, I need to be able to limit to what the user searches for.

Is this possible?


Thanks

[scroller52]

have u tried using a record select formula of some kind?

[ralphred]

Maybe I'm doing it wrong....
I have a group set up, child products, and for that group I have the Hierarchy Report with the Parent product as the parent. The details containing the information on the products.

Ok, so If i limit the search with a record selection on the Prod Parent, then I am missing all the records that are Children of those, missing a lot of important information - any 2nd on level of information.
And If I select it on the Child then it only shows the parent.

Also, when I do not limit the search with any selection formulas, It only brings the 4th level of information at most, sometimes even missing some. I've checked and rechecked the data and nothing seems wrong with the ones it is missing they all have parent information in the parent column and they should link up and be shown under the 4th level as 5, 6 and 7th level information.
Is there a limitation to the number of Hierarchy levels you can have? Or again am I missing something?


Thank you very much for your help

James

[ralphred]

Ok, well it turns out I can't do what I wanted as Hierarchical Grouping only allows for the child to have one parent, and in my case I have some children with many parents.

Thank you all for the help.

James