frederic.castelain
-
Posts
3 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by frederic.castelain
-
-
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.
Barcode4j EAN128 Template
in Products
Posted
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.