Until now, we have seen a set of recipes that will make us confident about creating a simple report using Pentaho interactive report. Now we are going to present two recipes to help us become familiar with different ways of limiting the report output. This recipe shows you how to apply a filter to the report.
A filter is a sort of predefined condition we put at design time to limit or point our report output to a specific set of records we are looking for. While executing the report, the user is not able to change the filter. It is a sort of WHERE condition for anyone who is familiar with the SQL language.
Go to the
/Public/Pentaho BA Cookbook/Interactive Reports
folder and selectInteractive Rpt Sample 7
, which we created and saved in the previous recipe.Select Edit… from the File Actions menu.
The Interactive Report designer starts and opens the report in the Opened perspective.
Let's suppose we want to limit our report output to consider...