Migate to a new table 1

[rewob65]

Hi as our database HistQ3 and HistQ4 were full we migarated to two new tables Called "Lists" and "Products". I have been through the set database location and have updated the location, however this does not update the report it still looks to the old tables. Is there any way to make everything change to the new database tables as this have affected almost all reports I have written over the past 5 years.

Thanks I am on crystal Xi

 

[IanWaterman]

In Database Expert it will show old names as alias

simply double click and rename.

If you look in the Show SQL you will see it really is querying new tables but aliasing with old.

Ian

 

[rewob65]

Ian

You have saved me weeks of work. I changed the name via the alias then update it through the database connection and it works. The company I pay £2,000 for support was not able to help except virually saying rewrite the report. Thank you Ian