kwalters110
MIS
Crystal Reports 8.5
Hi everyone, I could really use some help on this.
What I am trying to accomplish is generate a list that shows each piece of raw material for an assembly. It would like like follows:
Assembly 1
Raw Material 1
Component 1
Component 2
Raw Material 2
Component 1
Assembly 1
Raw Material 3
Component 3
In the table above, Assembly 1 has 3 components that use raw material. Component 1 has two different pieces of raw material. You should also note that Raw Material 2 is used directly on the assembly was well as component 1.
I was hoping I could get this using hierarchical grouping but so far I haven't had much luck. I am using the BOM view which has two fields: PARENT and PART. A PARENT can be any assembly or component, and a PART can be any component or raw material. So an assembly can have be made up of compents and/or raw material, and a component can be made up of other components and/or raw material.
Now that I got most of the technical stuff out of the way, here is what I have tried:
First I just added the V_BOM_MSTR view to the report, created a group on the {V_BOM_MSTR.PART} field and setup hierarchical grouping using {V_BOM_MSTR.PARENT} as the Parent instance field. This will give me the traversed tree where each Group #1 was an item on the bill of material, and each item of detail was the parent for that particular Group.
Thats exactly what I want to show but how can I select only the items for that particular assembly?
If you go into record selection and say {V_BOM_MSTR.PARENT} = {?Part} the record selection will only work for the first level of items in the BOM. If you have an item that is 3 levels deep (i.e. Assembly -> Component -> Raw Material) then the record selection will want the component to equal the {?Part}.
Any help would be greatly appreciated.
Hi everyone, I could really use some help on this.
What I am trying to accomplish is generate a list that shows each piece of raw material for an assembly. It would like like follows:
Assembly 1
Raw Material 1
Component 1
Component 2
Raw Material 2
Component 1
Assembly 1
Raw Material 3
Component 3
In the table above, Assembly 1 has 3 components that use raw material. Component 1 has two different pieces of raw material. You should also note that Raw Material 2 is used directly on the assembly was well as component 1.
I was hoping I could get this using hierarchical grouping but so far I haven't had much luck. I am using the BOM view which has two fields: PARENT and PART. A PARENT can be any assembly or component, and a PART can be any component or raw material. So an assembly can have be made up of compents and/or raw material, and a component can be made up of other components and/or raw material.
Now that I got most of the technical stuff out of the way, here is what I have tried:
First I just added the V_BOM_MSTR view to the report, created a group on the {V_BOM_MSTR.PART} field and setup hierarchical grouping using {V_BOM_MSTR.PARENT} as the Parent instance field. This will give me the traversed tree where each Group #1 was an item on the bill of material, and each item of detail was the parent for that particular Group.
Thats exactly what I want to show but how can I select only the items for that particular assembly?
If you go into record selection and say {V_BOM_MSTR.PARENT} = {?Part} the record selection will only work for the first level of items in the BOM. If you have an item that is 3 levels deep (i.e. Assembly -> Component -> Raw Material) then the record selection will want the component to equal the {?Part}.
Any help would be greatly appreciated.