Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Multiple Databses, Same Table Names Post Reply Post New Topic
Author Message
Narmi
Newbie
Newbie


Joined: 10 Dec 2007
Online Status: Offline
Posts: 10
Quote Narmi Replybullet Topic: Multiple Databses, Same Table Names
    Posted: 15 Jan 2008 at 7:35am

Hello all,

I'm trying to create a report that draws tables from three different databases, the problem is that each database has the tables named the sameway and when I try to bring in more than one table, it asks if I want to replace the previous table.  Theoretically this shouldn't happen as the tables are located in different places and therefore should be recognized as unique entities.  Any ideas on how I can remedy this?
 
Thanks,
 
Narmi
IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet Posted: 15 Jan 2008 at 11:14pm

Narmi,

If your adding the tables with same name from different database then crystal report  will create an alias for that table. i mean if you already have table name "emp" and if u add one more table with name "emp" then CR will give a database warning "The table "emp" has already been added to this report. Do you really want to add another alias to this table"?. if say yes then table is added with name "emp_1". so you will get your table but the name will differ slightly. 
so check this and get back if u have any queries Thumbs%20Up
 
Thanks
Savan
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.