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!

Change database in Crystal 9 1

Status
Not open for further replies.

kaumil

Programmer
Jul 21, 2003
5
US
When you develop reports in crystal 9, it saves the database and table owner references inside the report. So when you want to run the same report against a database different from the one against which the reports have been developed, it errors out. I want to know if there is any workaround so that the same report can run against different databases. Please help me out, this is a serious issue with crystal 9, as in crystal 8.5 you were able to edit the db references and just leave the table name inside the report by using Database --> Set Location, but in crystal 9 the sql thats gets generated in the report has db references.
 
What database are you using and how are you connecting to it?

Craig Berntson
MCSD, Visual FoxPro MVP, Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"
 
I am using SQL Server database and connecting through ODBC data source.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top