Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Iterations of tables Post Reply Post New Topic
Author Message
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Topic: Iterations of tables
    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!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Sep 2016 at 6:35am
can you explain more your scenario?
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet 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

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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?
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet 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.

Edited by Kitty1 - 16 Sep 2016 at 8:31am
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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).
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet 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!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.