Pentaho: Parameterized Report

Step 1: Add a new Data Source.

Step 2: Add two queries

Query 1:

SELECT

     "EMPLOYEES"."EMPLOYEENUMBER",

     "EMPLOYEES"."FIRSTNAME",

     "EMPLOYEES"."JOBTITLE"

FROM

     "EMPLOYEES"

Where "EMPLOYEES"."EMPLOYEENUMBER"=${ENO}

Query 2:

SELECT

     "EMPLOYEES"."EMPLOYEENUMBER"

FROM

     "EMPLOYEES"

                                    

Step 3: Add a parameter. Set the properties.

                                            

Step 4: Run the report.