How to call stored procedure in pentaho report designer.

How to call stored procedure/kettle files in Pentaho designer?

There are two ways of running the stored procedures

If the procedure returns a resultset, then you can use the result like any other query in the report-designer by calling it via

"CALL procedure(${parameter1},${parameter2})"

However, if your procedure just returns a single value and you want to combine that value with results from other procedures or queries, then you have to use Pentaho Data Integration.