Table Name Change - Update existing Reports?

rbuser

Report Builder Pro 7.03
Delphi 5.1

In our application we have a custom Report Explorer where the user can
design their own reports using the Data panel of the designer. The users
have designed some reports but now we need to have a table name changed in
the database (due to upgrading the DB and the old table name is now a
reserved word in the upgraded DB). I have modified the table name in the
RB_Tables table so when designing a new report the table name is correct and
works fine. However for the reports that have already been created is there
a way to modify the Data section to use the new table name without having to
remove the old table from the selected tables list (thus removing any fields
for that table and joined tables)? I have tried to open the rtm in WordPad
and change anywhere I found OLD_TABLE to NEW_TABLE. After doing that, if I
try go to the designer for the report I get an error and the report will not
open.

Any thoughts or ideas?

Thanks,
Jeff

nicocizik

Hi Jeff,

Changing the RTM text is probably your best option, however it seems that
simply changing the table name is not enough. I would recommend choosing
one existing report and recreating it from scratch with the new table name.
Then compare this RTM text to the RTM text of the old report template to see
what changes need to be made.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com