Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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,730

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
  • Suggested answer
    Shannon Aune Profile Picture
    Shannon Aune on at
    RE: Project report is extremely slow from workstation but only when others are in GP

    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Project report is extremely slow from workstation but only when others are in GP

    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
    RE: Project report is extremely slow from workstation but only when others are in GP

    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.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans