locked
SSRS Error: Web service request CreateReport to Report Server RRS feed

  • Question

  • I created a report in Visual Studio 2008, on a SQL Server 2008 platform in development. I can load the report to the develppment server via the CRM 4.0 UI. Now when I attempt to move the report to production I get the following error. Production is the same setup with Visual Studio 2008, on a SQL Server 2008 ? Any ideas?

    Web service request CreateReport to Report Server http://CRM01/reportserver/ReportService2005.asmx failed with SoapException. Error: The report definition is not valid.  Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded.

    Tuesday, December 14, 2010 7:05 PM

Answers

  • The xml namespace in the report - 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' implies that the report was developed with either VS 2010, or Business Intelligence Development Studio 2008 R2, whereas I expect your production SQL RS server is using SQL Server 2008 (and not R2). Unfortunately there's no simple way to downgrade an rdl report definition. A technique I've used before is to change the xml definition (for SQL 2008 you'd want 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition') and try again. Report Server may well then not recognise an Xml element in the rdl - if so, remove that element and repeat until it is accepted. Or, upgrade RS in prodution to SQL 2008 R2
    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Wednesday, December 15, 2010 7:44 PM
    Moderator