Avatar

Level 1

Greetings

I am kinda new to manipulating database results in PDF.

I am currently trying to generate a multi-pages PDF with a sql table query (in a first step) and I would like to get one record per content.

For example : I have a table named : customers containing 10 records (names, adresses and so)

I would like to have 1 customer per PDF page with all the information

How can I do that ?


- I can actually set up the database connection, returning me all the fields, but I do not see how to populate them when I generate the PDF.

- How can I set the "1 record per page" functionality ?

- I do not want to set up some buttons in the form to navigate though the records (first, next and so) neither do I want to update the database within the form

- Basically it is mean to perform auto-generation at the end.

These could seem to be easy questions, but I am kinda lost at the moment.

Hope anybody can help me

Settha.