Geek Answers Handbook

Using MS SQL Server 2005 Reporting Services with Visual Studio 2010

When writing this question, I had a simple idea that fixed the problem. Maybe other people have the same problem, or would you like to comment on it, so I submit it anyway.

TL; DR / simplified question: How to use MS SQL Server 2005 Reporting Services in Visual Studio 2010?

Solution: Simply copy the Visual Studio 2008 Reporting DLLs into your project and include them as links. I assume that you should own a license for vss2008 at the same time, but technically this solves the problem.

The original question:

How can I use MS SQL Server 2005 Reporting Services in Visual Studio 2010? The reason I ask is this: we migrated VSS 2010 as our development environment, but still use MS SQL Server 2005.

Now I want to change some of the code in a project that uses Reporting Services on the specified SQL Server.

After converting the solution to VSS2010, I get BuildErrors because it cannot find the "ReportViewer" and "Reporting" namespaces. This is because links to

  • Microsoft.ReportViewer.Common (9.0.0.0)
  • Micrsofot.ReportViewer.WinForms (9.0.0.0)

No longer solvable. Therefore, I must replace them with links to the same assemblies in version 10.0.0.0.

After that, the solution completes successfully, but when I open ReportViewer, I get a SoapVersionMismatchException, telling me that for remote processing I have to use Microsoft SQL Server 2008 Reporting Services or higher.

+4
source share
1 answer

You need to add old links to your project. They can be found on the 2005 report server.

They can be found on your report server in the GAC.

0
source

More articles:


All Articles