Crystal Reports for Eclipse Designer Guide

PreviousIsNull (fld)

Description
Evaluates the field specified in the previous record and returns TRUE if the field contains a null value.
Arguments
  • fld is any numeric, formula, memo, or BLOB field in the report.
  • Returns
    Boolean Value
    Action
    Evaluates the field specified in the previous record and returns TRUE if the field contains a null value.
    Typical uses
    You can use this function to test for the first item in a list and to take some action when that first item is identified.
    Examples
    If PreviousIsNull ({employee.EMPLOYEE ID}) Then
         "First employee of record" 
    Else
         ""
    In an employee database with no null values in the Employee ID field, flags the first employee on the list.



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