Friday, 23 August 2013

Pentaho Report with Kettle as Data source

Pentaho Report with Kettle as Data source

I am trying to call a kettle transformation using a pentaho report. My
transformation will retrieve a resultset from table based on a command
line argument. The report generates the correct output if i remove the
command line argument from the ktr and run the hard coded SELECT sql. but
it retrieves empty when we pass command line arguments/parameters.
The report works good when i click preview with arguments, but not working
after i publish it.
My parameters are not getting passed to the kettle transformation.
Report Parameter: ondate Kettle Named parameter: ONDATE (I have mapped
both in my report)
did i miss something?

No comments:

Post a Comment