SQL Statement is Read Only

[dnfrantum]

I have a report that I am trying to modify, however, the original report is pointing to a demo database and that is reflected in the SQL statement. I have updated the ODBC to reflect the live database, but the SQL Statement has not updated and seems to be read only. I am on the client site and really need to get this taken care of today. Any answers or guidance toward an answer would be greatly appreciated.


Thanks in advance,
Donald N Frantum
Sr. Business Consultant
L&D Affiliates, Ltd


Thanks in advance,
Donald

 

[dnfrantum]

I actually fixed it myself. Using Set Data Source Location, I had to update the reference to the table in addition to the reference to the database. It looked correct, but obviously it wasn't. Thanks to anyone who looked at my post.

Thanks in advance,
Donald