Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: format message-fields.

  1. #1

    Default format message-fields.

    How can i format a message field in rd 3.5

    for example i want to format a message field as money, like i would would a number field.

  2. #2


    or better yet is it possible to dynamically convert field types?

    Lets say i have colums that returns sales.

    most times i'll just use a number field and format it to look like the following,


    However sometimes the database returns null. and i want my report to display N/A.

    my solution was to add a formula if(isna([sales]);"N/A";[sales])

    the problem is if i use a number field it will not display "n/a". If i use a text or message field. i cant format my number into a currency format.

    any help will be appreciated.

  3. #3
    Join Date
    Mar 2003


    The message-fields can contain Number-Formats, by using a Number subformat.

    Every element has a "null-value" attribute that will be printed instead of the value read from the field, if the field's value is null. There is no need to do formula-magic, just fill in the correct value into the null-value attribute.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

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.