Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing Field Names 1

Status
Not open for further replies.

rhoneyfi

MIS
Apr 8, 2002
200
US
Hello,
My IS department is changing the SQL database structure. Previously, the field names contained underscores (ex: Employee_Salary). Now they said they are going to change the fields so they do not contain an underscore (ex: EmployeeSalary). I've made a bunch of reports based on the old field names. When IS changes all the field names, will I have to redo my reports all over, or is there an easier way.....Thanks
 
After the sql names are changed, open each report and
select verify database.

It will prompt you to map each field it cannot resolve.
There you can switch the field names.
 
Thanks!
I just wanted to see how much work I was going to get myself into...doesn't sound too bad. Thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top