Results 1 to 2 of 2

Thread: Null Values in Crystal

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jun 2000
    Posts
    80

    Question

    I need to display a default text value in Crystal Reports whenever a certain field is null in the recordset and I can't seem to figure out how. Thanks in advance.

    -Jack Vinitsky

  2. #2
    PowerPoster 2.0 Negative0's Avatar
    Join Date
    Jun 2000
    Location
    Southeastern MI
    Posts
    4,367

    Formula

    If you use a formula field you can check a field value:

    Code:
    if length({table.field})>0 then table.field else "Default Value"
    Hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width