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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to output the tota...
Microsoft Dynamics AX (Archived)

How to output the total time my report takes to run.

(0) ShareShare
ReportReport
Posted on by Community Member

I am working to improve the performance of my report . The datasource of my report is a Report Data Provider class. I want to check the exact time my report takes to generate the output. What to do ? 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 48,811 User Group Leader on at
    RE: How to output the total time my report takes to run.

    I think you can combine two times

    1) Time AX took to execute RDP. see example

    2) Time taken by SSRS. see example

    send #1 to SSRS and on SSR Report sum both #1 and #2

  • Community Member Profile Picture
    Community Member on at
    RE: How to output the total time my report takes to run.

    Thank-u for replying . It is exactly what I was looking for Sohaib. But can you please guide me where to put the code. Should I put this in the reportProcess method of my RDP class.?

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 48,811 User Group Leader on at
    RE: How to output the total time my report takes to run.

    yes. although there can be, other factors, involved as well.

    lest suppose I called a report which is usually initiated by a calling a menu item(output). Calling of this menu item may hang due to any reason (slow DB server response, slow network or any other reason) ; To  reach from Call of menu till ProcessReport, system may take any time. In case if you will put the code in Process Report, you cannot get the time since call of menu Item till Start of Process report.

    if you wan to trace down the time, which system has consumed from call of menu item processReport, you have to set values somewhere in global table and inside process report you can manipulate that global table

    a Table may be structured/created as under

    UserId ReportName StartTime/MenuItemCallTime
    abc

    PurchPurchaseOrder.Report

    anytime

    you can fill this table at start of your Output menu item call, and inside process report you can use information from this table, if you wan to track time since actual start

    if you just want to track time, you can go directly in process report.

    in my personal opinion you should go only for processReport ; because query is also executed here inside. Prior to this method is usually contract and/or controller class,

  • Community Member Profile Picture
    Community Member on at
    RE: How to output the total time my report takes to run.

    Thank-you so much for your help.. :)

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans