web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 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?
I have the same question (0)
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    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 Profile Picture
    Waed Ayyad 8,825 Super User 2025 Season 2 on at
    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
     
     
     

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans