frederic.castelain

If you want to use multiple AI : use a Barcode4J type barcode, and put either a ñ OR a <GS> character (ASCII: 29 / 0x1D) before your 2nd, 3rd, etc., Application Identifier.

Define a parameter p_split_param which is of type java.lang.String[], and 'isForPrompting="false" ' In this p_split_param parameter, put either an empty array (new String[0]) if your real input parameter is empty, $P{your_input_param}.split(",") otherwise: "".equals($P{P_REAL_INPUT_PARAM}) ? new String[0] : $P{P_REAL_INPUT_PARAM}.split(",") In a dummy P_WHERE_CLAUSE parameter (= isForPrompting="false" ), put: $P{p_split_param}.length == 0 ? " " : " WHERE $X{IN, table_id_column, p_split_param} In your queryString put: select ... from ... $P!{P_WHERE_CLAUSE}

You can create a log4j.properties file like this one: #############################################log4j.appender.fileout=org.apache.log4j.RollingFileAppenderlog4j.appender.fileout.File=C:/tmp/jasperstudio.loglog4j.appender.fileout.MaxFileSize=16000KBlog4j.appender.fileout.MaxBackupIndex=2log4j.appender.fileout.layout=org.apache.log4j.PatternLayoutlog4j.appender.fileout.layout.conversionPattern=%d{ABSOLUTE} %5p %c{1},%t:%L - %m%nlog4j.rootLogger=WARN, fileoutlog4j.logger.net.sf.jasperreports.engine.query=FINElog4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.level=FINE############################################# Reference this file in your Jaspersoft Studio[ Professionnal].ini file (which is located in the same directory as jasper studio' exe): -Dlog4j.configuration=file:/c:/path%to%log4j.properties%file/log4j.properties Then restart Jaspersoft Studio.