Skip to Content
0
Former Member
Nov 08, 2012 at 01:50 AM

Migrating Crystal 7 to Crystal 11 and creating an editable select while retaining report layout

13 Views

I am a new user to Crystal Reports 2011 version 14 having been using Crystal 7 to report against a Sybase ASE 15 database.

When attempting to import the existing Crystal 7 reports into Crystal Reports 2011 version 14 using the Sybase wire protocol ODBC 6.0 driver the syntax of the select statement correctly builds the join statements, but incorrectly leaves an empty WHERE clause directly followed by an AND which I have not been successful in fixing.

I have followed some of the posts on the SCN and have attempted to copy the select statement into a command statement for editing the incorrect syntax but get hung up because fields already exist in the converted report. Is there a document posted anywhere which addresses the best way to migrate existing reports in a fashion where an editable SQL statement is created while retaining the report layout and table linking?

THanks very much for any help you can provide for this migration.