Dynamics GP Management Reporter SQL Account Security

Security settings for new SQL accounts to have access to Management Reporter.

Must create Dynamics GP user, and then use that user credentials to access Mgt Reporter Designer

SSRS Web Config File Location

Where is the SSRS Web.config file?

SSRS Web config file location

C:\Program Files\Microsoft SQL Server\MSRS10_50.SQL2008R2\Reporting Services\ReportServer

or for SQL2012

C:\Program Files\Microsoft SQL Server\MSRS11.SQL2012\Reporting Services\ReportServer


Open the web.config file
Find
<httpRuntime executionTimeout="9000">


Replace it with
<httpRuntime executionTimeout="9000" maxRequestLength="40960"/>


Restart ssrs

How to Install GP2010R2

1) Run Install
2) Choose New Instance
3) After install is complete, run GP Utilities
4) Allow utilities to upgrade all Databases
5) Run install again to install Business analyzer and other addons

Render SSRS Report from URL

Here is a sample of the URL required to render the Trial Balance Detail sample report for Dynamics GP in Reporting Services

http://servername/ReportServer?/two/financial/trialbalancedetail&rs:Command=Render&rs:Format=PDF&I_tHistoryYear=0&I_iYear=2017&SortBy=ACTNUMBR_1