I have a tricky problem, whereby I need to separate records depending on how many pages they have.  Most records will only be 1 page long but occassionally it will overflow into two pages. For printing purposes I need to separate all of the records that have 2 pages.

 

I have a Formula Field called @2ndPage, which inserts the text"2nd Page" if there is more than one page.

 

I intended to use a parameter to select whether I wanted the single page records or the multi-page records, however I can't select records based on a formula field that contains PageNumber. I think this has something to do with records being selected in the first pass, whereas page numbers are added in a later pass.

 

Any thoughts?