Hi
I have created a number of reports which worked well.
Recently our server has been upgraded and the name of the database I use has changed. This has caused some problems connecting to the new database.
I have created a new connection to the database which works on some reports but not on others.
Is there a way of editing the SQL query to change the name of the database in the query or is there a more sophisticated way of ensuring the database name is changed on a wider scale throught all reports?
thanks
Clive