Finance | Project Operations, Human Resources, ...

SSRS report execution by user when logging into a company

(0) Share

Report

Posted on by Karen K

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.

Categories:

Microsoft Dynamics GP

All responses (4)

Answers (0)

Suggested answer

Derek Albaugh on at

Like (1)

Report

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 25 on at

Like (1)

Report

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 on at

Like (1)

Report

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 3,145 on at

Like (1)

Report

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.)