How to set database instance name to all reports at publish?

[ssudha]

Hi,

I have around 200 reports. I have to publish them in different systems (say: devlopment system, testing system, staging etc). At all the places database instance is different. How can change database instance(in report) while publish them to all the reports(i think we can change database user name and password but not database service).

Thanks in advance.

Thanks and Regards,

 

[AndrewFrag]

You will have to tell the report the database location, if you are using VB to call the reports I can give you more info