Print Page | Close Window

Edit field source in data link

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16
Printed Date: 03 May 2024 at 4:25am


Topic: Edit field source in data link
Posted By: KeithL
Subject: Edit field source in data link
Date Posted: 20 Nov 2006 at 2:03pm
I have a simple report template that I would like to use for dozens of reports on existing databases.  I created and tested the first report successfully and now I want to created the 80 or so copies which use different databases and/or fields.
 
Is there any way to select a field data link on the report and change the field to which it is linked?  Is there a way to do this globally?
 
e.g. say I have 80 sites each with a customers table.  How do I change from database "Ohio", field "customer_name" to database "Oregon" field "customer_name" or, worse database "California" field "cust_name" (note fields sometimes have different names.
 
TIA
Keith


Replies:
Posted By: BrianBischof
Date Posted: 20 Nov 2006 at 3:17pm
I personally don't know of a quick way to do this. If you know how to program you can write an application that changes the database behind the scenes prior to the report loading. Otherwise you have to make 80 copies of the report and do a "Change Data Connection" for each one. CR automatically switches the fields names over and if a field name doesn't match with the new database then it lets you tell it which field to replace it with.

Posted By: KeithL
Date Posted: 20 Nov 2006 at 7:59pm
Change data connection?  I don't think I've found this particular menu item.  Where is it?  Also, is it in 8.5 (which is what I'm actually using)?

Posted By: BrianBischof
Date Posted: 20 Nov 2006 at 11:51pm
Yes it's in 8.5. I have no idea which menu item to use in 8.5, but in XI you would do the following:
From the menu, choose Database | Set Datasource Location. Click on the database (or individual table) you want to replace and in the other window find the database (or table) to replace it with. Then click the Update button.

Hope this helps.


Print Page | Close Window