Crystal Reports for Eclipse Designer Guide

To add blank lines conditionally

  1. Place the report detail data in the top section.
  2. Right-click the second section and from the context menu, click Conditional Formulas.
  3. Select Suppress and then click OK.
  4. Enter the following formula:
    Remainder (RecordNumber,5) <> 0
    
    This formula divides each record number by 5. If the division produces a remainder, it suppresses the blank section. But if the division produces no remainder (which it will for every fifth record printed), the program prints the second section, thus inserting a blank line.

Note: To insert a blank line under different conditions, you can modify your formula appropriately.



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/