Skip to content

How to Display when a Record is Continued on Another Page

I usually try to format my reports so that a record has a clearly delineated start and end (either a line below, or shading the group header.) However, it can still get confusing if a record is continued, especially if the record contains a lot of text. Here is a quick way to use a formula to add a “Continued on Next Page” blurb when a record is broken by a page break:

  1. Set up your report, grouping and formatting to fit your needs. In our example, we are grouping on Salesman.

  2. Create a new formula called Continued, evaluating the field you are grouping on. In our example, we grouped on the field Sheet1_.Salesman, so our formula would be

    If {Sheet1_.Salesman} = Next({Sheet1_.Salesman}) Then {Sheet1_.Salesman} & " continued on next page"
  3. Add this formula to the Page Footer of your report. If you want, add some formatting. I added a top border, and made the text italic.

  4. Preview your report to make sure it looks how you want.


Continued from Previous

You can also use this approach to make the next page say Continued from previous.

  1. Create a new formula called Previous, similar to the last one
    If {Sheet1_.Salesman} = Previous({Sheet1_.Salesman}) Then {Sheet1_.Salesman} & " continued from previous page"

  2. Place this in the page header.

    I found it was best to add a new Page Header Section. I then right-clicked on the Page Header section and selected Section Expert. On the dialog I selected Suppress Blank Section.

Leave a Reply