merkaba22 Posted June 21, 2006 Share Posted June 21, 2006 (edited) 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, 2006 by Guest Link to comment Share on other sites More sharing options...
comment Posted June 21, 2006 Share Posted June 21, 2006 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. Link to comment Share on other sites More sharing options...
merkaba22 Posted June 22, 2006 Author Share Posted June 22, 2006 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..... Link to comment Share on other sites More sharing options...
Genx Posted June 22, 2006 Share Posted June 22, 2006 (edited) 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, 2006 by Guest Link to comment Share on other sites More sharing options...
comment Posted June 22, 2006 Share Posted June 22, 2006 It works for me. LastFooter.fp3.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6518 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now