ernst_2
-
Posts
31 -
Joined
-
Last visited
Community Answers
-
ernst_2's post in IF statements in a Variable on a report. was marked as the answer
try:
($F{lastcost} >= ($F{sellprice} /1.40) ? "Low Sell" : ($F{lastcost} >= ($F{sellprice} / 1.80) && ($F{lastcost} < 25) ? "Low Sell" : "OK"))
-
ernst_2's post in Date input control description not working was marked as the answer
Hi j.t.casperson,
you can find the description in this properties file:
"...jasperreports-server-cp-5.6.0apache-tomcatwebappsjasperserverWEB-INFbundlesjasperserver_messages.properties"
The attribute is called "DATE_IC_TOOLTIP".
-
ernst_2's post in Subreport - Close connection was marked as the answer
Found it!
<parameter name="P_SUB_DATASOURCE" class="com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.JdbcReportDataSource" isForPrompting="false"> <defaultValueExpression><![CDATA[com.jaspersoft.jasperserver.api.engine.jasperreports.util.RepositoryUtil.getThreadRepositoryContext().getRepository().getResource(null,"/<path to data source>/")]]></defaultValueExpression></parameter>[/code]<parameter name="P_SUB_CONNECTION" class="java.sql.Connection" isForPrompting="false"> <defaultValueExpression><![CDATA[java.sql.DriverManager.getConnection($P{P_SUB_DATASOURCE}.getConnectionUrl(),$P{P_SUB_DATASOURCE}.getUsername(),$P{P_SUB_DATASOURCE}.getPassword())]]></defaultValueExpression></parameter> [/code]<subreport> <reportElement mode="Opaque" x="555" y="0" width="5" height="20"/> <subreportParameter name="P_B"> <subreportParameterExpression><![CDATA[$F{user}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{P_SUB_CONNECTION}]]></connectionExpression> <returnValue subreportVariable="V_M" toVariable="V_M"/> <subreportExpression><![CDATA["repo:0001_Subreport.jrxml"]]></subreportExpression></subreport>[/code]<textField> <reportElement x="555" y="10" width="5" height="20"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[""; $P{P_SUB_CONNECTION}.close()]]></textFieldExpression></textField>[/code]
-
ernst_2's post in Substringing was marked as the answer
Hi lbendall,
you could use a TextField with some sourcecode to split the string, like this:
<textField> <reportElement x="26" y="8" width="100" height="20"/> <textFieldExpression><![CDATA[$F{name} != null && $F{name}.contains(":") && $F{name}.length() > 1 ? $F{name}.split(":")[0] : ""]]></textFieldExpression></textField>[/code]or with substring:
<textField> <reportElement x="26" y="8" width="100" height="20"/> <textFieldExpression><![CDATA[$F{name} != null && $F{name}.contains(":") && $F{name}.length() > 1 ? $F{name}.substring(0, $F{name}.indexOf(":")) : ""]]></textFieldExpression></textField>[/code]
