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!
    Thanks

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

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

  3. #3

    Default

    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.