Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    5

    Unanswered: set zero amount as blanks in data reports

    I have a datareport with two columns (spaceno) (Misc. Charge)
    So my datareport prints out like this....

    spaceno Misc.Charge
    -----------------
    1 $250.00
    2 $100.00
    3 $0.00
    4 $0.00
    5 $300.00
    I dont want the charge's that are zero to show up. I want them to be blank.
    Is there a way I can have them be blank by doing something with the sql statement or can it be done using vb code. any ideas??
    Sample of what I need.....
    spaceno Misc.Charge
    -----------------
    1 $250.00
    2 $100.00
    3
    4
    5 $300.00

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    It depends on your reporting tool. Many of them have a simple checkbox for this behavior. If push comes to shove, you can get there via SQL relatively easily, but I'd strongly recommend finding a better way (on the client side).

    -PatP

Posting Permissions

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