Saving report template to a databse
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;
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;
This discussion has been closed.
Comments
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com