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

Notifications

Announcements

No record found.

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,486

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,438 User Group Leader on at

    is that a newly/recently created report?

  • Mohammad Raziq Ali Profile Picture
    2,486 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,438 User Group Leader on at

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

  • Mohammad Raziq Ali Profile Picture
    2,486 on at

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

  • Verified answer
    Sohaib Cheema Profile Picture
    49,438 User Group Leader 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,486 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,438 User Group Leader 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,486 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,438 User Group Leader 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,486 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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans