How to pass recordset to PDF coding?

I have this doubt some time, but didn’t get the oportunity to post it.

I wanted to create a PDF report coding TCPDF directly to get full flexibility, following https://www.youtube.com/watch?v=y5LyMqfE-vw

FIrst problem I encountered was, SQL macros don’t works inside, and in video all is passed as vars.

What is the best way to go then? If I’m on a form and want to call a report, first I need to retrieve data and pass it as vars?

Look at the example …

The result is:

gui_pdf_test.png

pdf_example.zip (3.27 KB)

[QUOTE=RHS;33256]Look at the example …

The result is:

[/QUOTE]

You used this code inside a PDF report? I remember trying with SQL functions and didn’t worked for me :confused:

No, I’am use a blank application for that and a image as background.

Oh,ok…thanks I will try thanks :wink: