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, ... / Reporting Tools Setup ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Reporting Tools Setup in GP 18.2

(1) ShareShare
ReportReport
Posted on by Rennecia Barran

Good Day, 

I am trying to get the ssrs data to fill in to the Reporting Tools Setup window for GP18.2 but the SSRS window doesnt show my sql instance. Instead it shows the instance as SSRS which seems to be some default. 

How do i get the Reporting Tools Setup window to reflect information for my sql instance so the reports can be deployed and by extension for the Dynamics GP install to be completed?

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

    Normally, Dynamics GP won't put in 'default' information for your SQL Reporting Services in the Reporting Tools Setup window, but it may be possible that Reporting Services reports were configured in Dynamics GP at a previous date or version, thus you might have some old data in the SY40800 table, which is the Reporting Tools Setup table in the DYNAMICS/system database.

    That being said, when deploying SQL Reporting Services reports from Dynamics GP, you should be able to put in the new Report Server and new Report Manager URLs, which are required, then deploy the SSRS reports onto your new Reporting Services environment.

    Let us know what you find.

    Thank you,

  • Suggested answer
    Rennecia Barran Profile Picture
    Rennecia Barran on at

    Hi Derrick, I meant the Reporting Services Window shows a SSRS instance of Reporting Services which I didn't configure. It seems to be the way that SSRS 2017 and 2019 is made to work.

    Shortly after this post, I continued trying. The issue was due to me not being able to connect SSRS to use my older Reporting Services database due to encryption key I believe (no error was detected in the configuration manager). Once I created a new database for Reporting Services using the Configuration Manager and used the regular Instance of SSRS given in the Configuration Manager (named SSRS), I was able to deploy the Reports in GP.

    I was pretty worried that I had a named instance of SQL and wasn't seeing my instance name in the SSRS Configuration Manager. Which didn't matter in the end as although my GP was installed to a named SQL Instance, the reports were deployed with the instance given by SSRS which is an instance named SSRS (again not the name of my instance).

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at

    SQL 2017 and 2019 are different, in that you cannot install SQL Reporting Services at the same time you install the SQL Server instance, like in prior versions.

    I know in prior versions, you could add Reporting Services to the SQL install, then choose whether you wanted to configure it then or later. Normally, I would choose to configure it later after I was done installing SQL Server and when setting up SSRS reports, but I'm sure everyone has their own process.

    With SQL 2017 and 2019, my thoughts are it should still work the same way in that when you install it, you're configuring it either during the install, or launching it once it is installed. I can't remember off-hand whether you can have multiple installs of Reporting Services installed for different SQL instances on a server, I'm thinking you can, but not 100%.

    I'm happy to hear you got the reports deployed.

    Thanks,

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 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans