Steps to add JRQueryExecuterFactory to JasperReports Server

This article assumes that you've already implemented a custom query executor and you only need to add it to JasperReports Server.

Adding JRQueryExecuterFactory

To add a custom JRQueryExecuterFactory to JasperReports Server all you have to do is add it into jasperreports.properties file under the /Jasperserver-pro/WEB-INF/classes/ folder as follows:

net.sf.jasperreports.query.executer.factory.sql=
com.jaspersoft.commons.util.JSControlledJdbcQueryExecuterFactory

where last part of the key - sql - is a language your executer is going to understand.