How do I point my report to a new SQL query?

[suefhmis]

I've created a Crystal Report (version 8.5) based on a SQL query. The database is a SQL 2000 database, and I'm connecting to it through an ODBC connection. I needed to add some fields to the report that were not on the original query, so I wrote a new query. Question is, how do I point my report to the new query, without creating a brand new report? I've tried Set Location, Verify Database, Log On/Off Server, and I still don't see the new query in my data explorer.
Also, how come every single time I open the report, I get a "Dictionary Not Found" message?

 

[kenhamady]

That message means the QRY files was moved. For some reason they use the same message for DC5 dictionary files and QRY files.

You should be able to use Set Location to change the QRY. Use the META-Data category on the bottom to get it to look for the new QRY. You should have also been able to add new fields to the existing QRY and verified the database of the report to pick up the new fields. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[suefhmis]

Thanks, Ken.
I found out by accident that when I get the "Dictionary Not Found" message, I could click the "Select Dictionary" button and then type in the query filename. That worked just fine.