Tuesday, May 27, 2014

SSRS report error while using in asp.net (The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded)



Error      1              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.        

RDLC File Employee.rdlc   
            
Steps to solving this error

Step 1:- Remove or Delete all Shared Data Sets in the SSRS reports (Share datasets is the 2010 format that will work with visual studio 2012 only)


Step 2:- Converting the share dataset to local datasets

Step 3:- Right Click the Employee.rdl FileàView Codeà

On the top report tag u have to update

Previous

<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">

After

<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2008/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">

Replace 2010 with 2008 in the above code

Step 4:- Ctrl+ Find for “ReportSections” and remove the tags in that code

  <ReportSections>
    <ReportSection>
    </ReportSections>
  </ReportSection>


Step 5:- Run the code and check


For any clarifications or queries please don’t hesitate to call or Email 

Phone :- + 91-9492179390


Email :- lannam@technobrainltd.com (or) lokeshtec@gmail.com 

No comments:

Post a Comment