Print Page | Close Window

Bill of Material Report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22230
Printed Date: 02 May 2024 at 1:38pm


Topic: Bill of Material Report
Posted By: highrise955
Subject: Bill of Material Report
Date Posted: 09 Feb 2017 at 10:33am
Hello all,

I am hoping someone can point me in the right direction (previous asked and answered question or video out there somewhere) about the following issue...

I have a single table in a db called "Materials".
This db lists all the part numbers (PartNo) in our shop that are not purchased outright as finished goods (i.e. assemblies, raw material...)

For example, Part "ABC" may be shown in the table as...

PartNo
SubPartNo
Desc
ABC
123
Plate
ABC
456
Handle
ABC
789
Bolt
123
ZYX
Washer

"ABC" will be listed in the PartNo column for each SubPartNo that belongs to it. The Desc column is describing the SubPartNo.

The last row shows part "123" which is a sub part of "ABC" but also contains sub parts of its own (ex. "ZYX"). This could go on for several sub-levels. ("ZYX" have sub-parts, those sub-parts have sub-parts, so on and so on.)

What I want to do is create a report that will list a PartNo of my choice and then in an indented format list all the sub-parts down to the lowest level.

Hopefully I have explained this well enough. I don't want to be hand held through the process but maybe a gentle shove in the right direction.

Thanks!


Replies:
Posted By: DBlank
Date Posted: 10 Feb 2017 at 8:10am
I would recommend looking at hierarchical grouping which can use conditional indenting per hierarchy level

http://crystalreportsbook.com/Forum/forum_posts.asp?TID=19480



Posted By: highrise955
Date Posted: 10 Feb 2017 at 8:17am
Thanks!

I'll take a look at that and see if it is what I need. Smile

Posted By: brockloch
Date Posted: 03 Mar 2017 at 1:49am
Just wondering if you got your BOM report to work, as I have had the similar problem and never found a solution?
Ed

-------------
brockloch


Print Page | Close Window