Pentaho: Passing parameters from .xaction to .prpt

Pentaho allow us to pass parameters from .xaction file to .prpt file. This can be done by following steps:

1. Create a .prpt file in Report Designer.

2. Add a parameter DN.

3. Query:

SELECT  "EMP"."EMPNO", "EMP"."ENAME", "EMP"."SAL", "EMP"."DEPTNO"

FROM "EMP" WHERE  "EMP"."DEPTNO"=${DN}

4. Add Row Banding Feature.

5. Preview will look like this:

  

6. Create a xaction in Design Studio.

7. Add an input parameter DN

                   

 8. Add pentaho Report in Process Action. Under that select a .prpt file and add a Report Parameter DN.

                                                   

 9. Select Process Output.

                                                    
10. Test the xaction.