pdf report with varable number of columns

Scriptcase 9 General
#1

A variable number of students in a class. The class studies a number of subjects. The curriculum extends over several periods. The number of subjects varies dependent on the period of the curriculum. At any given time there are classes at a different point in the curriculum.

For the teacher conference for each class a report should be generated.The pdf report must show the marks for all students and all subjects of a class.

I try to use “pdf report” for this report, The marks of a student for a variable number of subjects is stored in a blob that is part of the mysql table for this report. (Column_Create(“1”,<mark1>,“2”, <mark2> …)

Because the number of subjects not only varies during the curriculum but also for the curriculum offered over time, creating an app for each curriculum and class is not an option for the customer as he would need to pay for later modifications of the project in the future.

How to solve this requirement with scriptcase?

#2

The PDF app is quite restrictive. Your best bet might be to use a blank app instead, and control TCPDF (Scriptcase’s underlying PDF generator) yourself. There are coding examples here…

https://tcpdf.org/examples/

We’ve used this approach in the past and it does give you pretty much total flexibility over the PDF layout. It’s not as simple as using the PDF app, of course, but once you’ve learned your way around it you can produce just about anything!!
:smiley:

#3

quite agree, since I use scriptcase, tcpdf is the best to display documents quite correct, it is necessary to simply declare the procedure tcpdf without the includes, in the code of layout of the pdf, the researches and variable in events: on record, and thats it, finally, after many hours of understanding the tcpdf and research in record and a selection via the search and selection of data, personal, I work for everything what is higher school with these documents, good luck
[ATTACH=JSON]{“alt”:“Click image for larger version Name: ex_1_mep_pdf.jpg Views: 0 Size: 197.3 KB ID: 89158”,“data-align”:“none”,“data-attachmentid”:“89158”,“data-size”:“medium”}[/ATTACH]
[ATTACH=JSON]{“alt”:“Click image for larger version Name: ex_2_or_pdf.jpg Views: 0 Size: 187.4 KB ID: 89157”,“data-align”:“none”,“data-attachmentid”:“89157”,“data-size”:“medium”}[/ATTACH]

ex_2_or_pdf.jpg

ex_1_mep_pdf.jpg

#4

I agree too.
I prepare all printouts of forms using tcpdf and blank app.
I also draw out the forms using tcpdf and they are identical to every pattern a client has.