Crystal Reports for Eclipse Designer Guide

NextIsNull (fld)

Description
Evaluates the field specified in the next record and returns TRUE if the field contains a null value.
Arguments
  • fld is any valid database, formula, memo or BLOB field in the report.
  • Returns
    Boolean Value
    Action
    Evaluates the field specified in the next record and returns TRUE if the field contains a null value.
    Typical uses
    You can use this function to test for the last item in a list and to take some action when you identify that last item.
    Examples
    If NextIsNull ({employee.EMPLOYEE ID}) Then
         "Last employee of record" 
    Else
         ""
    In an employee database with no null values in the Employee ID field, flags the last 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/