Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

SSRS report execution by user when logging into a company

Posted on by 25

We have a GP user that has SSRS reports that are being executed each time they log into a specific company.  This user does not know what these reports are nor can we see them on their main dashboard when they are logged into GP.  The user does recall doing something with SSRS reports in their dashboard a few years ago but "backed out"

Is there a way that SSRS reports are can be triggered to execute when a user logs into GP and where can we find this in the database so we can turn them off?

Thanks.

  • Suggested answer
    RE: SSRS report execution by user when logging into a company

    Hello Karen,

    I also wanted to mention, if SSRS reports are deployed for the company db, they'll also show in a BA type window on navigation lists as well.

    If they don't want this, they can turn it off via the System Preferences window at the bottom, under the 'Business Analyzer' section.

    If they don't have SSRS reports deployed/used at all in the companies, then I'd verify that in the Reporting Tools Setup window, they have the SSRS reports tab set to 'Not Implemented'.

    Thanks,

  • Suggested answer
    Karen K Profile Picture
    Karen K 25 on at
    RE: SSRS report execution by user when logging into a company

    Thanks for the major hint Lisa.  This user had a Business Analyzer panel on their home page, which they never use.  That was triggering all of the reports we were seeing as executed in the SSRS database.  For clarification, the user was unaware they were executing reports.  We were seeing the reports being executed numerous times in the SSRS database as part of an audit of report executions.

    The user has removed the Business Analyzer panel and we will continue monitoring.  So far the reports haven't been executed again.

  • Suggested answer
    Romryan Profile Picture
    Romryan on at
    RE: SSRS report execution by user when logging into a company

    This is very strange. A screenshot will help to get more understanding.

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,024 on at
    RE: SSRS report execution by user when logging into a company

    A screenshot of what the user is seeing that makes them think SSRS reports are being executed would be very helpful.  (I'm thinking it could be something like the Business Analyzer panel in the Home Page or possibly they put SSRS reports into the Startup folder on the Home Navigation Pane.)

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans