Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: How go give table alias in crystal 9 Post Reply Post New Topic
Author Message
manisha
Newbie
Newbie


Joined: 31 Jan 2008
Online Status: Offline
Posts: 1
Quote manisha Replybullet Topic: How go give table alias in crystal 9
    Posted: 31 Jan 2008 at 2:29am
Hi.......
 
I have one report in crystal 9 and I want to change one of the table from the datasource. New table which I want to add have the same field like previous table..........I just want replace the old table with new one. but want to give alias to new table so that i don't have to change anything in the report. is there any other way to di that ?
IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet Posted: 31 Jan 2008 at 3:47am

in the mainmenu select database menu and in select set datasource location. select the table in the "current  datasource location" pane and the new table in "replace with" pane and then click the update. if both the fields match exactly the table is updated with new table and all fields are mapped accordingly . if the fields doesn't match then, crystal shows the unmapped fields and asks to map the fields.

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.031 seconds.