PDF export
I am writing a report which contains statements for a large number of customers (300-400) My clients would like to email the statements so I am asked to created individual PDFs.
One way I can think of is split the query, but I am not sure that running 300 queries and running the report 300 times is the best option; an alternative could be to have the PDF export generate the files, based on a grouping, filenames could also be generated on the fly with a base plus an autoincremented suffix. Is there any way to do this with the current export to PDF ? would someone know where to start to do this ?
thanks
Didier
One way I can think of is split the query, but I am not sure that running 300 queries and running the report 300 times is the best option; an alternative could be to have the PDF export generate the files, based on a grouping, filenames could also be generated on the fly with a base plus an autoincremented suffix. Is there any way to do this with the current export to PDF ? would someone know where to start to do this ?
thanks
Didier
Comments
Thanks for your suggestion, I'll give that a go
Didier
IMO, filenames using an auto incrementing prefix is just trouble because you will not be able to immediately tie up an export file with an account.
I run a query for each account, create a PDF file with account code and date, so everything can be filed away and found easily if one wants to. This scheme also facilitates the virtual automatic production of copy statements at a later date if the customer asks for one.