We are an ISV and our application has a lot of reports.  Our reports use a SQL Server database as the data source and each SQL Server at our customer sites has a different name.
We would like to edit the RPT and change the data source to the appropriate SQL Server before we call ReportDocument.Load.
In our testing we have determined that ReportDocument.Load tries to connect to the SQL Server that is saved in the RPT.  If it can't fine the SQL Server saved in the RPT the load take about 60 seconde while it is waiting for the SQL Server Connection to time out.
Is it possible to edit the rpt file and change the data source before loading the report?
Thanks