Page 1 of 1

printing attachments

PostPosted: Tue Mar 27, 2012 10:49 pm
by wes.s.grayson
I have a table called Customers. One of the fields in the Customers table is called Attachments (media field that stores PDF files). Since there may be many attachments for each Customer, I created an Attachments table and link the two tables using a customer_id field.

I would like to print out all the attachments related to a particular Customer in one combined PDF file. I've used plugins.pdf_output.combinePDFDocuments() in a previous method to accomplish something similar, but in this case I'm not sure how that would work across multiple records of another table.


Servoy 5.2.9
Smart Client

Re: printing attachments

PostPosted: Wed Mar 28, 2012 10:01 am
by Harjo
HI Wes,

just loop over the foundset, and combine them one by one...

pdf_blob_column = combinePDFDocuments(new Array(pdf_blob_column, other_pdf));

or create an array in the loop first, and than do one combine:

pdf_blob_column = combinePDFDocuments(new Array(pdf_blob1, pdf_blob2, pdf_blob3));