My answer to these questions are as follows: Can I change the database field name without causing an issue with the data? I'm not deleting or replacing or changing the ID. It should not. The key as far as I know is the Field ID. People may be looking for the old database name when searching or from a report but it should not prevent them from running a search using the new field name Does a crystal report automatically pick up the field change? A crystal report embedded into the Report form (for use in ITSM applications) should not be impacted but if you run a Crystal Report against the form where the field name changed (natively from Crystal) you will need to use the Verify Database option in the "Database" menu to update the link that Crystal has to the database. Crystal can then pick up that there was a change and adjust the report. Would it affect any macros that people may have created? It should not since when macros are recorded, the fields that people add for search macros include the Field IDs (not field names).
Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Friday, February 16, 2007 11:45 AM To: arslist@ARSLIST.ORG Subject: Changing field database names ** Hi everyone, Yes, this is a simplistic question but I don't have my dev server to test it on right now because it's been upgraded. I generally don't do this but I have been requested to change about 20 fields. It's all right to have the field label and the field database name out of sync on a couple of fields but that many is too many to try and remember. It complicates imports and reporting. The questions are: Can I change the database field name without causing an issue with the data? I'm not deleting or replacing or changing the ID. Does a crystal report automatically pick up the field change? Would it affect any macros that people may have created? I appreciate any help you can provide, Susan Server: ARS 5.1.2 Patch 1428 OS: Windows NT 5.0 2CPU's 4G Memory Database: Oracle 9i2 User: ARS 5.1.2 Patch 1316 User OS: XP, NT, Win 2000 Admin: ARS 5.1.2 Patch 1289 Crystal that created reports: 9 Susan Palmer ShopperTrak 200 W Monroe St 11th Floor Chicago, IL 60606 Office: 312-529-5325 Cell: 302-502-7687 [EMAIL PROTECTED] __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"