views:

27

answers:

2

We have a large real-estate of existing SSRS 2008 reports that we are still maintain in production.
However we are evaluating SSRS 2008r2 and would like to start developing reports that take advantage of the new features such as shared datasets etc.

The problem is that AFAIK installing the tools for 2008R2 upgrades the Visual Studio 2008 tools from 2008 to 2008R2. This means that when you open a 2008 report and make any changes that it thinks need a new feature it upgrades the schema to R2 making it incompatible with our production servers.

Has anyone else encountered this? Any tips? I don't want to RDP to a VM or anything nasty like that really.

A: 

Some things get upgraded, others remain specific to the instance. For example, Business Intelligence Design Studio gets upgraded, but Reporting Services remains independent. See this link for a complete discussion: http://msdn.microsoft.com/en-us/library/ee210714.aspx

Joe Stefanelli
That's my point, BIDS gets upgraded to R2 and thus it's no longer possible to author 2008 reports any more. Note that I asked about my personal development machine, not the services.
Joel Mansford
You've got to keep the instances separate somehow: VM, another box, etc. I don't think there's any way to get them to play together on a single machine.
Joe Stefanelli
A: 

I've just realised it's possible to install Report Builder 2.0 alongside Report Builder 3.0 and Visual Studio 2008 with SQL 2008r2 tools in it.

Thus I can at least edit the old .RDLs using Report Builder 2.0. I hope someone has a better solution.

Joel Mansford
I'll accept my own answer - I'm still hopeful for someone to come up with something better though!
Joel Mansford