I have, but I did a fair amount of work to get to it.
I'm on 8.03.408B MSSQL.
To accomplish what I wanted to do, I wrote a C#/.NET program that
takes a list of top-level manufactured parts with a BOM, and for each
part, explode the BOM and capture some details. I process this data and
store it in UD03. UD03.Key1 contains the top-level partnum. UD03.Key3
contains the sub-component partnum. I call this program BOMCache since
is creates a cache of exploded BOM info. This info doesn't change that
quickly, so refreshing the BOMCache nightly seems reasonable.
I can then use this in table joins to bring in, for a purchased part,
the top-level assemblies that part is used in. I can then do grouping
in Crystal and hide detail sections, etc. depending on how I've
constructed my queries to do some powerful analysis.
This only works in MSSQL since you can use common table expression
(CTE) queries to deal with hierarchical data structures.
I'm happy to share the source code if someone wants it. The whole
thing is configuration driven via a config.xml file.
-bws
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of advantage@...
Sent: Monday, October 25, 2010 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Where Used - Crystal Report Epicor 9.04.506b
Has any one created a Where-Used Report in Crystal?
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
I'm on 8.03.408B MSSQL.
To accomplish what I wanted to do, I wrote a C#/.NET program that
takes a list of top-level manufactured parts with a BOM, and for each
part, explode the BOM and capture some details. I process this data and
store it in UD03. UD03.Key1 contains the top-level partnum. UD03.Key3
contains the sub-component partnum. I call this program BOMCache since
is creates a cache of exploded BOM info. This info doesn't change that
quickly, so refreshing the BOMCache nightly seems reasonable.
I can then use this in table joins to bring in, for a purchased part,
the top-level assemblies that part is used in. I can then do grouping
in Crystal and hide detail sections, etc. depending on how I've
constructed my queries to do some powerful analysis.
This only works in MSSQL since you can use common table expression
(CTE) queries to deal with hierarchical data structures.
I'm happy to share the source code if someone wants it. The whole
thing is configuration driven via a config.xml file.
-bws
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of advantage@...
Sent: Monday, October 25, 2010 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Where Used - Crystal Report Epicor 9.04.506b
Has any one created a Where-Used Report in Crystal?
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links