none
Using SSRS 2008 R2 report in VS 2010? RRS feed

  • Question

  • Hi,

    Is it possible to use already existing SSRS 2008 R2 reports in newly installed Visual Studio 2010 (ultimate) version? i.e., to use 2008 R2 reports with ReportViewer control of VS 2010?

    How to link these two environments? [I tried opening 2008 R2 report in VS 2010->Open Project-> and selected 2008 R2 report project, it asked to do conversion but finally it failed to open. And this situation also caused to fail to open that report project in BI 2008 R2]

    If we cannot link these two environments then how can we make use of new ReportViewer control of VS 2010 with our existing reports?

    Tuesday, February 15, 2011 4:39 PM

All replies

  • You cannot open SSRS 2008 R2 reports in VS2010 at the point. VS2010 report designer supports RDL 2008 schema, while the SSRS 2008 R2 reports uses the RDL 2010 schema.

    However, the ReportViewer control in VS2010 does support SSRS 2008 R2 reports. You can simply point the ReportViewer to a SSRS 2008 R2 report on an SSRS 2008 R2 report server instance.


    Cephas Lin This posting is provided "AS IS" with no warranties.
    Tuesday, February 15, 2011 8:26 PM
    Moderator
  • Hi Cephalin,

    Thanks for confirming it. I just saw that thing yesterday and successfully pointed out ReportViewer control to point to the SSRS 2008 R2 report from the Report Server 2008 R2. Now my question is as below:

    I hav a req. to create a kind of prompt page, hitting "RunReport" on which should open up the [ssrs 2008 r2] report according to the filter on the prompt page. i.e., on the prompt page i have a below items:

    one label(Select One), two radio buttons(State, Nation), two buttons(Cancel, RunReport)

    so if for ex., user selects "State" and hits "RunReport" button it should open up the report accordingly. So, what I have done so far is created to WindowsForms: Form1, Form2 and on first win form I added all of the above controls as mentioned and on the second win form I added one ReportViewer control which I successfully configured as I said above. And then I wrote lil code for re-directing from Form1 to Form2 for the "RunReport" button. But, this is just on-the-fly version. can you tell me how can I actually apply that filter to my report (i.e. based on State or Nation , it should apply that filter to the report while rendering it. Currently it is taking report from R2 server as it is)

    I am relatively new to this mixture of .net and reporting so if you even have any eample which can demonstrate above situation. Thanks in advance.  

    Wednesday, February 16, 2011 3:41 PM
  • I don't see it listed in VS 2010 SP1, but can someone confirm that is still is not supported to edit reports created in SSRS 2008 R2 with VS 2010? It will be really sad if that did not make it to SP1, but I don't want to install to find it does not make a difference.
    Wednesday, March 23, 2011 6:19 PM
  • No, VS2010 SP1 does NOT include any (significant) changes to the ReportViewer control. There is still no support for 4th generation (2010) RDL (or RDLC) in VS 2010 SP1.

    But, if you want to launch a report using server-side rendering (ReportViewer "Server" class), you can do so. As I discuss in Chapter 14 of my 7th Edition, you can invoke the ShowReport method on demand in a Button_Click event.


    __________________________________________________________________
    William Vaughn
    Mentor, Consultant, Trainer, MVP
    http://betav.com
    http://betav.com/blog/billva
    http://www.hitchhikerguides.net

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    Wednesday, March 23, 2011 7:42 PM
    Moderator
  • What a HUGE disappointment! I have to keep Visual Studio 2008 for reports. Right now I have actually VS 2005, 2008, and 2010 all installed. I know this is not the right forum, but I hate they dropped Windows Mobile development from 2010, so if you do that type of development you have to stay with 2008 (although mobile for WP7 is 2010, I don't know what type of market they will continue to have there, seems diminishing).

    Thanks for the information though.

    Friday, March 25, 2011 11:36 AM
  • I totally agree. IMHO the Developer Division has lost sight of real developer needs in favor of breaking new ground for application development methodologies that a small fraction of the developers will ever use. They need to (again IMHO) to refocus on keeping existing technology supported and maintained. Bug fixing and feature issues for existing paradigms need to take 70% of their efforts--the rest can be applied to future technologies.

    __________________________________________________________________
    William Vaughn
    Mentor, Consultant, Trainer, MVP
    http://betav.com
    http://betav.com/blog/billva
    http://www.hitchhikerguides.net

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    Friday, March 25, 2011 5:47 PM
    Moderator