ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Crystal Reports BOM Report
http://www.istechforum.com/YaBB.pl?num=1080753048

Message started by awaretec on 03/31/04 at 09:10:48

Title: Crystal Reports BOM Report
Post by awaretec on 03/31/04 at 09:10:48

I would like to create the BOM report in Crystal Reports so that I can customize it. But so far, I've only managed to get the first level of components to show up. Any idea how I can get the 2nd, 3rd, etc. levels on my custom report?

Title: Re: Crystal Reports BOM Report
Post by Tim Keating on 03/31/04 at 10:13:42

This is how I would do it:

1. Add the BKBMMSTR to your report again. You will get a message indicating it is already in the report and will be promped to give it an alias name.

2. Name it BKBMMSTR2.

3. Clear any automatic links that were created and create a link from BKBM_COMPONENT in the BKBMMSTR file to BKBM_PARENT in the BKBMMSTR2 File.

4. Repeat this procedure as many times as you need to depending on the depth of your BOM's. We have 4 levels so we have 4 instances of the BKBMMSTR File. (BKBMMSTR thru BKBMMSTR3 all linked as described above.)

5. Create your report using proper grouping and sorting methods. You can pull part descriptions by linking all Parent and Component fields back to BKICMSTR File BKIC-PROD_DESC Field.

Title: Re: Crystal Reports BOM Report
Post by awaretec on 04/15/04 at 10:42:36

Thanks for your help! I was able to finish the report with the tips you provided.