How to called stored procedure from Jasper Report?

Question

Hi,

How to called stored procedure from Jasper Report?

Best Regards, Vipul Gupta

Answer 1

Here you go...

Answer 2

JasperReport doesn't support calling stored procedure/function directly from his SQL datasource. The best way I found to overcome that limitation is to create a Java bean that calls the stored procedure (via JDBC or Hibernate) and returns a collection of objects which represent the result set. If you're using iReport, just change the Data Source Expression to use that Java bean. There's good section on data sources in the (not free) iReport manuals.