If you get this error message when trying to open a report either to preview it or go into its layout/design, it means one of the following:
1. The criteria for the report is not valid. Double-click on the report again to access its criteria screen, and be sure there is nothing wrong there. Try it with only minimal criteria that you know is accurate. For more information on setting report criteria, see the kb topics about the Criteria Screen.
2. You could have a problem with one or more of your Custom Field definitions. Go to Misc/Setup > Custom Fields, and be sure there are no duplicated field names, or fields with anything other than letters or numbers used in the field name itself. Once this is confirmed, click OK on the custom field screen, and try your report again.
3. If you have checked the above and you still get the error message for the report, then reload the stock reports and datasets that came with the program by doing the following:
a. Close everyone out of the program, and open the program only on the server machine (for single-user machines, just be sure you only have the one copy of Camelot open on your computer).
b. For CAMELOT 3.x: from the Tools pull-down menu, choose Import > Load Custom Update, and browse to choose the C:\Program Files\Camelot3\CAMDBUPDATE-StockReports.FDB file to import.
For older versions of Camelot (2.x and older), you would go to Tools > Upgrade From > Load Custom Update, and browse and choose the C:\Program Files\Camelot\CEUpdate.mdb file to import.
c. After importing the stock reports, go to Misc/Setup > Custom Fields, and simply click OK so that any custom field definitions you have will be reset.
d. Then also go to Misc/Setup > Company/Misc Info, to the Logo/Message tab, and if you've chosen a company logo graphic for your work orders and invoices, then browse and select that file again in the box for that there, and click OK on the company setup screen so it will reset you reports to show that logo.
This will definitely solve the "The SQL for this report is invalid" error message.
sql invalid, report error
Add to favorites