FAQ’s

1. Failed to retrieve data from the database
Details: [Database Vendor Code: ]
Cause

The report SQL queries that have been sent to the server cannot be executed, because an error was returned by the database server after it processed the queries. For example, a field/table/procedure required by the report is missing, or the queries contain syntax errors.

Action

Ensure the report is using the correct connection information. For example, the data source name, server name, database name and user name are correct. In a database client test tool, ensure that the fields, tables and procedures used by the report exist and that SQL queries can be executed against them. In the Crystal Reports designer, verify that the SQL query, as shown under the Database menu Show SQL Query option does not contain syntax errors. If the SQL query shown in Crystal Reports is valid, execute the same SQL query through a database client test tool.

2. Database Connector error: Got error 28 from storage engine [Database Vendor Code: 1030]
Cause:

This error apparently means that MySQL server has run out of disk space and is unable to write to the file system.
Action:

Clear space on the partition where MySQL server’s data is stored, and this will fix the error!
3. We can display the range values of the parameter by using a following formula (for a date range parameter) :

Totext(Minimum ({?report_date}),”dd-MMM-yyyy”) +
” to ” +
Totext(Maximum ({?report_date}),”dd-MMM-yyyy”)