Crystal Reports

garyjgs
garyjgs used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Have you tried using the SET DATA SOURCE LOCATION option to setup the new connection?

mlmcc

Author

Commented:
Yes, we used SET DATA SOURCE LOCATION.  However, not all the tables were updated.
Top Expert 2011

Commented:
How many reports do you have ?
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

Author

Commented:
In excess of 500 reports.
Top Expert 2011

Commented:
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.

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial