Need to group a list with multiple details

[thomas111]

I'm working on a project that requires (using Crystal Reports) me to convert Parent items to the build items and then list and subtotal the build items. I'm not sure how to create the build items as a list that I can then total components because components get used on multiple items. Below is an example

Parent Item - Widget A (Parent) Quantity of 6
Components - Grate (component 1)
Body (component 2)

Parent Item 2 - Widget B (Parent) Quantity 12
Components - Cover (component 1)
Body (component 2)

I currently have a report that pulls in these items and lists them individually as below
Widget A (parent in detail section)
Grate 6 (component 1 in detail section)
Body 6 (component 2 in detail section)
Widget B (parent in detail section)
Cover 12 (component 1 in detail section)
Body 12 (component 2 in detail section)

I now need a subreport that totals item below.
Grate 6 (details section)
Body 18 (details section)
Cover 12 (details section)

Hopefully this makes sense and any suggestions would be helpful. My data is not setup as I would have but I have a table with the parent items, one with to link the component items.

Thanks,
Thomas

 

[Madawc]

Looks like something you could do with a Crosstab. (If you're don't known crosstabs, look for them under Insert, and get familiar with what they do.)

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[lbass]

You need to identify the actual fields you are working with for parent, component and body. It is unclear whether these are in the same or different fields.

-LB

 

[Charliy]

If the universe of components is small and fixed, it can be done with Running Totals