Reporting Services 2005

Can I install and run Reporting Services 2005 on a SQL 2000 server currenly running RS 2000



Answer this question

Reporting Services 2005

  • anthony boudouvas

    Not sure I understand   Can I move my existing reports to RS 2005

  • sweetCoder

    Sorry, your original message wasn't clear enough, so I thought you wanted to run SSRS 2000 and 2005 at the same time on the same machine. Evidently, you just want to upgrade.

    Yes, 2000 reports can be published to 2005. They will be automatically updated so they work in 2005. Once updated, you cannnot round-trip them BACK to 2000, however.

     


  • Valerie Prieur

    Hi,
    I am having a problem with migrating some reports.  A number of reports have a hidden parameter which is filled in by a query.  In 2000, this works file.  
    I deployed the RDL "as is - leaving it as a 2000 definition".  Now I am getting a "XXXX parameter is missing a value" error message.  I can unhide 
    the parameter in the Report Mgr and I see its populated (I only use this to pass data to the Page Header Section by referencing the Parameters collection).  Once its visible, each time I click on "View Report", the value becomes a drop down list with <Select Value> shown and the default value from the query is the only item (unselected) in the list.
    
    I read that 2000 RDLs can be deployed onto 2005 without changes, do you have any suggests  
    Thank you,
    
    Bob

  • ajit patra

    If you publish the 2000 RDL to RS 2005, it will be upgraded on the server.  If you export the report definition from the report server, you will get back the original RDL that you published.  That RDL could still be published to RS 2000.

    However, if you load the report in the report designer, it will be updated to the 2005 schema.  That updated definition will only work on 2005.

  • Oquendo

    Yes, you install 2000 as the default instance, and 2005 as a named instance.
  • Reporting Services 2005