Interesting method in GP 10.0 to have customized reports developed on SQL Reporting Services launched from GP, follow steps below to complete the installation:
1. First you need to run the Reporting Services setup wizard from GP CD2:
2. After having the wizard installed, we need to define the reports and web services path in “Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Reporting Tools Setup”:
Fields need to be set as documented in Help:
Report manager URL
Enter the Report Manager URL for SQL Server Reporting Services. Report Manager is a report server administrative web page that enables you to manage (create, edit, delete) data sources.
The URL should follow this general syntax:
http://<<server>>/<<ReportsFolder>>/Pages/Folder.aspx
If you do not know this information, contact your system administrator.
Report Server URL
Enter the Report Server URL for SQL Server Reporting Services. This is the location of the reporting server site that hosts the Web Service. You specified this location when you installed SQL Server Reporting Services.
The URL should follow this general syntax:
http://<<server>>/ReportServer/reportservice.asmx
3. Go to Administration tab and find “Custom Report List”:
4. Enjoy having your reports in the list:
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
No comments:
Post a Comment