Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Tuesday 21 March 2017

Tip : Pentaho PRD : Conditional background colour for cells in Pentaho PRD

select the number-field or text-field from detail band and write IF condition expression/formula for bg-color property as shown in below images to get the conditional background colour for cells 

If you have to show more than 2 colors write nested if condition in else block and continue till your requirement ends. 


Expression : =IF([passfail]="PASS";"green";"red")


   Sample output: 

:-)
Posted by at

2 comments:

  1. Jones Brianna26 May 2021 at 14:25

    Wow, amazing blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your website is fantastic, let alone the content!

    Sports Betting App Development

    ReplyDelete
  2. Manisha Sharma21 March 2024 at 16:25

    Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your new post. Fantasy Sports App Development Company

    ReplyDelete

Subscribe to: Post Comments (Atom)