CODEWITHSUNDEEP
sql-serversql-server-2008deploymentreporting-servicessql-server-2008-r2
JsonStatham
JsonStatham

Reputation: 10364

Deploy SSRS R2 reports to non R2 server

I have developed reports using SSRS 2008 R2 but now need to deploy to a server that is pre-R2 (SSRS 2008 SP2). Is this possible or will the server have to be upgraded?

I need to keep all current elements which include guages and bubble charts to name a few

Upvotes: 2

Views: 1543

Answers (1)

Luke Merrett
Luke Merrett

Reputation: 5824

You can set the target server version of the report in Business Intelligence Development Studio through the Report Project like below

  1. Open up a report project containing all the reports in BIDS
  2. Click "Project" on the top menu; then "Project Name Properties"
  3. Under Configuration Properties -> General -> Deployment you can see at TargetServerVersion property.
  4. Change this to SQL Server 2008
  5. Click "OK"

This will allow you to deploy the reports through BIDS with the correct target version. You may have to remove elements from the reports if they are not supported in 2008 (Maps and sparklines for example).

TargetServerVersion

Upvotes: 5

Related Questions