FileMaker Page Numbering & Separate Print Jobs
Alex Brophy and I solved this problem just this week. The solution involved these items…
Create a field:
- We created a global variable, something like $$ReportBasePageNumber and then created a calculated unstored field in the table that we are printing from called zzReportPage = Get ( PageNumber ) + $$ReportBasePageNumber - 1. If you are printing from several tables, you need this on each table as it will be used to print the page numbers.
- In the table that we are printing from we added the field zzReportPage to the layout on the right and left sides. We used conditional formatting to make the page number white so the page numbers would show on the left or right appropriately.
In the report script you:
- Start off by initializing $$ReportBasePageNumber to 1.
- Setup the first portion of the print job, go to Preview Mode. The page numbers should be correct.
- Go to the last Page while in preview mode, and set $$ReportBasePageNumber = Get ( PageNumber ) + 1. This is the starting page number for the next print job.- Setup the second portion of the print job, go to Preview Mode. The page numbers should be correct.
- Repeat.
