Link to home
Start Free TrialLog in
Avatar of garyjgs
garyjgsFlag for United States of America

asked on

Crystal Reports

I have a Crystal Report that is pointing to a database version 9 using the Oracle Native connection.  A new database version 10 has been setup.  The schema is different between the old and the new database.  When trying to run the Crystal Report against the new version 10, errors are received not finding tables.  How can the schema be changed in the Crystal Report without rewriting the Crystal Report that was originally written against the version 9 database.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of garyjgs

ASKER

Yes, we used SET DATA SOURCE LOCATION.  However, not all the tables were updated.
How many reports do you have ?
Avatar of garyjgs

ASKER

In excess of 500 reports.
Wow , this is a good number. Did you try rptInspector ? It can change the connection but I don't know if it can replace the schema.
Avatar of garyjgs

ASKER

Caught up with DBA.  Custom table and views have not been yet migrated to the new database.