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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Project report is extr...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Project report is extremely slow from workstation but only when others are in GP

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,848 Moderator

Here is a head scratcher for you.

Reports->Project->History->Time sheets

You are on the server and select any time sheet and click Print. The 35+ pages will print to the screen in about 45 seconds.

Now, if you are the only person in GP and run the exact same report on a workstation for the same time sheet you get the exact same performance.

However, if anyone else logs into GP and does not even do anything, it will take over 30 minutes for the same report to appear on the screen.

On the server it does not matter if someone else is in GP.

What could possibly be causing such a discrepancy?

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Shannon Aune Profile Picture
    Shannon Aune on at

    Hi Richard,

    Is this issue only occurring on this Project Timesheet History report, or are you able to reproduce the same performance issue on any report (i.e. any project reports) or does this just occur on this report? Does it occur on any other non project related reports as well? Are you using the canned report or is this report modified? Just trying to help to narrow down further what else could be coming into play.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    It is only this report. They enter a lot entries per timesheet which explains the 45 pages. No modifications have been made to this report. I do not see the connection between having no one else in GP and having someone just sitting on their homepage.

  • Suggested answer
    Shannon Aune Profile Picture
    Shannon Aune on at

    I agree that it seems strange that just being logged in would cause the performance issue that you are seeing. Maybe you can enable a SQL profile trace and see what events either have longer durations of time passing, or have more calls being made, when you compare both scenarios. Hopefully that will give you some things to pursue further.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans