PHsPeed forums
How to PDF Report based on DBQuery
-
Hi! I got a simple PDF based on form data using a template.
Can somebody gave me some advice or quick guide on how to create a PDF report based on a DBQuery (how can scan the dataset and add rows and cells for the data to the PDF?)
Regards -
Hey Victor, Here is the closest I can provide you to what you are looking for.
https://www.youtube.com/watch?v=OqelQwOBs1U
Kind Regards -
If the pdf row and cell structure is not sufficient, then the best way is to use the $$pdf_1 object directly. You can then use the samples available at tcpdf.org.
-
Hi, thank you for your responses...
What I want to do is to create rows and cells dinamically (at run time) to build a very customized PDF report.
Is this possible or I'm limited to the rows and cells created at design time?
Thank you very much, -
In this case I would create the cells manually using the pdf object directly. The raw component is available as a rtm property in the pdf object. The more static part van be defined using the standard components, the dynamic part on the pdf object.
Oher option is to add a row and cell, and use the value of the cell to assign your data to, and set html property to true. This will cause an automatic render of the html to the pdf.
Albert -
-
The most convenient way to display your table rows in a pdf is to create an HTML table with rows and columns and then use the WriteHTML function of the pdf library. It is exposed over your PHsPeed pdf object as described above. Naming of the object is incorrect and should be:
$$pdf_1->tcpdf->WriteHTML(....
See https://tcpdf.org/examples/example_006/A similar approach can be to add a pdfrow with cell, and apply the raw html to the value property of the cell.If you set HTML property to true, then the content will be rendered from html to pdf. Be aware that tcpdf does not support all fancy css stuf. For specification of what is supported, see the tcpdf.org docs.
from PHsPeed run time lib:
class sppdf extends spobject {protected $tcpdf; // reference to tcpdf object
