PDF export

didiergm

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

gpi

You may set TfrxPDFExport->PageNumbers and export a range of pages

didiergm

Sorry for not answering earlier, I was away on business

Thanks for your suggestion, I'll give that a go

Didier

technisoft

I think it would be far easier to run the query and report 300+ times. After all, this is what computers are for, to perform repetitive tasks.
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.