Receiving 'Invalid target namespace' error when uploading a Report to BIDS

Version 1



    If you see the following error appear instead of the report you are importing into SSRS, there is a fix provided in the resolution below. 

    <html><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"><title></title><style>.ErrorStyle { font-family: tahoma; font-size: 11 pt; text-align: left}.DetailsStyle { font-family: tahoma; font-size: 10pt; text-align: left;text-indent: 0; word-spacing: 0; line-height: 100%; float: left; margin-top: 0; margin-bottom: 
    0}.StackStyle { font-family: tahoma; font-size: 10pt; text-align: left; margin-left: 20; text-indent: 0}</style></head><body><DIV class="DetailsStyle" width="100%"><table border="0" width="100%" id="table1" height="100%" cellspacing="0" cellpadding="0"><tr><td height="40" bgcolor="#FF9999" width="8%" style="letter-spacing: 0" align="center"><img border="0" src="C:\Users\wilkech\AppData\Local\Temp\tmp83D2.tmp" width="35" height="35"></td><td height="40" bgcolor="#FF9999" width="91%" style="vertical-align: top; letter-spacing: 0" align="left"><b><font size="2" face="Arial" fontsize="70%">One or more errors encountered while loading the designer.  The errors are listed below.</font><font size="2" face="Arial"></font></b></td></tr><tr><td colspan="2" align="left" valign="top"><DIV id="div1" class="ErrorStyle" width="100%"><span style="font-weight: 600"><br>The report definition has an invalid target namespace '' which cannot be upgraded. </span><span style="font-weight: 400"><p></p><div a href="" id="task0" style="cursor: hand; text-decoration:underline; color=#0000FF">Edit code</a><p></p></div></span></DIV></td></tr></table></div></body></html>

    Note the part: The report definition has an invalid target namespace '' which cannot be upgraded. - This portion needs to be edited within the report. 




    If you see the error,  'Invalid Target Namespace' when deploying a Report in SQLServer 2008 BIDS connection - this means that the report definition is not valid within the Report. This typically occurs if a report was built in a different version of SQL Server and then imported into 2008 R2. 

    The report definition has an invalid target namespace '' which cannot be upgraded. (rsInvalidReportDefinition)

    To fix this error:
                      Edit the report RDL (Code View as it is called in BIDS).
                      Replace the Report header with the following:

       Remove the <ReportSections> and <ReportSection> tags from the report. Note, remove the tags only.  Leave all content inside the tag.  Don’t forget to remove the closing tags for each of these.
      Save the report.  You should now be able to upload it.