Conditional Styling in Pentaho Report Designer
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
Today in this blog we’ll specifically concentrate on how to implement specific conditions in Pentaho Report designer. Here we’ve basically concentrated on the styling front whereas PRD gives a wide number of conditioning option ranging from styling to formatting to each and every smaller detail one could use to apply specific detailing to their reports.
To start off I’ve created a very simple report showing the Average Price for each Product grouped on their specific customer number.
Now I want to showcase a condition where I need to differentiate between the Avg Prices greater than 2000 and less. For that I’ve put up a condition where I can mark those less than 2000 as Red and the others as Green all at the Text level.For that we need to specify the condition as per the screenshot below where I’ve used the expression option in the text styling for writing my required formula for the above condition to be fulfilled.
Finally the output looks as the screenshot below.
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
Sayed Shakeeb Jamal
Best Open Source Business Intelligence Software Helical Insight is Here
