• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1507
  • Last Modified:

SSRS rdl on Winforms Report Viewer using SQL Express

I am attempting to adapt a report created in SQL Reporting Services 2008 (Server Report).
The distributed client is a Windows Application (C#) with a local SQL Express 2005 database that has a matching schema (at least for this report).

I am having problems attempting to convert the rdl to a rdlc which can be used with the Report Viewer Control.

Has anyone attempted to do this or have knowlege that can help?
1 Solution
Rakesh JaiminiCommented:
WGITAuthor Commented:
This is the process I am attempting to follow, however when I try to build the project after the report is added, I get an error that the namespace is invalid and can not be upgraded:
The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded.

Googling for a couple of days has pointed to Reportviewer incompatibility, but the solution is supposed to be the rdlc conversion you pointed out.

Still, the project will not build.
The problem is that you are trying to run a ssrs2008 report on a sql2005 version. They are not compatible in this manner. FYI: also ssrs2208 does not support rendering of a local report. In runtime you have to initiate a server report. I am currently on my mobile and don't have the ms link here with me. I will post the msdn link later on. You can use sql2005 to store your data, but not to host your Ssrs. There were design changes in 2008 that prevent this (one of the being the rdl files are not stored on a physical location as in 2006, 2008 stores them in SQL and has it's own built in "iis" serve and no longer relies on ms iis)
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Chris LuttrellSenior Database ArchitectCommented:
zadeveloper is correct that you can't use a 2008 developed report on a 2005 RS instance.  You can use data from any database, but the underlying report definition changed significantly from 2005 to 2008 and you can not go backwards in compatibility on them.
As promised:

Hardware and Software Requirements for Installing SQL Server 2008

WGITAuthor Commented:
Thanks You.  This saved me wasted time.
No Problem, + good luck
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now