none
What version of SQL RS does VS2008 target? RRS feed

  • Question

  •  

    Using visual studio 2008 I create a report server project

    It puts

    <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">

    In the RDL

    What gives this will not deploy to a SQLRS 2005 server.

     I thought VS2008 did not target SQLRS 2008? Or at least this is what I read. 

    Do I have to uninstall VS2008 and go back to VS2005 or can I somehow selectively target a SQLRS version?

    Very frustrating

     

    Thursday, December 4, 2008 5:47 PM

All replies

  • If you creating an Report that uses the 2008 RDL Schema you can only deploy that report to a SQLRS 2008 Server. The VS2008 ReportViewer control can render reports from SQLRS 2005 and 2008 servers in Remote mode; however it currently only supports 2005 based reports for local mode. A version of the ReportViewer that renders 2008 RDL is currently being worked on and will ship in the Dev10 time frame.


    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Proposed as answer by Matt Meyer - MSFT Thursday, December 4, 2008 6:23 PM
    • Unproposed as answer by sleepy01011 Thursday, December 4, 2008 7:24 PM
    Thursday, December 4, 2008 6:23 PM
  • I need to create a report using the 2005 rdl schema because I only have 2005 sql server rs intance.  It looks like VS2008 automatically just hard codes the schema for sql server rs 2008.

    this is my problem.

    is this correct?
    Thursday, December 4, 2008 6:47 PM
  • In local mode, the VS 2008 viewer will only be able to read the 2005 RDL schema.  The VS 2008 viewer was released one year prior to SQL Server 2008 and therefore can't read the newer schema.  If you use server mode, you can connect to a SQL 2008 server.  I have more details on these scenarios here: http://blogs.msdn.com/brianhartman/archive/2008/12/05/sql-server-2008-and-the-reportviewer-controls.aspx
    Sunday, December 7, 2008 6:58 PM
    Moderator
  •  

    in local mode with VS 2008 viewer

    this is what I get

    <?xml version="1.0" encoding="utf-8"?>
    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
     <Width>6.5in</Width>
     <Body>
      <Height>2in</Height>
     </Body>
     <rd:ReportTemplate>true</rd:ReportTemplate>
      <Page>
      </Page>
    </Report>

    in local mode with the VS 2005 viewer

    this is what I get

    <?xml version="1.0" encoding="utf-8"?>
    <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
     <Width>6.5in</Width>
     <Body>
      <Height>2in</Height>
     </Body>
    </Report>


    so I think based on what I'm seeing.

    VS2008 only works for SQL RS 2008
    VS2005 only works for SQL RS 2005


    what am I missing here?  is what I'm saying not correct?



    Tuesday, December 9, 2008 3:05 PM
  • There are currently three designers that support the creation of RDL reports Business Intelligence Development Studio (BIDS), Visual Studio, and Report Builder. Currently the only designers that will create reports that are based on the 2008 RDL Schema are BIDS 2008 (ships with SQL Server 2008) and Report Builder 2.0. The report designer that is included with Visual Studio 2008 creates rdlc reports that are based on the 2005 RDL schema. What may be a little confusing here is when you install BIDS it integrates with the Visual Studio 2008 Shell, which allows you to create Report Server Projects (for deploying to SQL RS) and Visual Studio projects in the same environment. Based on your orignal post it sounds like you've installed BIDS 2008 and your creating a Report Server Project.  If you want to create 2005 based reports there are two options, you can install BIDS 2005 from a SQL Server install (this allows you to create Report Server Projects that will deploy to SQL RS 2005) or you can create reports using the Visual Studio 2008 report designer. Since you mentioned that you have a SQL Server 2005 RS Instance i'm asssuming you want to deploy the reports to the Report Server, if that is the case your best option is to install BIDS 2005. Hope this helps.

    Wednesday, December 10, 2008 1:03 AM
  • that is exactly what I needed to know.

    thank you.

    Wednesday, December 10, 2008 2:20 AM