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

Change DatabaseName in existing report.

edited August 2001 in General
Yes, I read the tech tip and now I know to assign a connection device name
to a report rather than a backend database name. Although having a report
hardcoded to a specific connection device has its disadvantages also.

In the mean time, I have some existing reports created in one database that
I would like to run against another database. I store the reports in an
Oracle blob field. I can export the field and bring up the file into the
Delphi editor, but the lines are truncated. Can anyone suggest an editor
that will allow me to edit this file and hack the report or is there another
solution for changing this property in an existing report?


Thanks

--
Jim Poe (jpoe@fulcrumit.com)

Comments

  • edited August 2001
    You can automate the process by not doing the editing at all: Load it into a
    TStringList and change the relavent line.

    HTH,
    Ed Dressel
    Team DM

  • edited August 2001
    Hi Ed,

    Thanks. Should I be saving this in a CLOB field? Are the delimiters all
    CR/LF/TAB characters?

    --
    Jim Poe (jpoe@fulcrumit.com)
  • edited August 2001
    I save all of my reports as ASCII. There is a small hit for that in size,
    but I like the ability to pull it up in a ASCII viewer and read it...
    CLOB/BLOB--I don't use Oracle (I currently use IB and Paradox), so I will
    leave that up to you.

    Ed Dressel
    Team DM
  • edited August 2001
    I changed it to a CLOB field ( large character field ) and then I had to set
    the BlobType property in the clientdataset to ftMemo and it is now saving as
    ASCII. Looks very much like a dfm file :)

    I made the above changes and my report was saved as ASCII but the Report1
    component that is linked to my designer component had it's FORMAT property
    set to binary. Between the Report Explorer, Designer and Report components,
    is there another location to set ASCII/binary format?

    Thanks

    --
    Jim Poe (jpoe@fulcrumit.com)
This discussion has been closed.