SSRS rdl on Winforms Report Viewer using SQL Express

Posted on 2010-01-08
Last Modified: 2012-05-08
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?
Question by:WGIT
    LVL 10

    Expert Comment

    by:Rakesh Jaimini

    Author Comment

    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 '' 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.
    LVL 13

    Accepted Solution

    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)
    LVL 26

    Expert Comment

    by:Chris Luttrell
    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.
    LVL 13

    Expert Comment

    As promised:

    Hardware and Software Requirements for Installing SQL Server 2008

    Author Closing Comment

    Thanks You.  This saved me wasted time.
    LVL 13

    Expert Comment

    No Problem, + good luck

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    Title # Comments Views Activity
    Problem with C# 1 44 mvc C# 2 27
    ASP.NET MVC Edit ViewModel Data 6 24
    Voice recognition ASP or ASP.NET or JavaScript 2 24
    A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. (htt…
    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now