Results 1 to 3 of 3

Thread: Is there a Null Zero in Crystal Reports?

  1. Feb 17th, 2004, 04:03 PM #1
    BukHix
    BukHix is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2003
    Location
    Three Rivers, MI
    Posts
    354

    Is there a Null Zero in Crystal Reports?

    Does CR have a NZ Function similar to Access where I can say if a field is a 0 I want to put an empty space.

    This is the code I am using:

    If{PRTH.EarnCode} = 115 Then {PRTH.Hours} Else 0

    Which gives me this:


    I want to get this:
    Reply With Quote Reply With Quote
  2. Feb 17th, 2004, 04:42 PM #2
    ducky
    ducky is offline
    Addicted Member
    Join Date
    Jan 2001
    Location
    MPLS
    Posts
    187
    Right click and edit format of the formula after its placed on the report in the designer. Then in the customize options select suppress if zero.
    Reply With Quote Reply With Quote
  3. Feb 17th, 2004, 04:52 PM #3
    BukHix
    BukHix is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 2003
    Location
    Three Rivers, MI
    Posts
    354
    Perfect Thank you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width