(For my own knowledge): What do you attribute the 8 level max depth to?
Are you actually adding 8 instances of the bom table (left outer joining the 1st table instance's component(s) in the boms to the next table instance's parts made from the boms, repeating the relationship with 7 left outer joins)? Or are you doing some kind of recursive looping (effectively creating left outer joins 'on the fly' until the right table returns null)?
...Is there some 'creative way' to perhaps thwart join table depth limits using unions to effectively link the entire query back into another instance of itself?
Just curious.
Rob Brown
Manasa Reddy <manasa@...> wrote:
Mine goes 8 levels, Jim...I could not get it to go further than that.
M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Hartman, Jim
Sent: Tuesday, February 05, 2008 9:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal reports for a BOM
Dale,
I created a crystal BOM report by using multiple instances of the BOM
file and other related files, and daisy chaining them together. In other
words by relating the child from one instance to the parent of the next
instance. This works very well going down 7 levels deep, not sure if it
will work going any deeper.
Jim Hartman
Procurement Engineer
125 Taylor Parkway
Archbold, Ohio 43502
Phone: (419) 445-8915 ext. 235
Fax: (419) 445-8113
NOTICE: This communication may contain privileged or other confidential
information. If you have received it in error, please advise the sender
by reply email, fax, or collect telephone call and immediately delete
the message and any attachments without copying or disclosing the
contents. Thank you.
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal reports for a BOM
Good Morning Everyone,
We are trying to create a crystal BOM report. It does not look like
any of the bom reports are crystal reports. Has anyone created a
crystal BOM report and if so how?
Thanks!
Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432
* Phone: (763) 502-9689 | * Fax: (763) 571-1789
* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com>
<mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/ <http://determan.com/>
<http://console.mxlogic.com/redir/?2C-UUYYed79JdZAQsInd7bNI06xY_yHIenMTv
<http://console.mxlogic.com/redir/?2C-UUYYed79JdZAQsInd7bNI06xY_yHIenMTv
RebqjHnBPqbRTHCQkXFFFLKc6zASO-rdbopS4Z8-qnjh09hbkDFVEwzWRoPEq87qNd46Cy0p
30SrDUvf0srhdFECQTSjhONtNwTDw61-CpFRLz>
"Ambition is the path to success. Persistence is the vehicle you arrive
in."
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.
________________________________
[Non-text portions of this message have been removed]
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender and delete the
material from your system.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
---------------------------------
Never miss a thing. Make Yahoo your homepage.
[Non-text portions of this message have been removed]
Are you actually adding 8 instances of the bom table (left outer joining the 1st table instance's component(s) in the boms to the next table instance's parts made from the boms, repeating the relationship with 7 left outer joins)? Or are you doing some kind of recursive looping (effectively creating left outer joins 'on the fly' until the right table returns null)?
...Is there some 'creative way' to perhaps thwart join table depth limits using unions to effectively link the entire query back into another instance of itself?
Just curious.
Rob Brown
Manasa Reddy <manasa@...> wrote:
Mine goes 8 levels, Jim...I could not get it to go further than that.
M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Hartman, Jim
Sent: Tuesday, February 05, 2008 9:48 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal reports for a BOM
Dale,
I created a crystal BOM report by using multiple instances of the BOM
file and other related files, and daisy chaining them together. In other
words by relating the child from one instance to the parent of the next
instance. This works very well going down 7 levels deep, not sure if it
will work going any deeper.
Jim Hartman
Procurement Engineer
125 Taylor Parkway
Archbold, Ohio 43502
Phone: (419) 445-8915 ext. 235
Fax: (419) 445-8113
NOTICE: This communication may contain privileged or other confidential
information. If you have received it in error, please advise the sender
by reply email, fax, or collect telephone call and immediately delete
the message and any attachments without copying or disclosing the
contents. Thank you.
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dale R. Kalsow
Sent: Tuesday, February 05, 2008 10:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal reports for a BOM
Good Morning Everyone,
We are trying to create a crystal BOM report. It does not look like
any of the bom reports are crystal reports. Has anyone created a
crystal BOM report and if so how?
Thanks!
Dale Kalsow | Information Technologies Director
__________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432
* Phone: (763) 502-9689 | * Fax: (763) 571-1789
* dale.r.kalsow@... <mailto:dale.r.kalsow%40determan.com>
<mailto:dale.r.kalsow%40determan.com> | *
http://determan.com/ <http://determan.com/>
<http://console.mxlogic.com/redir/?2C-UUYYed79JdZAQsInd7bNI06xY_yHIenMTv
<http://console.mxlogic.com/redir/?2C-UUYYed79JdZAQsInd7bNI06xY_yHIenMTv
>HTLuZQnAhNKVKDMDeFteXbxEVbK9IIcBQkXFFFLKce5N4DIpGX0Ux8YhQfVs5h-rsokUz6Hq
RebqjHnBPqbRTHCQkXFFFLKc6zASO-rdbopS4Z8-qnjh09hbkDFVEwzWRoPEq87qNd46Cy0p
30SrDUvf0srhdFECQTSjhONtNwTDw61-CpFRLz>
"Ambition is the path to success. Persistence is the vehicle you arrive
in."
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.
________________________________
[Non-text portions of this message have been removed]
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender and delete the
material from your system.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
---------------------------------
Never miss a thing. Make Yahoo your homepage.
[Non-text portions of this message have been removed]