web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS report intercompa...
Finance | Project Operations, Human Resources, ...
Suggested Answer

SSRS report intercompany related

(1) ShareShare
ReportReport
Posted on by RSX 204
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?
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 9,218 Super User 2026 Season 2 on at
    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
     
     
     
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    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
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 426 Most Valuable Professional

#2
CU10121822-0 Profile Picture

CU10121822-0 358

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 353 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans