technologist.kj

There were certain config changes to be done over the ones given in jasper's examples. They are documented here - http://www.codemarvels.com/2012/12/implementing-a-custom-query-executor-custom-data-source-in-jasper-server/

updated as answer.

Figured out that the concept of a "datasource" is different in iReport UI and jasperServer. Please follow this tutorial to create a custom query executor in jasper server.

Hello guys, Is there a way to put report parameters (that can be picked from JRXML as P{xxxx} ) from inside a custom query executor ? Regards Sree

I'm using JRBeanCollectionDatasource with Jasper server. I could test the datasource successfully by providing "beanIdInSpring" and "getMycollection" as the bean and function name in the add new datasource page. The "getMyCollection" function inside the bean returns and arraylist of class "MyBean". Although such a setup works well in IReport, when I try to view this in Jasper Server I get this error - java.lang.ClassCastException: java.util.ArrayList cannot be cast to com.jaspersoft.jasperserver.api.metadata.jasperreports.service.ReportDataSourceService at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BeanReportDataSourceServiceFactory.createService(BeanReportDataSourceServiceFactory.java:89) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.createDataSourceService(EngineServiceImpl.java:710) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:655) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:356) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:788) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:60) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:288) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:329) at com.jaspersoft.jasperserver.war.action.ViewReportAction.verifyData(ViewReportAction.java:222) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136)

How did you solve this Daniel ? I'm workng with jasper server and JRBeanCollection datasource - hitting this issue now :)