SSRS 2012 : report builder and connection string to shared dataset

3
votes

We are using SQL Server 2012:

  • one team develops datawarehouse
  • one team is in charge of reports using Report Builder

We use shared datasets.

When .rdl files are saved on local machine, we can see that <ReportServerURL> is fully embedded in file, in Shared DataSet section. How can we easily deploy the .rdl on another report server (production environment) without having to edit (by hand/script) all .rdl files?

1
reporting-servicesdatasetdatasourcesql-server-2012

1 Answers

0
votes

As far as I know <ReportServerURL> is just a hint for Report Builder. It is not used by server, so reports can be safely deployed to another report server