Sep 10, 2007 #1 MapleLeafs MIS Joined Apr 14, 2004 Messages 4 Location US Does anyone have an example of how to create a crystal multi level BOM report? Thanks
Sep 10, 2007 #2 dgillz Instructor Joined Mar 2, 2001 Messages 10,059 Location US Ken Hamady covered this on his blog: http://kenhamady.com/cru/archives/66#more-66 Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports http://www.gainfocus.biz "If the phone doesn't ring, it's me".....Jimmy Buffet Click to expand... Upvote 0 Downvote
Ken Hamady covered this on his blog: http://kenhamady.com/cru/archives/66#more-66 Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports http://www.gainfocus.biz "If the phone doesn't ring, it's me".....Jimmy Buffet Click to expand...
Sep 12, 2007 Thread starter #3 MapleLeafs MIS Joined Apr 14, 2004 Messages 4 Location US Does anyone have an example on how to write this in a SQL stored procedure? Thanks Upvote 0 Downvote
Sep 12, 2007 #4 dgillz Instructor Joined Mar 2, 2001 Messages 10,059 Location US I would post this in the SQL programming forum. Take a little time to fully explain what you want and that you need a recursive query. I would like to see the answer, it should be equally applicable to any multilevel BOM from any ERP package. Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports http://www.gainfocus.biz "What version of URGENT!!! are you using? Upvote 0 Downvote
I would post this in the SQL programming forum. Take a little time to fully explain what you want and that you need a recursive query. I would like to see the answer, it should be equally applicable to any multilevel BOM from any ERP package. Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports http://www.gainfocus.biz "What version of URGENT!!! are you using?