Friday, August 15, 2014

Dynamics GP SSRS Deployment

If you want to deploy Dynamics GP standard report in Report Server, then please make sure the Report Server is properly configured through Reporting Services Configuration Manager

1) Login to Dynamics GP, Go to Tools > Setup > System > Reproting Tools Setup

2) Paste the Report server and Report Manager URL, choose the desired company to deploy.

3) You can face the below error, Please close GP and run GP as administrator.

" The SQL Server Reporting Services setup information is not valid "

4) Now you can able to deploy the report. During deployment, you can face the below time out error.

5) Go to Report Sever installed folder, Open the Web file and find executionTimeout="9000". Add the maxRequestLength="20690" to that node.

6) Before saving that file, take the backup of the original file.

7) Now the error dint appear while redeploying the report.

8) GP standard reports are deployed in Report Manager as shown below.

9) You can add the deployed reports to your GP Home page, Click Customize this page from Home Tab

10) Customize this page screen appears, Click Business Analyser check box and click Arrow to open Business Analyzer Details screen as shown below.

11) Choose the corresponding reports and click insert

12) Now you can view the inserted report in Dynamics GP Home page.

Note: in Customize this page screen, Please don't check Show All option. if you check then your GP application get hang based on the machine performance.

Post your comments regarding to this blog.

Natarajan S

1 comment:

  1. In previous versions, Customize your page's Business Analyzer was appeared as Metrics