Tuesday, January 3, 2012

Dynamics GP SSRS Sharepoint Integrated Mode

The issue:
SQL Server = SQL
Sharepoint Server = Sharepoint
Reporting Services Server = RS
GP Server = GP

We need to install Reporting Services in Sharepoint Integrated mode so that the reports are displayed through sharepoint, but each software is installed in a different server.

Solution:
Ensure that you can access Reporting Services Manager from Sharepoint Server
Create a library to store the reports. I created GPReports as my empty library.
Install Dynamics GP Shared components and GP Client on Sharepoint, and deploy reports from there
(you can uninstall after the deploy)
Sharepoint Site = http:\\Sharepoint\
Library = GPReports

Deploy.
You will get the "The deployment has exceeded the maximum request length allowed by the target server" error

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

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

No comments:

Post a Comment