0

Newbie - row replicator maybe

Good morning everyone. I am new to Jet reports, and my question is very likely a basic one so I thank you in advance for your help and support as I get started.

I am trying to generate a table which shows all the child components for the parent parts. Specifically, one of the parts we produce can have anywhere from 2 or 3, to hundreds of component parts which go into it. Essentially I'm trying to build is a report which shows this Bill of Material (BOM). At this point I can generate a report which shows the parent part number and description, as well as the first component part number, but my issue is I can't see the rest of the component parts. The output of my table is Part 1, component line 1; part 2, component line 1; part 3, component line 1; etc. What I need is, part 1, component line 1, 2, 3, 4, etc.; part 2, component 1, 2, 3, 4, etc.

I remember from training the lady going over row replicators, but I don't know if that is what I need here, plus I haven't been able to get row replication to work based on researching this forum and the internet.

My process to this point is:
Table builder
Add table (Production BOM Header) This holds the parent part information
Add fields (No. and Desc)
Add table (Production BOM Line) This holds the component part information
Add fields (No. and Desc)
Save and run

As mentioned, my output only shows the first component line item for each corresponding parent part number, when in fact I need to see the full list of component parts for a given parent part.

Any help you can provide would be greatly appreciate.

Thank you,
Chris

1 comment

Please sign in to leave a comment.