How to change ReportServerUrl in Report Builder 3.0?

Question

We have 2 reporting server. One for test and one for production. Our business analyst will build the reports (rdl files) using Report Builder 3.0. After they complete the development and test on test reporting server (e.g. http://test/reportserver), we will modify the "ReportServerUrl" and Datasource, and then upload to production reporting server (e.g. http://prod/reportserver).

The problem is I cannot find in the Report Builder 3.0 UI how to configure this change. The only way I find is open the RDL file using Notepad, locate and then change the URL.

Since our analyst are not programmers I want to avoid use notepad. May I know where is the button to change ReportServerUrl?

Answer 1

Each time you add a Shared DataSource to a report or edit an existing DataSource (and therefore connect to a Report Server), the current report server is updated. This is shown in the bottom left of your Report Builder window ("Current report server...") and also gets written to the <rd:ReportServerUrl> tag in the .rdl file itself. This is just an indicator of the last Report Server which was connected to by the report.

Therefore, if you wish to change the <rd:ReportServerUrl>, you just need to amend the DataSource(s) in the report to be ones which reside on the Report Server whose URL you wish to have appear.