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: 

:-)