data-informatique
asked on
Modify field name in Crystal Report
I am new to Crystal Report and not very proficient with SQL. I have created a report, but one of the tables has changed name, so, for example, field Cust_AddItemInfo.ItemKey needs to be changed to ShowReport.ItemKey
How can this be done
Thanks
Jeannie
How can this be done
Thanks
Jeannie
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so very much, it works perfectly
Open the report
CLick DATABASE --> VERIFY DATABASE
You will be prompted that the database has changed
After clicking OK you will either get DATABASE HAS BEEN UPDATED or a screen allowing you to map fields int he report to the new tables
mlmcc