SAP Knowledge Base Article - Public

1214067 - How do you print repeating text objects on every other page?

Symptom

  • In Crystal Reports, you have a repeating text object and you want it to print on the reverse side of every page. Moreover, when you have set up the printer to print duplex, the repeating text object prints on the reverse side of every page.

How can you achieve this so that the repeating text object prints on every even numbered page?
For example:
You would like to see Terms and Conditions print on the reverse side of each page. How would you achieve this?

Environment

  • SAP Crystal Reports 2016

Resolution

To set up Crystal Reports to print repeating text objects on every even numbered page, complete the following steps:

1. In design mode, right-click the gray margin in the report where it states 'Page Header'.

2. From the fly-out menu, ensure it says 'Page Header' and select 'Insert section below'.

3. Insert the text object into Page Header b. Keep the fields and objects that are to appear on every odd numbered page in Page Header a.

4. Size the Page Header b so that it takes up the space of one full page.

NOTE: =====

If you receive an error message stating that the object is too large for the page, you will have to resize the Page Header b to be smaller. Sometimes page sizes vary from printer to printer.

==========

Conditionally suppress both Page Header sections by creating two formulas. One of the formulas will conditionally suppress the Page Header a so that it only prints on even pages and the other formula will conditionally suppress the Page Header b so it only prints on odd pages.

CONDITIONALLY SUPPRESSING PAGE HEADER A

====================

The following formula will conditionally suppress Page Header a so that it only prints on even number pages:

1. From the 'Insert' menu, select 'Section'. The 'Section Expert' appears.

2. Select 'Page Header a' from 'Sections:'.

3. Click the 'X+2' button beside 'Suppress (No Drill-Down)'. This launches the 'Format Formula Editor'.

4. Create a formula similar to the following:

// suppress the regular page header on every

// even numbered page

remainder(pagenumber,2) = 0

CONDITIONALLY SUPPRESSING PAGE HEADER B

====================

The following formula will conditionally suppress Page Header b so it only prints on oddpages:

1. From the 'Insert' menu, select 'Section'. The 'Section Expert' appears.

2. Select 'Page Header b' from 'Sections:'.

3. Click the 'X+2' button beside 'Suppress (No Drill-Down)'. This launches the 'Format Formula Editor'.

4. Create a formula similar to the following:

// suppress page header with repeating text objects

// on every odd numbered page

remainder(pagenumber,2) <> 0

See Also

Attached is an alternative solution report with Page Header and Page Footer

Keywords

DUPLEX PRINTING OBJECT ON REVERSE SIDE OF PAGEREPEATING TEXT OBJECTS Crystal Reports Duplex printing Formatting pages , c2010387 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2016

Attachments

Sample report with picture on second page.zip