ReportBuilder and Oracle 8i

rbuser

How can I store a report in a database and so far how can I retrieve it ?
This is what I need ...

my customer ask for a certificate at one date, after that , all data may
change or not, it?s up to customer courses, companies, and even I could
delete some records, here?s the question point, I need to know what was the
data printed exactly in that certificate. So I thought I could put the
report inside the database, but I could not imagine how to put or how to
retrieve and print it again.

Thanks, for any Idea !

digitalmetaphors

You have a couple of options. You can store report archives to the database.
Basically you can stream it to a blob field. The report archive is a
snapshot of the database for a given point in time. You can retrieve this
report and print it at a later date. If you would like to run a report on
live data when it report is retreived, then you must use a report template
in the database. The report template is the report definition. You can store
the data access components in the report (DADE) and you can store the report
calculations in the report (RAP). The report templates are portable. As an
end user, you can use the Report Explorer component to find the templates in
thr database and preview them from the latest data on the database or launch
the report designer to edit the report and then print it. You can also use
the Report.Template.LoadFromDatabase routine to load a template from a
database. There are examples of using the full end user reporting solution
in the RBuilder installation. See your installed
RBuilder\Demos\EndUserDatabases\Oracle for an example.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thanks Jim .

digitalmetaphors

I forgot to mention that there is a DBArchiveReader component in RB 7 that
lets you show report archives directly from the database. There is a full
demo #155 in the main report demo project of your installation.


Cheers,

Jim Bennett
Digital Metaphors