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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
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 49,496 User Group Leader on at

    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

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

    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

    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

Season of Giving Solutions is Here!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#2
TAHER Mehdi Profile Picture

TAHER Mehdi 3

#3
Nakul Profile Picture

Nakul 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans