Tuesday 26 July 2011

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.



5 comments:

  1. this is very good post.. useful for 5+ exp guys... post something for freshers like me...

    ReplyDelete
  2. pentaho kya hein?

    ReplyDelete
  3. how to create google map in pentaho???????????

    ReplyDelete
  4. Thanks for the Post . It Worked Out for me . Many thanks :) .
    But Still having issues with date Paramters . Pl Help out if posible

    ReplyDelete