I would use a temporary reporting table for this. The columns to report
would be as follows or both Assy/Sub part numbers and descriptions. I
find that system easier than using report variables.
Assembly
Assembly description
Sub Level 1
Description Level 1
Sub Level 2
Description Level 2
Sub Level 3
Description Level 3
Load the table with a stored procedure, repeating the values in each
column and adding the subs as needed.
Each column would be reported with repeated values hidden. That should
give you what you need.
Albert
On 2015-11-25 8:57 AM, Jim Belisle wrote:
For years we have costed our products with a simple report just throwing
together all parts making up a product not worrying about using an indented BOM.
We would like to go to an indented BOM.
Right now it is just
Model# then all parts making up the model.
We want something like this:
Level 1: Model#
Level 2: Assemblies and parts we ship
Level 3: Sub assemblies (or parts if no subs) making up the
assemblies.
Level 4: Parts making up the sub assemblies.
I can get it so all assemblies are together and then all subs together by
assigning a BOMtype to them.
So it will be:
Assy
Assy
Assy
Sub assy
parts
Sub assy
parts
Sub assy
Parts
That is not however what we want. I just can't seem to figure the proper way to
handle this.
Any blues clues would be appreciated.
James Belisle
Making Information Systems People Friendly Since 1990
[cid:[email protected]]
