BOM Report- Crystal Report

[bUAYa99]

Hi,
Anyone can help to get the BOM explosion up to level 11 using CR? i'm using Macola v7.5.102i

 

[battenbergs]

I'm currently trying to make a report that is similar, and have nested the table bmprdstr to an alias of its self using Item no and comp Item no with a Left Outer link, then linked to imitmdx for discriptions. I can email you a copy if you want.
What I have done only goes to 5 levels but its expandable up to 11. Its not very pretty (i'm only writing it to see if I can get a report of what I want and this was the 1st step.)

 

[bUAYa99]

Hello Battenbergs,
Thanks for your reply. Appreciated if you can forward the copy to me. BTW, what is the CR version you use?

 

[2x4]

You have the right idea with nesting the bmprdstr in the report. Only sugguestion, if you need to use it repeatedly, do the nesting in a SQL view and then you could link to the view from crystal.

 

[dgillz]

Peter Shirley has a solution for this. Please check out

http://www.erpessentials.com

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html