Tuesday, May 17, 2011

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

Monday, May 16, 2011

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
<httpRuntime executionTimeout="9000">

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

Restart ssrs

Wednesday, May 11, 2011

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

Monday, May 2, 2011

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