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

Report Template? For saving into the database?

edited May 2003 in End User
Hi,
I would like to know the difference. The TppReport.Template property is used
for report saving into the database into the Memo or BLOB format.(At least
that is what yout documentation says.) But nowhere in the demos provided
this property is used for saving into database. Instead all saving there is
performed through the ReportExplorer and ItemsTable. (But data field type
must be "LONG"!!!). Is there a difference?

Thanks.

Comments

  • edited June 2003
    The Report.Template is a Delphi object. You can use it to save to database
    or file using its interface. When you call Report.Template.SaveToDatabase,
    it will try to stream the report template to the database using the
    DataSettings you have configured on the Report.Template.DataSettings. Then
    we rely on Delphi and code the saving of the report by writing to a stream
    on the BLOB field, which you have defined as LONG on your particular
    database. Some databases are different, on some you have to specify LONG as
    the datatype, some as BLOB and some as Image, etc. just be sure it works
    when you write a BLOB stream to the field and it works using Delphi. All of
    our end user database demos have SQL scripts or ReadMe docs which describe
    the database types that we have successfully used when saving a report
    template to the Template field on the database table. Check those out to see
    what we do in our examples and you should use the same type as we do.

    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited June 2003
    I see. I finally understand. Thank you.

This discussion has been closed.