Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Change template in its text representation

edited March 2009 in General
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

Comments

  • edited March 2009
    Hi Alex,

    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.