Print Page | Close Window

can't get data from new database

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12132
Printed Date: 03 May 2025 at 2:29am


Topic: can't get data from new database
Posted By: android
Subject: can't get data from new database
Date Posted: 23 Jan 2011 at 5:01pm
Hi,

I have two database in one server. My crystal reports are working with the DB1. When I try to connect the same crystal report to the DB2, it's either the old database is showing or none at all. How do I go with it?

Thanks in advance.


Replies:
Posted By: jkwrpc
Date Posted: 25 Jan 2011 at 10:17am

It depends on somewhat on how the report is connectiing to the data. If you use an ODBC or OLEDB connection you will need to make sure it is pointed to the correct db. If you have some other method you will need to make sure it is correct. Often in changing a report I forget to set the report data source location inside of CR so the report is looking at the correct data connection and source.  It could easily be the case the situation here. If you have not done it before, there are several ways to do this so I will let you look at the help file and choose the best method for you.

 
Hope you have already solved the problem, if not I hope this may help you sort through the issues.
 
Regards,
 
John W.
http://www.CustomReportWriters.net - www.CustomReportWriters.net
 


Print Page | Close Window