Have a main report that is grouped by productID and sub report that looks up the "locationid".
The product could be located in multiple locations for example:
I have the data showing in the sub report and reporting back to main but only showing one of the locations. Is there a formula or something in can do in the sub to show both? for example:
product: 1234 Location: L21 & M28