Dear all,
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.
IP Logged
