Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Changing cell color in prd

  1. #1
    Join Date
    Oct 2014
    Posts
    13

    Default Changing cell color in prd

    Hi,

    How to change the cell color(Dynamically) in pentaho report designer.

  2. #2
    Join Date
    Nov 2009
    Posts
    687

    Default

    In the Style pane of the cell you can make an formula to define your bg-color

  3. #3
    Join Date
    Oct 2014
    Posts
    13

    Default

    Quote Originally Posted by sagarika View Post
    Hi,

    How to change the cell color(Dynamically) in pentaho report designer.
    I used this formula in structur-->style-->bg color panel
    IF([STvalue]<0;"green";IF([STvalue]>0;"yellow";"red")).

    When i run the report it doesn't shows the result.

  4. #4
    Join Date
    Nov 2009
    Posts
    687

    Default

    You have the equal sign before the formula?
    =IF([STvalue]<0;"green";IF([STvalue]>0;"yellow";"red"))

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.