I use that a lot when I change the report.  I don't use the ODBC driver, but instead 'push' the data via XML.  You would think that just copying the data out to the file that the report is developed against and selecting 'Refresh the data' would work, but it doesn't. I have to go to the Data Expert and refresh each table in my XML dataset, and then hit refresh, if I change the structure, not only do I need to refresh each table but Verify the Database as well.

 

HTH

The problem was that although i had pointed the reports to the new ODBC connection and Database, when i opened up 'show SQL Query' the report was still pointing to the old database. 

Thanks once again