As of Dynamics GP 10.00 Service Pack 3, SQL Server 2008, including Reporting Services is now supported. One little item to note however, is that in the Reporting Tools Setup, Reporting Services Tab, the Report Server URL needs to reference the ReportService2005.asmx web service file instead of the ReportService.asmx file as the ReportService.asmx file no longer exists.
As such the URL should be:
http://MySSRSServer/ReportServer/ReportService2005.asmx
Posts
Even after making that change, which did then allow it to find it, and being able to pull the reports directly, still can't see them in GP. We're not sure where we're supposed to see them and do we need to fill out the other two screens on the Report Setup?
ReplyDeleteI have to admit that recently the GP SSRS reports have been driving me nuts. I've come across a number of issues recently and for we're about to go through and run a full set of tests against them before we deploy them again. That should end up as being at least one more blog entry.
ReplyDeleteThat being said, you shouldn't need to fill out the other screens. The reports should show up under the Admin All Reports screen. If you don't see them there check to make sure that the user can access them through the browser. It may be that they don't have rights to the reports themselves through Report Manager.