Skip to Content
0
Former Member
Feb 26, 2009 at 11:43 AM

Editing the SQL query

28 Views

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