Creating footers after the first page

You may choose to print a page footer on all pages except the first page. You can do this by formatting the Page Footer section conditionally, using an on or off property.

To create footers after the first page

1. Place the field you want displayed as a page footer in the Page Footer section of the report.

2. On the Format menu, click Section.

   The Section Expert dialog box appears.

   

3. In the Sections area, click Page Footer.
4. To open the Format Formula Editor dialog box, click the Formula button, located to the right of the Suppress (No Drill-Down) check box.
5. Enter the following formula in the Format Formula Editor:

Crystal syntax example

PageNumber = 1

Basic syntax example

formula = PageNumber = 1

This formula suppresses the page footer on the first page, but not on any of the other pages.

6. Click Save.

Note:    

• If there is an error in the formula, a message box appears, asking whether to exit without examining the error. If you click No, a second message box will be displayed, detailing the error.
• If there is no error in the formula, you are returned to the Section Expert. Note that the Formula button has changed. This indicates that a formula has been entered for that property. Search for Formula Compiler Errors in Seagate Crystal Reports online help.

7. On the Standard toolbar, click Preview to preview the report and ensure that the page footer appears on all pages but the first.

Note:    

• If you have a multi-line page footer and have inserted the lines into separate Page Footer sections, you will need to suppress each section conditionally, using the formula above.
• To create a page header that appears on all pages but the first, place the header information in the Page Header section and then suppress that section conditionally, using the same formula that was used for suppressing the Page Footer section.