I am new to Filemaker and trying to print 3 different reports but with sequential page numbers. I would like to evaluate how many pages are in a report , store this number and begin printing the next report with the next page number. I do not wish to have to enter the "Begin printing with Page Number" screen that pops up with the Print function. I would like it to be more automatic. Every thing I do to evalutae the number of pages, seems to be "unstored". Thus, not allowing me to input the # into another field.

Hope this makes since. Any ideal of help is appreciated.

I am new to Filemaker and trying to print 3 different reports but with sequential page numbers. I would like to evaluate how many pages are in a report , store this number and begin printing the next report with the next page number. I do not wish to have to enter the "Begin printing with Page Number" screen that pops up with the Print function. I would like it to be more automatic. Every thing I do to evalutae the number of pages, seems to be "unstored". Thus, not allowing me to input the # into another field.

Hope this makes since. Any ideal of help is appreciated.

I am new to Filemaker and trying to print 3 different reports but with sequential page numbers. I would like to evaluate how many pages are in a report , store this number and begin printing the next report with the next page number. I do not wish to have to enter the "Begin printing with Page Number" screen that pops up with the Print function. I would like it to be more automatic. Every thing I do to evalutae the number of pages, seems to be "unstored". Thus, not allowing me to input the # into another field.

Hope this makes since. Any ideal of help is appreciated.

First, you will need to have a global field gPageOffset to store the page number offset.

Now you can have a calculated page number field (unstored) called PageNumber with the formula:

gPageOffset + Get(PageNumber)

Then display this field on your reports to show the page number.

Now, to calculate the offset, start out with gPageOffset with a value of zero for your first report and then just after you run each report (before you switch layouts, change the found set or sort order etc.) perform this script:

Enter Preview mode

Go to record/request/page[last]

Set Field[gPageOffset, gPageOffset +Get(PageNumber)]

Enter Browse mode

First, you will need to have a global field gPageOffset to store the page number offset.

Now you can have a calculated page number field (unstored) called PageNumber with the formula:

gPageOffset + Get(PageNumber)

Then display this field on your reports to show the page number.

Now, to calculate the offset, start out with gPageOffset with a value of zero for your first report and then just after you run each report (before you switch layouts, change the found set or sort order etc.) perform this script:

Enter Preview mode

Go to record/request/page[last]

Set Field[gPageOffset, gPageOffset +Get(PageNumber)]

Enter Browse mode

First, you will need to have a global field gPageOffset to store the page number offset.

Now you can have a calculated page number field (unstored) called PageNumber with the formula:

gPageOffset + Get(PageNumber)

Then display this field on your reports to show the page number.

Now, to calculate the offset, start out with gPageOffset with a value of zero for your first report and then just after you run each report (before you switch layouts, change the found set or sort order etc.) perform this script:

Enter Preview mode

Go to record/request/page[last]

Set Field[gPageOffset, gPageOffset +Get(PageNumber)]

Enter Browse mode

Thanks, I'll give this a shot.

Thanks, I'll give this a shot.

Thanks, I'll give this a shot.

Bob -

I created a table called "Pages" with one variable, "gPage" (global, number). In two of my layouts I created a field called "pageNum" and under the Auto-Enter tab, checked the "Calculated value" box and specified "Pages::gPage + Get ( PageNumber )" as the formula. I then display this field in the footer of my layouts. In my script, I first set gPage to 0, then go to my first layout, enter Preview mode, show a custom dialog (to trace values and pause the script for a sec) then re-calculate gPage based on the last page of the layout. Then I switch to the next layout and do the same thing. However, the "pageNum" field is always blank on my layouts! What am I doing wrong? When I echo Pages::gPage + Get(PageNumber) in the custom dialog, the value displays just fine. But there appears to be no actual value entered into the pageNum field. Why not?

Thanks for the help,

Jeff

pageNum should be an unstored calculation, not an auto-enter calculation.

Yup, that was the problem! I had the field set up as number -> auto-enter calculation. I didn't realize there was a 'calculation' field type (total newb here).

You're the man, Bob! Thanks for your help!