Bug with PDF Report

So it seems that the bug with the PDF report and Multiple Lines Text field is still existent in V9 unfortunately, is there any way around this does anyone know? I was really hoping this issue would be fixed in this release.

The issue is that the width adjustment for the fields does not work at all, so when placing a muli-line text field on a PDF report, the text just goes off the side of the PDF report, and no matter what I have tried, it does not work, I have tried adjusting margins, adjusting field width, etc etc. I know that if you search on Google this is a known issue with V8 as well.

If anybody has any ideas on a workaround or a fix for this, I would appreciate an input as I really need it.

Thanks in advance.

Hi,
Try this:

  1. In the field choose multiple lines text and limit the characters with a number.
  2. In layout PDF interface put a number in width
  3. in layout PDF settings change to off the option “show html …” in general settings tab.

I had this issue en V8.1 but works fine for me in V9

[ATTACH=CONFIG]n77250[/ATTACH]

regards!

Captura de pantalla 2017-05-18 a la(s) 7.42.34 a.m..png

How to not show blank values in PDF report? I mean if some fields in mysql are blank, I want next field to show up and just avoid the blank field in PDF. I think blank fields ( having no value) always show in PDF report

Hello and good morning.
I have the same problem in V9:
. Multiple Text without line break and runs out of the page.
HTML = Off
Length 40 characters
SQL Type: Longtext

Did I something wrong? Or it is a bug? Any help?

Thanks
Axel

The workaround on the reports is to simply generate your code as normal and then look in the generated code and alter that. Check out the tcpdf examples. You can do a lot more with tcpdf then
you think.
See here: https://tcpdf.org/examples/ a must have link for people who make pdf…
And yes for almost all the functions there are sc_… functions for $pdf-> from the examples. I left a few examples somewhere in the forum, I had troubles with it before as well…

The field that you are talking is a sub-select ?
If is a sub-select then you are lucky, because in the area where you write your data you can chose the field to be “html” (and after that here you can write your text how you wanted to be displayed) => the result in pdf report will be that everything you did previously will remain there.

[ATTACH=CONFIG]n80968[/ATTACH]

If is not a sub-select…than you’ll have this problem (wich I think is another bug from Scriptcase):
http://www.scriptcase.net/forum/forum/main-category/main-forum/80907-print-html-cell-data-text-in-pdf-using-tcpdf

hope this helps you,
Dan

Capture.PNG