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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Data is not rendering for first time but rendering fine from second time onwards in SSRS report

(0) ShareShare
ReportReport
Posted on by 2,488

This is causing for one field only. It looks weird as I haven't seen this issue before.

Please let me know how to figure out this issue.

Thanks,

Raziq.Ali

*This post is locked for comments

I have the same question (0)
  • Sohaib Cheema Profile Picture
    49,668 Super User 2026 Season 1 on at

    is that a newly/recently created report?

  • Mohammad Raziq Ali Profile Picture
    2,488 on at

    I have added new field in SalesInvoiceTmp Standard Temp table and rendering on Sales Invoice report through event handler. when I debugged, it is not even going into debugger for first time but it is going fine from second time in debugger as well.

  • Sohaib Cheema Profile Picture
    49,668 Super User 2026 Season 1 on at

    is that a pre/post event handler? and where you have  written the code?

  • Mohammad Raziq Ali Profile Picture
    2,488 on at

    This is pre event handler added to insertIntoSalesInvoiceTmp method of SalesInvoiceDP class.

  • Verified answer
    Sohaib Cheema Profile Picture
    49,668 Super User 2026 Season 1 on at

    SalesInvoiceDP is an extended class of SalesInvoiceDPBase

    basically method insertIntoSalesInvoiceTmp  is called from createData method of insertIntoSalesInvoiceTmp .

    your event says that code should be called before insertIntoSalesInvoiceTmp .

    can you kindly debug SalesInvoiceDPBase to know how and when insertIntoSalesInvoiceTmp   is being called.

  • Mohammad Raziq Ali Profile Picture
    2,488 on at

    I kept my debugger to find out cause but it is not stepping in createdata method of SalesInvoiceDpBase class for first time. So, very hard to find root cause I guess.

  • Sohaib Cheema Profile Picture
    49,668 Super User 2026 Season 1 on at

    probably because reports run through BI services which is an AIF service and runs under CIL.

    To debug it you need to follow certain process which you can find on TechNet.

    https://technet.microsoft.com/en-gb/library/gg724081.aspx

  • Mohammad Raziq Ali Profile Picture
    2,488 on at

    I meant code is also stepping into debugger mode from second time onwards but not from first time.

  • Sohaib Cheema Profile Picture
    49,668 Super User 2026 Season 1 on at

    interesting.

    can you kindly provide me steps to re-produce issue. doing so, can help me to debug on my DEV box

  • Mohammad Raziq Ali Profile Picture
    2,488 on at

    Below are the steps which I followed for SO-0007106 to reproduced it in DEV.

     

    6735.4.png

     When I click on Invoice for this SO, it opens Invoice journal form

     1440.2.png

     When I click on preview/print to generate report.

    0882.3.png

     It has generated report with blank packing list number for first time which I attached for reference.

    6735.4.png 

    When I run again for second time, it rendered perfectly which I attached for your reference.

    5287.5.png 

    Report is rendering perfectly from second time onwards.

    Thanks,

    Raziq.Ali

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 June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans