Change DatabaseName in existing report.

rbuser

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)

rbuser

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

rbuser

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)

rbuser

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

rbuser

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)