Tuesday, April 26, 2011

How to Deploy SSRS Reports for Dynamics GP 2010 +

Before beginning, make sure you have entered the registration keys for your Dynamics GP. If you do not, the modules will not be detected, and no reports will be deployed.

1) Run the setup from the Dynamics GP installation disk
2) Install SQL Server Reporting Services Wizard
3) Find the wizard in your Program Files, run the wizard
4) Enter server, username, and password
5) Select company, and all reports
6) Enter report server URL http:\\localhost\reportserver
7) Click Finish

Right click on GP and click run as>administrator
Log in as sa
1) Go to Tools>Setup>System>Reporting Tools setup
2) Enter Report Server URL http://localhost/ReportServer/reportservice2005.asmx
(For 2013+ the address is   http://localhost/ReportServer/)
3) Report Manager URL http://localhost/Reports/Pages/Folder.aspx
(For 2013+ the address is   http://localhost/Reports/)

(replace localhost with your report server name)

4) Click OK

And you're done.
SRS Reports should now be deployed to your SRS manager, and they should be visible within GP's report lists.

Also check out
http://support.microsoft.com/kb/954242
It has a list of common issues and solutions


Related errors:
You continue to get the "the sql server reporting services information is not valid" even though you are using the correct address.

  • Right click on GP and click run as>administrator

Go to 
c:\Program Files\Microsoft SQL Server\(SRS Instance)\Reporting Services\ReportServer\web.config 

Find
<httpRuntime executionTimeout="9000" />
Change it to (<httpRuntime executionTimeout="9000" maxRequestLength="20960"/>).

No comments:

Post a Comment