Print different reports with sequential numbering

[jccollins]

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.

[jccollins]

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.

[jccollins]

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.

[BobWeaver]

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

[BobWeaver]

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

[BobWeaver]

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

[jccollins]

Thanks, I'll give this a shot.

[jccollins]

Thanks, I'll give this a shot.

[jccollins]

Thanks, I'll give this a shot.

[eljefejb]

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

[BobWeaver]

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

[eljefejb]

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!