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?

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.aspxBest regards,Charles WangPlease remember to mark the replies as answers if they help and unmark them if they provide no help

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

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 WangPlease remember to mark the replies as answers if they help and unmark them if they provide no help

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.

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.

Oh, I have the same problem! How to solve it?

I used AsyncRendering="false" attribute of <rsweb:ReportViewer> control and the loop was stopped.

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

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?

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