Reporting Services 2000 - 2005 compatibility

[mbryantuk]

hi

I usually write reports for SQL Server Reporting Services 2005 but i have a requirement for 2000 if i write a report in my current instance of SQL Server Business Intelligence Development Studio will the RDL work if it gets deployed in a 2000 environment

cheers

 

[xlbo]

For the most part it should but RS 2005 has elements that RS 2000 does not. Model reports will not work and multi-select parameters will not work - not sure about anything else....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[mbryantuk]

Thats good news,

The report i have to create is reasonably basic it is a matrix with time across the top and category fields down the left no drill downs and only date parameters, can you export to xls and use the page breaks to more data between tabs as per 2005?

 

[xlbo]

You will be fine except for the pagebreaks / tabs issue. You can't control the export to excel like that in 2000. In fact you can't control the export to excel much at all...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[mbryantuk]

Hi have had the rdl file i created in VS2005 deployed on a 2000 reporting server and got the error

The report definition is not valid. Please verify that the report definition uses the current report definition namespace (rsNotACurrentReportDefinition)

Thanks

Matt

 

[xlbo]

Hmmm - seems to be a VS issue rather than an SSRS issue but nonetheless looks like I was wrong. You need to use an earl;ier version of the development suite to write SSRS 2000 reports

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question