PDA

View Full Version : Error - Cannot geerate report


danhen310
August 31st, 2017, 04:15 PM
CommitCRM v16.0.0.5

DatRDp: Could not open DataSet
DatRbl: Error 7200: State = 42000; NativeError = 2115; [iAnywhere Solutions][Advantage SQL Engine]Expected lexical element not found: FROM You are missing the keyword FROM after the column definitions in your SELECT statement. -- Location of the error in the SQL statement is: 18

I have logged-out and in again; restarted the PC too, no change.
Thanks in advance to any help you can provide.

Support Team
September 1st, 2017, 05:59 AM
Thank you for posting this. Are you trying to general a custom report that you built or a predefined system report (and which?)?
In any case, please zip the content of folder \RangerMSP\Logs and email it back to us at Support@ for review.

danhen310
September 8th, 2017, 08:46 AM
Custom report. This error only occurs when I add sort criteria.

Support Team
September 8th, 2017, 11:05 AM
Thanks. It is hard to tell what's wrong and it may be related to your custom report. Anyway, please email us the logs as explained.