I'm hoping I can describe this correctly. I have a couple reports that I am needing the same functionality from and therefore am having the same issue.

The reports are based on a Part No. and I am trying to generate multiple value horizontally on the same line - however all of the values are coming from the same data field so it is replicating the line for each different criteria. Example:

Part No.   Pricelist 1    Pricelist 2    Pricelist 3
Part A      2.00             0.00           0.00
Part A      0.00             2.00           0.00
Part A      0.00             0.00           2.00

So rather than having 3 lines for the same part, I would like one line per part with it's price on each of the pricelists:

Part A      2.00             2.00            2.00

*Side note: I already checked Select Distinct Records and have a left outer join on the main table.

Edited by kris_a - 04 Dec 2018 at 9:09am