Change template in its text representation
Hi,
I have a report and I want to change the tablename it refers to (without
losing its links to other tables). I know you can convert a template to a
textual representation, change it and then convert back but I cant remember
how to do it. Can anyone enlighten me? RB7.03
Just in case more clarity is needed, the report might have an SQL statement
of:
select fld1, fld2 from invoice left join etc etc
I want to change it to
select fld1, fld2 from invoiceD left join etc etc
Help appreciated
Alex
I have a report and I want to change the tablename it refers to (without
losing its links to other tables). I know you can convert a template to a
textual representation, change it and then convert back but I cant remember
how to do it. Can anyone enlighten me? RB7.03
Just in case more clarity is needed, the report might have an SQL statement
of:
select fld1, fld2 from invoice left join etc etc
I want to change it to
select fld1, fld2 from invoiceD left join etc etc
Help appreciated
Alex
This discussion has been closed.
Comments
If you save the template as ASCII rather than binary, you can view the
template source in a text editor such as Notepad and see what needs to be
changed. You could then perform a find/replace on the file to updated the
stored SQL and Dataview object(s).
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com