1701418 - How to print records in page front side and back side of a single paper in Crystal Reports

SAP Knowledge Base Article - Public

1701418 - How to print records in page front side and back side of a single paper in Crystal Reports

Symptom

How to print Detail section records in Report’s Page Front side and Terms and Conditions or images on Page Back side of the report

Environment

Crystal Reports 2008

Resolution

  1. Create a Group on a Field and Suppress the Report Header, Page Footer and Report Footer sections.
  2. Right-click the group’s footer and select ‘Insert Section Below’.
  3. Create a formula field named ‘PageNumberIncr’. Add the following text to its formula text:

WhilePrintingRecords;
Numbervar nPage := nPage+1;

  1. Add this field in the group header section, then suppress it. This formula will increment a page counter every time the group header section is create, which is once per customer.

In Group footer 1A

  1. This will acts like the reports’s page footer
  2. Right-click the section and select Section Expert… Check ‘Print at Bottom of Page’, then click ‘OK’ to close the dialog window
  3. Create a formula field named ‘Page N of M’. Add the following text to its formula text:

//Use this field if you only want to count the front of each page
WhilePrintingRecords;
Numbervar nPage;
"Page " & ToText(nPage,0) & " of " & ToText(TotalPageCount/2,0)

  1. Add this filed to the GF1A section, size it to be the width of the section, then click the ‘Align Center’ toolbar button.

In Group Footer 1B

This section will act as the back page of the report
Resize the section to be nearly a full page in length–for starters, try 9.5″. Next, insert an image or text object that contains your images or terms and conditions into this section.
Finally, right-click on the section’s name and select Section Expert… Check ‘New Page Before’ and ‘New Page After’, then click ‘OK’ to close the dialog windows.

Note: If don’t have access to a duplex printer, print the odd-numbered pages (the fronts) first, return these pages to the printer (making sure to orient the pages correctly), then print the even-number pages (the backs).

Keywords

print report in front and back side of pages, duplex printer, Terms and conditions on page back side, print images on page back side, print records in page back side, crystal reports , KBA , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011