Finance | Project Operations, Human Resources, ...

SSRS report intercompany related

(1) Share

Report

Posted on by RSX

202

Hi,
I have an SSRS report which has a table, which displays the lines.
For one particular entity when printed, it previews correct no of lines.

But when the entity is changed and printed, the lines are getting duplicated for each line and it is previewing, checked through SQL also, there is no duplicated records.
How can we analyse the root of the issue here?

All responses (2)

Answers (0)

Hana Xue Microsoft Employee on at

Like (0)

Report

SSRS report intercompany related

Hi,
The problem of duplicate SSRS report rows may be related to report definition, data source, data processing or other factors. You can check the following points:
Check the filter in the dataset settings in the report. Make sure you don't have unnecessary filters or that filters don't cause data duplication.
If you use groupings and totals in your report, make sure they are set up correctly. Check the design of the report in Report Designer to make sure that tables and other elements are not copied or nested incorrectly.
Check the logs of the SSRS server to see if there are any errors or warnings during report execution.
Best Regards,
Hana
Suggested answer

Waed Ayyad 7,608 Super User 2025 Season 1 on at

Like (0)

Report

SSRS report intercompany related

Hi @RSX,

Is your report is custom report? Can you share the code with us? Also, what do you mean by Entity? Legal entity?

Do you try to debug the code (DP class), you can follow these steps to debug your DP class:

1. In classDeclaration extend SrsReportDataProviderPreProcess instead of SrsReportDataProviderBase

2. Temp table properties should be

(a) Table type : Regular instead of tempDB

(b) Created by : Yes

(c) Created Transaction Id : Yes

3. In process report of the class add this line in Temporarytablename.setConnection(this.parmUserConnection());

then you can debug

Regards,

Waed Ayyad,

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future