Hugo Stiglitz

Changed Priority from Normal to High Changed Assigned User from @swood to - i also need assistance with this.

thanks Hozawa...how would i use the CompareTo() function in this instance?

thanks for the reply. i get results back when i run the same query with the used date parameters in my database. The report also returns results when i hard-code the dates in jasper instead of using the parameters.

Hi, Please help, im new to jasper. I get an empty report report when i'm using a start date and end date parameter in my jasper report on jasper studio 6.2.0. I'm using MySql as my data source. Please ​see the xml for my report below: <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0 --> <!-- 2016-08-08T16:03:44 --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Trial Balance" pageWidth="596" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ef5170bc-5e69-43f1-8386-7626bd309d29"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="ireport.jasperserver.url" value="http://172.30.6.39:8085/jasperserver/"/> <property name="ireport.jasperserver.user" value="jasperadmin|Qualica"/> <property name="ireport.jasperserver.reportUnit" value="/Dev/Trial_Balance"/> <property name="ireport.jasperserver.report.resource" value="/Dev/Trial_Balance_files/Main_Jrxml"/> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Trial Balance Dataset" uuid="d1847a38-92be-4b0b-86c0-de02c11f0d17"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="MySql Adapter"/> <parameter name="from_date" class="java.util.Date"/> <parameter name="to_date" class="java.util.Date"/> <queryString> <![CDATA[select pre_tb.resolved_chart_name as chart, if(pre_tb.debit > pre_tb.credit, (pre_tb.debit - pre_tb.credit)/100,0) as debit, if(pre_tb.credit > pre_tb.debit, (pre_tb.credit - pre_tb.debit)/100,0) as credit from ( select resolved_chart_name, sum(debit) as debit, sum(credit) as credit from ods.transaction_history where date(effective_date) >= date($P{from_date}) and date(effective_date) <= date($P{to_date}) group by resolved_chart_name ) as pre_tb;]]> </queryString> <field name="chart" class="java.lang.String"/> <field name="debit" class="java.math.BigDecimal"/> <field name="credit" class="java.math.BigDecimal"/> <variable name="TotatDebit" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{debit}]]></variableExpression> </variable> <variable name="TotalCredit" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{credit}]]></variableExpression> </variable> <group name="chart"> <groupExpression><![CDATA[$F{chart}]]></groupExpression> </group> </subDataset> <parameter name="from_date" class="java.util.Date"/> <parameter name="to_date" class="java.util.Date"/> <queryString> <![CDATA[select 1 = 1]]> </queryString> <field name="chart" class="java.lang.String"/> <field name="debit" class="java.math.BigDecimal"/> <field name="credit" class="java.math.BigDecimal"/> <group name="chart"> <groupExpression><![CDATA[$F{chart}]]></groupExpression> </group> <background> <band splitType="Stretch"/> </background> <title> <band height="60" splitType="Stretch"> <textField> <reportElement x="120" y="4" width="320" height="50" uuid="c88ac451-b99b-48d2-8dcf-44573b73ed8a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="22"/> </textElement> <textFieldExpression><![CDATA["Trial Balance"]]></textFieldExpression> </textField> <line> <reportElement x="120" y="54" width="320" height="1" uuid="d8606e80-809c-49ba-9032-36e82debb5ec"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> </line> </band> </title> <pageHeader> <band height="35" splitType="Stretch"> <textField pattern="yyyy-mm-dd"> <reportElement x="166" y="6" width="100" height="20" uuid="3ffd0ee4-096f-4f8e-a677-a008e96a976d"/> <textFieldExpression><![CDATA[$P{from_date}]]></textFieldExpression> </textField> <staticText> <reportElement x="266" y="6" width="28" height="20" uuid="3ad7e5fb-a23c-4100-822a-0e57dabab1be"/> <textElement textAlignment="Center"/> <text><![CDATA[to]]></text> </staticText> <textField pattern="yyyy-mm-dd"> <reportElement x="306" y="6" width="100" height="20" uuid="dc8e1963-7923-4b5a-98d0-4ff6fc8f6265"/> <textFieldExpression><![CDATA[$P{to_date}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="224" splitType="Stretch"> <componentElement> <reportElement x="100" y="12" width="380" height="200" uuid="4da507e1-8d29-438f-9311-baa9617d34de"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="Trial Balance Dataset" uuid="cbe1a310-d996-4c46-9735-39fcb56d8e23"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="220" uuid="bde48410-c25b-4e68-9b3a-3233a5ff15a9"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="220" height="30" uuid="e2ccf681-aef5-465e-abb2-16370aa4fd5a"/> <textElement> <font isBold="true"/> </textElement> <text><![CDATA[Chart]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="220" height="30" uuid="18bf5266-f4e2-4df7-b91f-989965ee70c3"/> <textFieldExpression><![CDATA[$F{chart}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="66" uuid="7c521742-532d-4f1e-8d5c-6a3d37745e06"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="66" height="30" uuid="49e5c361-dedc-4b76-8e8a-89516698fc7e"/> <textElement> <font isBold="true"/> </textElement> <text><![CDATA[Debit]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"> <textField pattern="#,##0.###"> <reportElement x="0" y="0" width="66" height="30" uuid="b9f8086c-21f4-4b33-af0e-0d0b7779470e"/> <textFieldExpression><![CDATA[$V{TotatDebit}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="Table_TD" height="30"> <textField pattern="#,##0.###"> <reportElement x="0" y="0" width="66" height="30" uuid="f16a09c3-fe6d-424e-8712-736d762496d8"/> <textFieldExpression><![CDATA[$F{debit}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="66" uuid="6f8f2669-cf6f-4262-a163-1a824e1f8539"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="66" height="30" uuid="3baa801b-6ed3-42a9-8be8-667d844433a0"/> <textElement> <font isBold="true"/> </textElement> <text><![CDATA[Credit]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"> <textField pattern="#,##0.###"> <reportElement x="0" y="0" width="66" height="30" uuid="da498a63-6aa9-4659-b4b0-1440f3416bbf"/> <textFieldExpression><![CDATA[$V{TotalCredit}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="Table_TD" height="30"> <textField pattern="#,##0.###"> <reportElement x="0" y="0" width="66" height="30" uuid="4a998d60-5286-4a68-bef6-02e8b3906d9c"/> <textFieldExpression><![CDATA[$F{credit}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </columnHeader> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> </jasperReport>

Yes, we are using different versions. Server A is on version 6.0.1 and Server B is on version 6.2.1. If this is indeed the problem, is there a way around it?

Sorry guys i'm new to Jasper. I imported a folder from Server A to Server B by exporting the folder from Server A and importing it into the other Server B using the Web Interface. When i try to expand the folder on Server B, i get the error: "Bad Request Error".

Hi, I get a "Bad Request Error" when i try to open a folder that i've just imported on Jaspersoft Studio 6.2.