SSRS - duplicated records

Epicor ERP 10
1

I have modified the PO form and the subreport (POForm_PORelPart) in this from. I had to add fields to this subreport after I did this my lines are duplicating. I am sure it is join but I am not sure where to start.

image
image.png825×334 6.78 KB

I just added some fields on this dataset query…

This has caused the totals to duplicate too.

2

Here is my approach to diagnostic a report.

  1. Make sure you print the report with Archive Period to a Day or more. This is to allow to store in the Report database
    image

  2. There will be a unique ID for the report, this ID can be used for debugging in Report builder.

image
image.png783×419 17.3 KB

  1. Use SQL Server Management Studio to filter the report server for the ID, you will then see the list of tables that will be used for the report.

Once you have the data, you can check whether you have done the RDD correctly or not.

You can also use the report builder and use that ID to run the report and test the result.

3

Put a border around the subreport, as a diagnostic.

If more than 1 record appears in the “box” (subreport border) then it is being duped in the subreports dataset.

If two separate “boxes” appear, then it’s the parent reports dataset (or grouping) that is in error.

2 Likes