Im working on a report version of Inventory Usage which is a system RDD instead of a BAQ. The objective is to list out part usage Jan to Dec with the totals summed. This should provide 1 row per part number but i get random results. Some rows are duplicated with the exact same data and not all duplicated rows per part have the same count.
In the Microsoft Report Builder, im finding it difficult to set up grouping, maybe because im more familiar with a more modern report system where grouping is more dynamic. Either way, im struggling to set up the report i need and get the single rows. I looked at the system RDD and i cannot add a Distinct clause to it either. On the report, i updated the table SQL with SELECT DISTINCT but that didnt make any change either…
In a report, how can i display non duplicated rows to only show the values i need?
Can you post a screenshot of your RDL? More than likely, you are not putting the fields in the correct group or your groupings are set up incorrectly. It is hard to explain without seeing exactly how your report is structured.
yes i have a modified version of the RDD. I needed to add the PartClass & PartCost to the RDD.
I added 2 joins to a new version of the RDD-
existing join - Part2PartTran
Parent = Part
Key = PartNum
Child = PartTran
Relationship Type = Definition Only
ON Company = Company AND PartNum = PartNum
New join - Part2PartCost
Parent = Part
Key = PK_Part (PartNum was not available but what i wanted)
Child = PartCost
Relationship Type = Output
ON Company = Company AND PartNum = PartNum
New join - Part2PartClass
Parent = Part
Key = PK_Part (PartNum was not available but what i wanted)
Child = PartClass
Relationship Type = Output
ON Company = Company AND ClassID = ClassID
PartCost & PartClass were added to the RDD as Datasources
Mr. Nacho: Please verify that your PartCost only has one entry. If you run the epicor cost updates you should make the join the fields, Company, PartNum, CostID to the PartCost table.