Rank: Administration
Groups: AcademicCoachingSchool, admin, Administration, BookSeller, CatholicSchool, CoachingAdult, CoachingProfessional, CoachingSports, ExtraCurriculumCoaching, IndependentSchool, Moderator, MusicTeacher, PrivateSchool, PublicSchool, SelectiveSchool, tutor
Joined: 23/11/2008(UTC)
Posts: 523
|
I tried using report wizard and created a report page using report viewer 8 for SQL Server 2008. It was working. Now I got the following error after compiling the rdc using VS2013
"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 think many people experienced the same issue and seeking help on internet. We may need to look at several places to fix the problem:
1. Are you still using SQL Server 2008? Maybe only SQL Server 2008 reporting service is available. You may need to upgrade to SQL Server 2012. Note that the Reporting Services Configuration Manager is located at C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008\Configuration Tools.
2. Remove the old report references in bin folder
a) Refresh bin folder, delete the old DLLs:
C:\Program Files (x86)\Microsoft Visual Studio 9.0\ReportViewer\Microsoft.ReportViewer.Common.dll
C:\Program Files (x86)\Microsoft Visual Studio 9.0\ReportViewer\Microsoft.ReportViewer.WebForms.dll
b) Install new DLLs report viewer 11 common and ReportViewer.WebForms 11 using NuGet or copy from VS: C:\Program Files (x86)\Microsoft Visual Studio 12.0\ReportViewer\Microsoft.ReportViewer.WebForms.dll
Also you can download and install Microsoft Report Viewer 2012 Runtime redistributable package. You can find the installed DLLs at C:\Windows\assembly\GAC_MSIL or C:\Windows\assembly, e.g.
C:\Windows\assembly\GAC_MSIL\Microsoft.ReportViewer.Common\11.0.0.0__89845dcd8080cc91
C:\Windows\assembly\GAC_MSIL\Microsoft.ReportViewer.WebForms\11.0.0.0__89845dcd8080cc91
3. Add a report viewer onto a web form, try to compile the web app or view the page in a browser. Check web.comfig, scan for report viewer 8.0.0.0 or other older references, comment them out or delete them from web.config, e.g.
Code: <buildProviders>
<add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</buildProviders>
it should be auto-generated like
Code: <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
More report issues
1. When viewing the report page in a browser, web.config file is auto-updated with a duplicated WebServer config section. This can cause "already defined" errors.
a. duplicated validateIntegratedModeConfiguration tag
b. Config section 'system.webServer/handlers' already defined. Sections must only appear once per config file. See the help topic <location> for exceptions
2. For SQL Server 2008, report wizard always generates rdlc with http://schemas.microsoft...2008/01/reportdefinition although report viewer 11 is used.
This will cause the error: two report viewers 8.0.0.0 and 11.0.0.0 in GAC. Clear the temporary ASP.NET files in C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root or
D:\Users\brw\AppData\Local\Temporary ASP.NET Files\root. This might mean we need to upgrade SQL server.
|
