Changing ODBC DSN in Reports

[Ben_Brett_(Guest)]

I have a lot of reports written against one ODBC DSN (i.e. TESTMSSQL) I now need to put the reports into the production environment with a different ODBC DSN (i.e. LIVEMSSQL). ____When a user opens the report (in report writer rather than runtime) they have to remember / know to change the DSN - which is messy.____I know I can open each report in turn change the DSN and save it but this could prove very time consuming - does anyone know of a ^batch^ way of doing this?____I could write a utility but I do not want to reinvent the wheel!____Thanks for any help____Ben__

[kfleming]

There is no batch way of making this change.__So you would need to use runtime where you could pass a data source to the report or alternatively edit each one.______Kathleen__R&R Support