AnsweredAssumed Answered

Numbering Pages on Combined Reports for Print

Question asked by markmeer on Feb 6, 2017
Latest reply on Feb 6, 2017 by markmeer

I've got a (parent) table, "Employees", with several related tables: "training", "incidents", "shifts"..etc.


What I'd like to be able to do is print a report (PDF), that contains all data from parent table and all related tables for a given employee.

Because of the difficulty with formatting portals, I've written a script to simply print each table separately (from dedicated list-view layouts), appending to a PDF of the same filename each time.  This results in a single PDF with all the information, and is formatted reasonably well (massive pagebreaks notwithstanding...).


Anyway, this approach is acceptable except that I'd like to number the pages with a footer reading "Page (n)  of (totalPages)".

I've noticed an idea suggestion logged to this effect (which I've upvoted), but I'm curious if anyone can think of a workaround in the meantime...


I know one possibility is to create a single, massive, report table that combines all associated data from related tables beforehand, but the scripting and layout task this presents is a bit overwhelming.


Can anyone think of a way to calculate and insert page numbers (and total page count) when reports are combined like this?


Thanks in advance!