I have a load of reports that use a DSN to connect to Database A.  I want all the reports to point to database B instead (and I don't want to change the source for each report one at a time). 

 

I had a go at changing the DSN, swapping the details for Database A for Database B. Unfortunately, it looks like the DSN is chached in the report some how so which ever database I point the DSN to it still takes the data from the original source.

 

Am I stuck with changing all the reports individually?? Hope not.

 

Please help or it's RSI city here I come.

 

M.