SAP Knowledge Base Article - Public

1219332 - Crystal Reports 8.5 report with modified SQL query does not run in later version

Symptom

A report is created in Crystal Reports 8.5. The SQL query generated by Crystal Reports 8.5 was then modified by the creator of the report. When attempting to open the report in a later version of Crystal Reports either:

An error message appears. The actual message will depend on the connection and database type. A RESET button appears in the SQL Query box.

-OR-

Crystal Reports stops responding.

Resolution

Do one of the following:

Click the 'Reset' button in the 'Show SQL Query' dialog box. You cannot reset this in code through an SDK.

-OR-

Use a command object as the data source. Command objects allow for customization of SQL queries.

See Also

For more information about migrating to Crystal Reports XI or using command objects, please refer to the technical document Upgrading to Crystal Reports XI. This document provides a wide range of information about upgrading to Crystal Reports XI.

Keywords

SHOW SQL QUERY MIGRATE REPORT UPGRADE Crystal Reports Upgrading to Crystal Reports XI Modify SQL query , c2018526 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2