Basically an indented parts list from the Part Master requires writing
progress 4gl code. Though it may be possible in RB or Crystal, I haven't
yet found a way to do so.
The report on the job module is fairly straightforward, because records are
sorted by a master sequence. However, in the partmtl table, a recursive
function is required that extracts child parts, the grandchild's parts, the
grandchild's second-cousin's parts, and so forth.
Actually, the logic is pretty straightforward, though the added variable of
current revisions makes it challenging.
Much thanks to Lonnie Drew and others, I've figured out how to write an
indented BOM report that exports to excel. Some time in the next week I'll
upload it to the files section, once I find the time to get it into
distributable form. I'll be sure to add a sort by part number feature.
Regards,
Thaddeus
-----Original Message-----
From: Darren Mann [mailto:
dmann@...]
Sent: Wednesday, November 14, 2001 9:31 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] BOM Report
Wayne,
I am attempting to get one for the part and having difficulty. Can you
elaborate on the "bunch more difficult..."?
Thanks,
Darren Mann
Miller Products Co.
-----Original Message-----
From: Wayne Cox [mailto:
wmc@...]
Sent: Wednesday, November 14, 2001 8:46 AM
To:
vantage@yahoogroups.com
Subject: Re: [Vantage] BOM Report
At 08:09 AM 11/14/2001, you wrote:
>I'm looking for a report that will output the BOM of an assembly in the
>order of the individual piece part. Is there anyone who has one to share?
Are you trying to get the BOM for a part, or for a job? It's pretty easy
to write in RB by job. JobAsmbl has some pre-calculated fields, BOMLevel
and BOMSequence, that let you sort and print an indented BOM style
report. I can forward a copy if that's what you want. To get it for a
part is a bunch more difficult.
-Wayne Cox
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/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
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/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/