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

Saving report template to a databse

edited December 2008 in General
Can I save a report template to a field in a record in an Advantage
database?

I have lots of reports and would like to save each report's template in a
different record in a database and then let the user select the record, load
that report and run it.

I see in the user manual instruction like the following, but I don't
understand how this would get the report template into a Blob field in my
Advantage table records. Can someone tell me if I can do it and if so,
maybe an example of the Delphi code?

Thanks

Whit

rb03.template.saveto := stdatabase;
rb03.template.databasesettings.namefield := 'name';
rb03.template.databasesettings.templatefield := 'Template';
rb03.template.databasesettings.datapipeline := ppRBTable;
rb03.template.filename := 'report03';
rb03.template.savetodatabase;

Comments

  • edited December 2008
    Hi Whitney,

    Yes it is possible to save report templates as blob fields to an Advantage
    database. Have you considered using the ReportBuilder Explorer feature to
    manage your templates. This gives a Windows Explorer-like interface to
    save, store, remove, and edit reports saved on a database. See the demo
    located in the \Demos\4. EndUser Databases\Advantage\1. Native\... directory
    for more information.

    The code you have below looks correct. What field type are you using for
    the template field? Are you receiving an error of any type?

    --
    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.