Hello, let me start by saying I have already been told this cannot be done in Crystal. I keep hoping there is a way. I need about 4 or 5 iterations of a table to drill down into the table. I have one iteration in the main report, and one in the subreport, so i can go down one level. I learned that subreports cannot be placed within subreports. Does anyone have any other ideas? i have tried just about everything i could think of.

Thanks!

Well, i have a Bill of Material Table has a parent and a part(s) underneath it. so i used the inventory file to connect to the Parent of the table to pick up the part, then wanted to connect the part to another parent in another iteration of the table, and so on and it could be up to 4 or 5 levels down i would want to go.

so it would look like this:

Parent
Part
Part
   Part

no, it won't allow me to do that. It lets me create them BOM_MSTR, BOM_MSTR1, BOM_MSTR2 etc. but won't pull the data correctly. i have tried everything.

Edited by Kitty1 - 16 Sep 2016 at 8:31am

Hi, sorry for the delayed response, i was on vacation last week... i have never done an SQL. but it may be worth trying to look into. Thanks!