I saw Hannah had a similar question a while back but no replies. Here In my case I added the PartPlant table to the Inventory WIP RDD as relationship type Output and linked on fields Company = Company and TmpPartNum = PartNum. Bringing in the person ID and cost method. This works fine for all but one part number. This particular part causes duplicate rows on the report if run with no filter. If I filter for a Tran-Type or Job it does not duplicate. I’ve queried the PartPlant table and there is only one record.
We are cloud so I don’t have access to the ssrs data view to see the temp data.
Looks like it is a case issue. What is the part number in the part table, m or M? Whichever one is wrong, I would try and find out where it is entered and see if you can fix it.
The job material has the lower case but the dupes don’t seem to care as the are duplicating on either. They are also stored in the part tran and not updatable.
We’re cloud too. So what I did is make a version of the report with a table and just have every single field included as a column. Run it to Excel output type. I was able to find the issue. Maybe not work in all cases but worked for me.
My next step was to dump everything and see what shakes out. Something is hiding under the covers. The odd part is filtering seems to fix the issue. ADJ-QTY in this case.
One trick i learned a while back (thank you @LauraPearce ) is to change the report output to XML. Run the report and then use the “Server File Download” to download the XML and then you will be able to see all of the fields and data in the TmpTable.