Avatar of garyjgs
garyjgs
Flag 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.
Crystal Reports

Avatar of undefined
Last Comment
garyjgs

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
garyjgs

ASKER
Yes, we used SET DATA SOURCE LOCATION.  However, not all the tables were updated.
vasto

How many reports do you have ?
garyjgs

ASKER
In excess of 500 reports.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
vasto

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.
garyjgs

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