none
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 RRS feed

  • Question

  • I am using VS2008 Team System and working on n-tier LOB Application. One of the requirements for displaying reports (MS SQL Reporting Services 2008) is to allow user to choose different grouping by having various combination of existing columns with new names. Execution of existing stored procedure will produce different DataSet every time.

     

    Approach taken is to:

    • download the default RDL template from Reporting Server to client application,
    • run the stored procedure and get the dataset back to client,
    • analyse number of columns and captions,
    • change the dataset fields dynamically,
    • set the ProcessingMode = ProcessingMode.Local,
    • assign the data source and set the ProcessingMode = ProcessingMode.Local and
    • LoadReportDefinition (newly updated RDL stream) to Microsoft.Reporting.WinForms.ReportViewer 2008 control (v 9.0.30729.1) 

    For testing purposes, the updated RDL template has been stored on C:\ drive and uploaded manually to Reporting Service server and viewed there without any problems.

     

    Running locally, ReportingViewer control displays an 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.”

     

    Is there any solution to this problem?

    • Moved by Kira Qian Monday, February 22, 2010 3:00 AM (From:Windows Forms Data Controls and Databinding)
    Friday, February 19, 2010 4:52 PM

Answers

  • Hi Mijailovic,
    It looks that you are using reportviewer control to display your SSRS 2008 report in local mode.  I recommend that you change it to server processing mode or downgrade your report to SSRS 2005 version. The reason is as following:
    When using local mode with the VS 2005 or VS 2008 viewer controls, you are using the same report processing engine that was shipped with SQL Server 2005.  This engine does not understand the new report definition schema and attempting to load a report created with one of the new SQL Server 2008 authoring tools will result in this 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.
    
    

    ref: http://blogs.msdn.com/brianhartman/archive/2008/12/05/sql-server-2008-and-the-reportviewer-controls.aspx

    Best regards,
    Charles Wang



    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Monday, February 22, 2010 2:20 PM
    Moderator
  • The report viewer 2008 is not targeted for SQL Server 2008. It is released together with Visual Studio 2008 just like Report Viewer 2010 together with Visual Studio 2010. Currently the VS2010 just has RC edition, you need to wait to get the Report Viewer redistributable 2010 until the RTM edition released.

    Best regards,
    Charles Wang


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Tuesday, February 23, 2010 2:59 AM
    Moderator

All replies

  • Hi Mijailovic,
    It looks that you are using reportviewer control to display your SSRS 2008 report in local mode.  I recommend that you change it to server processing mode or downgrade your report to SSRS 2005 version. The reason is as following:
    When using local mode with the VS 2005 or VS 2008 viewer controls, you are using the same report processing engine that was shipped with SQL Server 2005.  This engine does not understand the new report definition schema and attempting to load a report created with one of the new SQL Server 2008 authoring tools will result in this 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.
    
    

    ref: http://blogs.msdn.com/brianhartman/archive/2008/12/05/sql-server-2008-and-the-reportviewer-controls.aspx

    Best regards,
    Charles Wang



    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Monday, February 22, 2010 2:20 PM
    Moderator
  • Hi Charles,

     

    Thanks for replying. I am little bit confused why there is a control called “2008” and it cannot recognise “2008” schema. I’ll try to use your first recommendation – “Using Server processing”. It will be bit of a hassle but let’s see how it ends. Second option is not really option for us at all because it would involve too many people in whole process, it might take too long, and the outcome might not be positive.

     

    Do you know if there is a stand alone Microsoft Report Viewer Redistributable 2010 that I can download and use instead 2008 control?



    Thanks,

    Mitch

    Monday, February 22, 2010 7:48 PM
  • The report viewer 2008 is not targeted for SQL Server 2008. It is released together with Visual Studio 2008 just like Report Viewer 2010 together with Visual Studio 2010. Currently the VS2010 just has RC edition, you need to wait to get the Report Viewer redistributable 2010 until the RTM edition released.

    Best regards,
    Charles Wang


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Tuesday, February 23, 2010 2:59 AM
    Moderator
  • Having created my RDLC reports using Visual Studio 2008, I encountered the same problem when I moved on to Visual Studio 2010. The workaround is very simple.

    1. Comment out the following in the web.config file if you have it.

    <!--<buildProviders>

    <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

    </buildProviders>-->

    2. Open your RDLC reader file (xxxx.aspx) and remove the following :

    <!--<% @ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %> -->

    Now add the following :

    <!--<% @ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>-->

     

    3. Don't forget to add the ScriptManager after the form tag before closing this file. i.e.

    <form id="form1" runat="server">

    <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">

    </asp:ToolkitScriptManager>

    4. Now if you open RDLC file in Visual Studio 2010, you will be asked whether to convert this file. Say "yes".

    You are done.

    You have to do the same things to every one of your RDLC's.

     

     

    Friday, May 21, 2010 8:39 AM
  • sseral, you are amazing!  A simple solution for an awful problem!

    I followed your instructions and got the .rdlc to run within its ReportViewer on the .aspx page.  However, another serious problem developed: although the page ran, the report never fully displayed - a "Loading" message appeared, and it looked like the report is starting over in a loop before ever displaying its content!

    These reports have been working in production for almost 4 years!  So, obviously, it is the "upgrade" or "conversion" to VS2010 that's causing this to happen.

    Any ideas on what would cause this, and how to fix?

    Many thanks in advance.

     

    Wednesday, October 6, 2010 3:53 AM
  • Oh, I have the same problem! How to solve it?
    Friday, November 12, 2010 12:07 PM
  • I used AsyncRendering="false" attribute of <rsweb:ReportViewer> control and the loop was stopped.
    Saturday, November 13, 2010 8:22 AM
  • Hi I also have this problem. I have Visual Studio 2010 SP1 and have just installed Report Viewer Redistributable 2010. I am running the reportviewer in local mode. I get the error:

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

    I am developing a desktop application in WPF, I can't find the file mentioned above.

    Can anybody help with this please?

     


    ChangedDaily
    Sunday, March 20, 2011 3:31 PM
  • I also get following errors

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

    how to solve it?

    Thursday, April 7, 2011 4:27 AM
  • How to solve the problem?

    I am using local mode to edit the report.
    urgent..

    thanks!!!

    Local Mode

    Local mode is a different story.  When using local mode with the VS 2005 or VS 2008 viewer controls, you are using the same report processing engine that was shipped with SQL Server 2005.  This engine does not understand the new report definition schema and attempting to load a report created with one of the new SQL Server 2008 authoring tools will result in this 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

    Thursday, April 7, 2011 4:42 AM
  • If you use the VS 2010 control (Microsoft.ReportViewer.WinForms version 10.0.0.0), you can run reports created against the "2008" schema (that is, 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' that is created by VS 2008 or Report Builder 2.0) in Local mode.  This doesn't seem to be documented anywhere on MSDN or TechNet, but its working fine in my projects. 
    Thursday, July 21, 2011 9:37 PM
  • I'm having the same compiler error message when I create a new project from the Visual Studio 10 templates (Visual C#/Reporting/Reports Application). I'm using SQL Server 2008 R2.

    Does anybody have any suggestions on what I should be looking for on this?

     


    Thanks
    • Edited by JerryF Saturday, October 8, 2011 4:38 PM
    Friday, October 7, 2011 9:13 PM
  • Hi, the only thing that worked for me was:

    I have managed to fix the issue I was having by uninstalling Visual Studio 2010 and SP1 and then re-installing both. Note that prior to this I had tried running Visual Studio installation in maintenance mode to re-install but this did not work.

    So, don't know what was wrong or what caused it but removing and re-installing Visual Studio fixed it.

     


    ChangedDaily
    Saturday, October 8, 2011 9:24 PM
  • @ChangedDaily

    Thanks for the suggestion. I uninstalled VS 2010, rebooted, then reinstall VS 2010 and reapplied SP1 (which I had left in place). This fixed whatever was causing the error.


    Thanks
    Sunday, October 9, 2011 9:30 AM