CR v10 Pro.
I've added a field {tblSOPartsUsed.PricebookFeatures} to a report and listed it under GH2B which correlates to {tblSOPartsUsed.KeyID} with the goal of it displaying "pricebook feature" information, which it is doing but it is also displaying several duplicate lines on most parts in the report. The commonality of all pricebook feature information that needs to be displayed is they should start with "Cable" from the {tblPriceBook.ItemID} field.
I noticed the fields that are duplicating are items which contain assemblies and the number of duplicate entries is always the same on the order I'm testing. The assemblies are printing in the details section. GH1 is {tblOrder.OrderNumber}, if that matters.
Example of Desired Output:
Part: Desc: Part Num: Qty:
Widget A Widg A 001A 1
Cable 2 Labor (this and 2 items below are features)
1 Jack
1 CAT5 Cable
Widget C Widg C 023C 6
Example of Current Output:
Part: Desc: Part Num: Qty:
Widget A Widg A 001A 1
Widget B Widg B 012B 10
Widget B Widg B 012B 10
Widget B Widg B 012B 10
Cable 2 Labor (this and 2 items below are features)
1 Jack
1 CAT5 Cable
Widget C Widg C 023C 6
Widget C Widg C 023C 6
Widget C Widg C 023C 6
Any ideas on how I can fix this troublesome problem?