Moving Reports to another computer Connection String

Hello
I created several Reports using SSRS and SSAS. now i have to move them to another PC, which name is different. is there a way to do this without having to open each report in BIDS and changing the connection string for each Data Source ?
thanks

There are several ways to do this, although it is probably too late for you now to do some of them:

1) use a shared datasource so that you can change only one place

2) use an expression as your connection string, as described here http://msdn2.microsoft.com/en-us/library/ms156450.aspx
... look for the section on "expression-based DataSources" or DataSource Expressions or something like that.

as I said it is too late for those now, you already created the reports, right?

3) write a script that loads each RDL/RDLC as an XML document and fixes the connection string -- or if there are only a handful of reports, just open the XML and do it manually... even manually it is probably faster than loading every report in the designer. But writing such a script to iterate over the contents of a folder and fix the one item you want to fix in each one shouldn't be very hard -- might come in handy later.

4) deploy the reports as-is to the new server and then manually fix their connection strings in the Report Manager interface, again depending on how many this might be pretty quick.

5) deploy the reports as-is to the new server and then use the SQL Studio Management interface to drill down to the Data Sources node for each report and fix it there -- might be faster than the BIDS way since you're not opening the reports

.... ?

>L<