none
Deploy Reports Error (VS2008) to 2005 ReportServer Db...

    Question

  • Hi, i'm trying to deploy a report made in Visual Studio 2008 to a ReportServer Data Base 2005, but a get this error...

     

    Error 2 The report definition is not valid.  Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2007/01/reportdefinition' which cannot be upgraded. 

     

    Is it posible to use a SQL 2005 DB with Rdl's reports 2008

     

    thanks

     

     

    Wednesday, April 30, 2008 5:27 PM

Answers

  • These are different things.  Let me try to explain it:

     

    RS 2008:

    - stores its metadata either in a SQL2005 or SQL 2008 database

    - can run RDL 2003/10, RDL 2005/01, RDL 2007/01, and RDL 2008/01.  RDL is the report definition language generated by report designer.

     

    RS 2005:

    - stores its metadata either in a SQL2000 or SQL 2005 database

    - can run RDL 2003/10 and RDL 2005/01

     

    BIDS 2005 (Report Designer 2005):

    - generates RDL 2005/01

    - can directly publish to RS 2005 and RS 2008

     

    BIDS 2008:

    - generates RDL 2007/01 currently, will be RDL 2008/01 by RTM

    - can directly publish to RS 2008, but cannot "downgrade" the RDL.

     

    I hope this makes it more clear.

     

     

    -- Robert

    Thursday, May 01, 2008 2:42 AM
  •  

    BIDS 2008 comes with SQL Server 2008 and is different from the ReportViewer control and its designer in VS 2008.  In your case, you are generating a report using the designer directly from within VS 2008, which still generates 2005-based RDLs the same way as VS 2005 did.  However, RDLC (i.e. local mode RDL files) cannot be published directly to a RS 2005 server because RDLC files do not contain data source information.

     

    From FAQ #8 from http://gotreportviewer.com:

     

    Q: What is the difference between RDL and RDLC formats?
    A: RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2005/2008 version of Report Designer. Those RDL and RDLC formats have the same XML schema (i.e. 2005-based schema).

    However, in RDLC files, some values (such as query text) are allowed to be empty, which means that they are not immediately ready to be published to a Report Server. The missing values can be entered by opening the RDLC file using the SQL Server 2005 version of Report Designer. (You have to rename .rdlc to .rdl first.) RDL files are fully compatible with the ReportViewer control runtime. However, RDL files do not contain some information that the design-time of the ReportViewer control depends on for automatically generating data-binding code. By manually binding data, RDL files can be used in the ReportViewer control. Note that the ReportViewer control does not contain any logic for connecting to databases or executing queries. By separating out such logic, the ReportViewer has been made compatible with all data sources, including non-database data sources. However this means that when an RDL file is used by the ReportViewer control, the SQL related information in the RDL file is simply ignored by the control. It is the host application's responsibility to connect to databases, execute queries and supply data to the ReportViewer control in the form of ADO.NET DataTables.

     

     

    -- Robert

     

     

    Thursday, May 29, 2008 1:53 AM

