Header of the table is displayed in the pdf file on first page, the body on second

[Ruxandra]

Hello!

I have a template including one main table which includes several small tables based on Select function to take dynamically data from my table 1. I had an issue and I used solution from this topic :

Solved: Re: How could I making a table in template doc vis... - Google Cloud Community

I created the template, the small tables are arranged quite well, the pdf with data looks good, but I have a problem with the header of the main table, it is displayed on the first page of the pdf, and its body including all small tables are displayed beginning with second or third page; I noticed this happened only if Select function brings more data (many rows displayed in small tables).

Could you help me understand what happens and what solutions could I have to solve this issue?

Thank you!

Regards!

Ruxandra

[WillowMobileSys]

The PDF generation process treats the template document basically like one big page.   The page breaks are inserted at the end.

Unfortunately, there isn't any good way to control page breaks based on the number of rows of data. 

If your template is fairly static in size up until the table, you could either:

Use template IF statements to inspect the table row count and decide insert the table OR insert a page break first and then start the table on the next page.

OR

You could simply insert a page break and ALWAYS start your table on the next page.  

If you need more control than that, the out-of-box PDF generator doesn't have any support for it.  There are a couple Tips posts that might help but do require additional learning curve.  See the articles below

I hope this helps!

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Workflow-pagination-headers-and-footers/m-p/3827...

Pixel Perfect pagination

Part 1 -   https://www.googlecloudcommunity.com/gc/Tips-Tricks/Part-1-Almost-pixel-perfect-pdf-reports-from-aut...

Part 2 -  https://www.googlecloudcommunity.com/gc/Tips-Tricks/Part-2-Pixel-perfect-paginated-reports/m-p/41695...

Part 3 -  https://www.googlecloudcommunity.com/gc/Tips-Tricks/Part-3-Pixel-perfect-reports-with-Skia-AppSheet-...

[Ruxandra]

Hello!

Thank you for your answer. I have read the first article and I found a work-around, I integrated all my works, text and main table and also small tables in another table containing one column; everything goes to the second page, I think it will be acceptable by user because this doc will be printed, but what I don't like it's on first page appears the name of the template file. Why? I need to delete it.

Many thanks!

Regards!

Ruxandra

[AleksiAlkio]

May I ask what do you exactly mean with this.. "on first page appears the name of the template file." Would you please take a screenshot from it, thanks.

[Ruxandra]

Hello!

Print-screen below! This is the first page of the document, blank, but on the left corner is displayed the name of the .doc template.

Thank you! Regards!

[Ruxandra]

I've made another test and I notice it's not working anymore as  I said to WillowMobileSys;  I really don't understand what's going on... 

[Ruxandra]

Well, I understand now what's going on, why the name of the file appears on my pdf.  It's because of the new feature of google doc, document tab, the name of the file was taken as name of first tab, and then, on my pdf file. I renamed the tab, and what I wrote, it was displayed on my pdf file instead of the  name of the templates. And I think, it also affects  what i have done following the advices of WillowMobileSys... There is no option to delete this tab, or to color it, on white, for example...

[AleksiAlkio]

Yes that's true, it will show the tab name when you generate the pdf and if you want to use tabs, you are not able to "hide" them. The only workaround at this moment is to not use tabs.

[Ruxandra]

Could you tell me how to disable "tabs"; I tried to find in my template, but I didn't fin anything that help me to cancel tabs. It is not possible to delete the first tab. 

Thank you!

Regards!

[AleksiAlkio]

If you remove first all heading text from your template, it should not show the main tab anymore on your PDF. I tested this.. I created a new template from the task, then I changed the Heading to a normal text, and the PDF doesn't have that tab name anymore.

[Ruxandra]

I have no Heading text, all my text is normal, no Header and Footer, all margins are on 0.I created the templates months ago. The name of the Tab was displayed first time yesterday and today I notices the "Document tab" displayed on the left of the doc. 

Thank you!

Regards!

Ruxandra

[AleksiAlkio · Accepted solution]

Create a new template from the Bot/Task, remove the headings, test that it doesn't show tabs on your pdf anymore and then copy the content to this new template.

[Ruxandra]

Hello! 

I created a new template and it's ok now. Because of the issue about the header, I used another work-around and I keep all data in one place (I integrated the header of the main table in its body as a small table, it works well).

Thank you!

Regards!

Ruxandra

[themacboy]

Solved for me too. Thx

[Ruxandra]

Hello again! 

It seems it is because of "document tab" feature from Google doc, and I think, there is no way to delete, as I have read the documentation of Google Doc. Besides this, the solution I was talking about, doesn't work anymore, and I have again the header of the table on first page, and the body on next page.😕  

[jkevz]

Hello! I want to ask if you have managed to add a page header or page count in each pages of your pdf?

[Ruxandra]

Hello!

No, it didn't work. I gave up.

[jkevz]

Okay! Maybe I will try the other way using HTML.