ernst_2

You can use the "Column Header" and a "Group Footer".

It looks all completely fine, I think your browser displays the content not correct.

try: ($F{lastcost} >= ($F{sellprice} /1.40) ? "Low Sell" : ($F{lastcost} >= ($F{sellprice} / 1.80) && ($F{lastcost} < 25) ? "Low Sell" : "OK"))

try $F{FilmName}.equals("Jurassic Park") Edit: Sorry, I didn’t notice that you find the solution yourself And != works, because the object references are not the same

Is the "compatibility mode" deactivated? Press F12 and change the "Browser Mode".

You have to use the Java-Functions like: $P{JASPER_REPORTS_CONTEXT} != null ? $P{JASPER_REPORTS_CONTEXT}.getProperties() : ""

Hi jonathan_20, maybe it helps to set the JDK-Home-Path in the iReport-Config "<path>iReport-5.6.0etcireport.conf"-File, like jdkhome="C:Program Files (x86)Javajdk1.7.0_75". And don't use a jdk above 1.7.

Rename your my.txt to my.csv and insert content like: <columnName0>, <columnName1> <value01>, <value11> <value02>, <value12> <value03>, <value13> And use "CSV File" as data adapter. If you need the file on the server, follow this description (not tested): http://community.jaspersoft.com/questions/802580/how-create-excel-data-source-jasperreports-server

I think it an SSL problem, with SSL i get "There is a problem with selected Datasource which is not valid", without SSL it's working. (version 6.1.0) And thats not the only problem with a SSL-Connection.

You need to use the provided $X{} functions for such inputs. Like: $X{IN, <column_name>, <parameter_name>} Description: http://jasperreports.sourceforge.net/sample.reference/query/

$V{total_pay}.add($F{basic_salary}) ...

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".

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]

Hi, my subreport connects successfully to a different database, by the description of ntatlock. Like: <subreport> <reportElement mode="Opaque" x="555" y="0" width="5" height="20"/> <subreportParameter name="P_B"> <subreportParameterExpression><![CDATA[$F{username}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[java.sql.DriverManager.getConnection($P{P_SUB_DATASOURCE}.getConnectionUrl(),$P{P_SUB_DATASOURCE}.getUsername(),$P{P_SUB_DATASOURCE}.getPassword())]]></connectionExpression> <returnValue subreportVariable="V_M" toVariable="V_M"/> <subreportExpression><![CDATA["repo:0001_Subreport.jrxml"]]></subreportExpression></subreport>[/code]But the connection is not closing. So what can I do, to close the connection?

Maybe "equals" will help you. Like: $F{dataAsOfDate}.equals($V{maxDate})