Subject:creating mulitple PDF reports Author:rob campbell Date:16 Oct 2006 09:02 AM
I would like to run a financial reports off an MS Access table - the
table consists of transactions for a given month and includes multiple
transactions for account numbers. I would like to generate a PDF report
for each account number (showing the detailed transactions) and be able
to customize the name of the PDF file to include the account number (or
some other field in the table). So, from one MS Access table, I may
produce 50 different PDF reports, the number depending on how many
unique account numbers there are. Ideally, I would like to produce the 50 reports (with their customized file names) and have them dropped into a folder.
Subject:creating mulitple PDF reports Author:Ivan Pedruzzi Date:16 Oct 2006 12:41 PM
Rob,
One possible approach is to export the table as XML using then use XSLT to generate XSL-FO then use an FO processor (for instance NFOP) to generate PDF