Step by Step how to change the table name

[Former Member]

I have trouble each time. I have a table named tableA i wrote the crystal report against this. THen I found out this name is used in another database in our system. So I want to change tableA to tableACR.

I cannot RENAME at database expert because it removed all the program coding.

I have added tableACR and tried to ignore tableA but this too does not work.

Can someone list the steps how to simply change the name of a table in a current Crystal Report without losing all your coding?

[JWiseman · Accepted solution]

hi Paul,

in this case you should be using the Database > Set Datasource Location dialogue. in the bottom "Replace With" dialogue find the correct / new table and click on it. then in the top dialogue click on the old table and press Update.

if there are any differences in column names then you'll be prompted to map those columns.

note that at this point, the table name may be the table name from the old connection which you may not want, but the report will actually be using the new table.

this is sort of confusing. what you can do though now is just go to the Database > Database Expert and then right click on the table and choose Rename. now the display name will match the new table name.

cheers,

jamie