All replies

  • New reports created with BI Development Studio 2008 cannot be published to a RS 2005 server.  You need a RS 2008 server.

    There are many new features in the 2007/2008 RDL namespace that require a RS 2008 server.

     

    -- Robert

     

     

     

    Wednesday, April 30, 2008 6:12 PM
  • Thanks Robert, but this thread... ¿?

     

    http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2010431&SiteID=17

     

    Or maybe, i can use 2005, but in new data base, not the same is hosted SSRS2005... could you refresh this thread? is it possible?

     

    Thanks
    Wednesday, April 30, 2008 6:22 PM
  • These are different things.  Let me try to explain it:

     

    RS 2008:

    - stores its metadata either in a SQL2005 or SQL 2008 database

    - can run RDL 2003/10, RDL 2005/01, RDL 2007/01, and RDL 2008/01.  RDL is the report definition language generated by report designer.

     

    RS 2005:

    - stores its metadata either in a SQL2000 or SQL 2005 database

    - can run RDL 2003/10 and RDL 2005/01

     

    BIDS 2005 (Report Designer 2005):

    - generates RDL 2005/01

    - can directly publish to RS 2005 and RS 2008

     

    BIDS 2008:

    - generates RDL 2007/01 currently, will be RDL 2008/01 by RTM

    - can directly publish to RS 2008, but cannot "downgrade" the RDL.

     

    I hope this makes it more clear.

     

     

    -- Robert

    Thursday, May 01, 2008 2:42 AM
  •  Robert Bruckner MSFT wrote:

    BIDS 2005 (Report Designer 2005):

    - generates RDL 2005/01

    - can directly publish to RS 2005 and RS 2008

     

    BIDS 2008:

    - generates RDL 2007/01 currently, will be RDL 2008/01 by RTM

    - can directly publish to RS 2008, but cannot "downgrade" the RDL.



    I find this extremely disappointing.

    I currently have a VS2008 solution containing *everything* (Client application, website, workflows, WCF service, WF service, database, tests, installer) for a client project.  I went to add a reporting services project to the solution and it won't let me, because VS2008 only supports building reports for a product that isn't even released yet (and won't be for several months).  Not being able to include the SQL2005 reports project in my VS2008 solution (and thus gain the benefits from TFS 2008) is a massive pain.

    Maybe it's time to go back to Business Objects?
    Friday, May 16, 2008 3:54 PM
  •  

    I am still a bit confused.  After reading all of these posts and google-ing this topic, I still can't figure out if you can create a report in VS2008 and deploy it to SRS2005.  When you create a report in VS2008 it creates a .rdlc file, which, when you try to deply to SRS2005 gives you an error.  So bottom-line, can you create report in VS2008 and deploy to a server running SQL Reporting Services 2005?
    Tuesday, May 27, 2008 10:35 PM
  •  

    BIDS 2008 comes with SQL Server 2008 and is different from the ReportViewer control and its designer in VS 2008.  In your case, you are generating a report using the designer directly from within VS 2008, which still generates 2005-based RDLs the same way as VS 2005 did.  However, RDLC (i.e. local mode RDL files) cannot be published directly to a RS 2005 server because RDLC files do not contain data source information.

     

    From FAQ #8 from http://gotreportviewer.com:

     

    Q: What is the difference between RDL and RDLC formats?
    A: RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2005/2008 version of Report Designer. Those RDL and RDLC formats have the same XML schema (i.e. 2005-based schema).

    However, in RDLC files, some values (such as query text) are allowed to be empty, which means that they are not immediately ready to be published to a Report Server. The missing values can be entered by opening the RDLC file using the SQL Server 2005 version of Report Designer. (You have to rename .rdlc to .rdl first.) RDL files are fully compatible with the ReportViewer control runtime. However, RDL files do not contain some information that the design-time of the ReportViewer control depends on for automatically generating data-binding code. By manually binding data, RDL files can be used in the ReportViewer control. Note that the ReportViewer control does not contain any logic for connecting to databases or executing queries. By separating out such logic, the ReportViewer has been made compatible with all data sources, including non-database data sources. However this means that when an RDL file is used by the ReportViewer control, the SQL related information in the RDL file is simply ignored by the control. It is the host application's responsibility to connect to databases, execute queries and supply data to the ReportViewer control in the form of ADO.NET DataTables.

     

     

    -- Robert

     

     

    Thursday, May 29, 2008 1:53 AM
  •  

    So, in other words, with VS2008, you cannot create and publish SQL reports to a SQL2005 server directly.  You must open with VS2005 first (after renaming)?  Is there feature in VS2008 that allows you to create a 2005 report without VS2005?
    Thursday, May 29, 2008 2:54 AM
  • Well, i started this thread and i resolved my doubt from the post of Robert Bruckner MSFT... i will try to explain what i understood...

     

    We can use SQL2005 (DB) like a repository for SSRS2008, the database could be the same form SSRS2005 and 2008, and the difference here or what we can't do is to use the same instance of report manager (http://yourserver/Reports)... if you are going to deploy a report 2008 (converted from 2005 or not) it has to be in the instance of 2008, not in the same of rs2005, but it could be the same DB2005.

     

    Now I'm working with the 2 instances of RS in the same server and y i convert all the reports from 2005 to 2008, just opening in BIDS2008.

     

    Now I have

     

    http;//MyServer/Reports                             (original instance RS2005)

    http://MyServer/Reports2008

     

    With the same reports...

     

    I hope this help...

    Thursday, May 29, 2008 11:15 PM
  • Dear xavier,

    2008 RDL can be converted to 2005 version so that it can be deployed on a 2005 report server.

    i.e., backward compatibility or downgrading is possible. I have a tool that converts it accurately.

    Thanks & Regards,

    Amar Sale (amarsale(at)gmail(dot).com)

    Sunday, September 12, 2010 2:44 PM
  • Dear xavier,

    2008 RDL can be converted to 2005 version so that it can be deployed on a 2005 report server.

    i.e., backward compatibility or downgrading is possible. I have a tool that converts it accurately.

    Thanks & Regards,

    Amar Sale (amarsale(at)gmail(dot).com)


    Dear Amar,

    I have the same issue, I have BIDS 2008 RDL files, i cant able to run this RDL in BIDS 2005, can you please help me to downgrading RDL 2008 to 2005 RDL.

    Please share me downgrading Tool

    Thanks & Regards
    Rajesh N
    rajeshdecebe@gmail.com

    Tuesday, February 07, 2012 11:35 AM
  • Hi Amar

    Sorry for the English, not speak it very well.

    I have the same problem with the RDL 2008 to 2005, please could contact me to see what is your solution to the problem?. My email is: aquesadamo@hotmail.com

    Thanks,

    Friday, November 02, 2012 3:22 PM