[Last Call] Learn how to a build a cloud-first strategyRegister Now


Crsytal Reports: Some tables could not be replaced, as no match was found in the new data source

Posted on 2012-08-31
Medium Priority
Last Modified: 2012-09-09

I am trying to change the connection paramenters on reports created with Crystal Reports version 11 from dev to Prod server, the username and password have to be changed as well. I am able to connect to the new server but gets this message:

"Some tables could not be replaced, as no match was found in the new data source"

Database on both servers have similar tables and stored procs etc.

Then the report connection parameters remain unchanged. Please assist

Question by:MandyProgza
LVL 101

Expert Comment

ID: 38354354
Similar is not good enough.  The table must be named the same.  Field names can change and you will get the opprtunity to map fields.

If your report uses table Customer and the new database has table Customers Crystal will not be able to map one to the other.

However if both have a customers table but one has CustomerName and the other Customer for the name field Crystal will provide a box so you can map the current field to the correct field in the new table.

LVL 26

Accepted Solution

Kurt Reinhardt earned 1000 total points
ID: 38354360
Either the objects on the database don't actually exist or you can't see them (permissions issue), which means they don't exist as far as Crystal Reports is concerned.  So, you should probably double-check the permissions are the same between the two environments or change to a user id that has the appropriate level of permissions to prod.
LVL 18

Expert Comment

ID: 38355256
Try this tool: http://www.r-tag.com/Documents/RTagCRDataSource%201.1.zip
It should be able to change the connection for you. However if the problem is related to user rights or tables with different names it will be not able to help you.

Disclaimer: I am linked to the company which is developing the product. However  it might be helpful in your case and it is NOT necessary to buy it.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question