September 21, 2011 at 10:19 am
Hello,
I edit a report on sql2005 reporting services.
I use BIDS 2005 to modify the .rdl and do some changes in the layout. I save the report.
But when I try to import the .rdl back into SSRS 2005 I get the foll error:
The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. (rsProcessingError) (Report Services SOAP Proxy Source)
This is driving me nuts !!!!
BIDS about info are:
Microsoft Visual Studio 2005
Version 8.0.50727.867 (vsvista.050727-8600)
Microsoft .NET Framework
Version 2.0.50727 SP2
Microsoft SQL Server 2005 - 9.00.5057.00 (X64) Mar 25 2011 13:33:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Grateful if anyone could please advise.
Thank you
September 22, 2011 at 3:36 am
Somehow, when I updated the report by using the web url it worked fine !!!
1) SSRS server -> Home -> Folder -> ...
2) properties
This is very strange !!
September 22, 2011 at 10:16 am
When you are uploading RDL the Report tag in the XML file needs to match the version of the server. The error message you received says you using SQL Server 2008 as you can see by the reference to 2008/01. You need to replace the first two lines of your report RDL with the 2005 version shown below (this may have happened by applying your other fix):
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
But if you ever see the issue again, either View Code, or open the .rdl file in notepad and look at the first two lines and compare the version.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply