Suggestions for creating complex report to .pdf

Yes, you are missing the fact that rendering HTML to PDF is always going to be an horrible experience.

I played with it a little, no, a lot, and if you are very lucky, this could help you with headers and footers: Printing to PDF with good header and footer

You can use the PageBreak from Anvil Extras.