Iterations of tables
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22088
Printed Date: 01 May 2024 at 2:55pm
Topic: Iterations of tables
Posted By: Kitty1
Subject: Iterations of tables
Date Posted: 16 Sep 2016 at 5:56am
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!
|
Replies:
Posted By: DBlank
Date Posted: 16 Sep 2016 at 6:35am
|
can you explain more your scenario?
|
Posted By: Kitty1
Date Posted: 16 Sep 2016 at 7:35am
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
|
Posted By: DBlank
Date Posted: 16 Sep 2016 at 7:58am
and this is not a hierarchy model?
and you cannot just alias join the table to itself multiple times?
|
Posted By: Kitty1
Date Posted: 16 Sep 2016 at 8:00am
|
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.
|
Posted By: kevlray
Date Posted: 19 Sep 2016 at 4:26am
|
Can you create a command (SQL statement) to get the data you need? One thought is have sub-reports that will be show/hidden on demand (FYI: I have never tried this, so I am not even sure how to set it up).
|
Posted By: Kitty1
Date Posted: 26 Sep 2016 at 2:40am
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!
|
|