Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011
    Posts
    3

    Unanswered: null field in crystal report

    Hi everyone

    I have a number of fields with null values on my crystal report, what i want is to change this null values to show 0, please how do I go about this? Any response would be appreciated.

  2. #2
    Join Date
    Jun 2011
    Posts
    4

    use formula

    Please create a formula and display it:

    if isnull({table.field} then
    0 else
    {table.field}

    Thanks,
    Krishnam

  3. #3
    Join Date
    Nov 2007
    Posts
    15
    Quote Originally Posted by phemie View Post
    Hi everyone

    I have a number of fields with null values on my crystal report, what i want is to change this null values to show 0, please how do I go about this? Any response would be appreciated.
    the reason you have null values because there isn't anything to report. if you want to report zeros then your source should have the zeros.

    or

    you can right mouse click on field then got to format field (is the field a number) then you can click customize field and change show zero values as (see choices)

    also getting a reference book 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
  •