When a report is more than page, I would like to have "continued" appear on the preceeding (but not last) page in FileMaker 6 for Macs and PCs.

Any clear advice on accomplishing this would be greatly appreciated:)

Thanks

Edited June 21, 200619 yr by Guest

Define an unstored calculation field (result is Text) =

Case ( Get ( RecordNumber ) < Get ( FoundCount ) ; "continued" )

Place the field in the footer. Note that this is version 7 syntax - you need to use the corresponding Status functions in earlier versions.

I tried the following calc:

Case( Status( CurrentPageNumber) < Status( CurrentFoundCount) , "continued" )

but it displayed "continued" on a one-pager; not sure what I am missing.

this: Case( Status(CurrentRecordCount) < Status( CurrentFoundCount) , "continued" )

and this: Case( Status(CurrentRecordNumber) < Status( CurrentFoundCount) , "continued" )

would not display anything.....

I'm thinking you'd have to use a script to go to Last Record and get page number there and store that in a global to be used as:

Case( Status(CurrentPageNumber) < Table::GlobalFieldHoldingMaxPageNumber, "continued...")

Edited June 22, 200619 yr by Guest

It works for me.

LastFooter.fp3.zip