Saturday 26 May 2012

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.

3 comments:

  1. You must have not followed all the steps given above

    ReplyDelete
  2. It worked for me.. thanks

    ReplyDelete