Adding Custom Report to GP Home page Metics\Business Analyzer

It is easy to add a custom SSRS report to GP home page Metrics\Business Analyzer. Please find the below steps.

1) Create a custom SSRS report which has to be run with default parameter(s).

2) Launch report manager url where the standard GP SSRS reports are deployed.

3) Go to the corresponding company folder >> corresponding module folder and make sure Charts And KPIs folder is present.

4) Upload the custom SSRS rdl file.

5) Click Manage > Data Sources to point the data source. Point the corresponding company database

6) Click OK to save the changes and make sure the report is running in report manager.

7) Launch GP, open Customize your home page screen and click Metrics\Business Analyzer expansion button to open Metrics Detail screen.

8) Choose the custom report and click insert to save the changes

9) Now the report get added to the GP home page as shown below

Post your comments regarding to this blog.

Regards,
Natarajan S

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.

Regards,
Natarajan S