Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 110
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?
  • 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 6,556 Super User 2024 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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans