Print Page | Close Window

How go give table alias in crystal 9

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=2184
Printed Date: 09 Apr 2025 at 9:11am


Topic: How go give table alias in crystal 9
Posted By: manisha
Subject: How go give table alias in crystal 9
Date 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 ?


Replies:
Posted By: Savan
Date 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


Print Page | Close Window