Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changed Server Name but same field names - Can I Keep report?

Status
Not open for further replies.

GOEERS

Technical User
Jun 24, 2003
2
US
We just recently changed our server, but we have kept the same field names. Can I use my existing crystal report and just change the database server name in the fields? Thank you.
 
Yep - you should be able to - a lot depends on what driver/connection method was used to create the report. Go to Database/Set Location, select a table in your report, and point it to the new location. You'll be promted to apply the same change to all of the other tables - answer yes, but be aware that you may need to do this manually to each table, and your links may have to be re-created. For that reason, I like to keep a copy of the report 'as-it-was' for a reference until I kknow the new one is working. If you're using 8.0 or 8.5 Crystal has a utility (updatex) that will do this for a number of reports at once.

Peter Shirley
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top