Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Change values "0" or "null" to " false"

  1. #1

    Default Change values "0" or "null" to " false"

    Hi .
    Can somebody help me. I'm making a report and i have an column that has 1,0, or null in it. In my report i don't want to show this values but if it is 1 to show yes, and if it is 0 or null to show false. Pls help me!

  2. #2
    Join Date
    Mar 2003


    Use a Value-formula on the element with the formula
    =IF([field] = 1; "yes"; "no")
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3


    Thanks Taqua

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.