bbenson193

Hello- I received many different errors when using js-export to export the repository data before upgrading to 3.7. After looking at some of the output file folders I realized that there were an excessive amount of output files being saved. After clearing the output files I was able to export succesfully. Hopefully this can save someone else some time. Thanks Brett Post Edited by bbenson193 at 04/29/2010 14:09

Thank you both for the replies, the stretch with overflow took care of it!! Thanks again.

Hello- I am working with a report that has two fields which are retrieved from a mysql databaseTicketNumber(Integer), Information(Text). When I run the query from within ireport all of the data is retreived correctly. When I run the report only the TicketNumber field shows on the the report. I checked and the data type was mapped to java.lang.String. Both fields are in the detail band with a text boxes that have their Text Field Expression set to $F{Field}. Any direction would be greatly appreciated. Thanks Brett Code:<?xml version="1.0" encoding="UTF-8"?><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="TicketReminder.jrxml" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <queryString> <![CDATA[sELECT TicketNumber,Information FROM helpdesk where TicketNumber IN(select TicketNumber from vwdailyupdatereminder where LastUpdateTime <= CURDATE());]]> </queryString> <field name="TicketNumber" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="Information" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <background> <band/> </background> <title> <band height="58"> <line> <reportElement x="0" y="8" width="555" height="1"/> </line> <line> <reportElement positionType="FixRelativeToBottom" x="0" y="51" width="555" height="1"/> </line> <staticText> <reportElement x="65" y="13" width="424" height="35"/> <textElement textAlignment="Center"> <font size="26" isBold="true"/> </textElement> <text><![CDATA[Classic template]]></text> </staticText> </band> </title> <pageHeader> <band/> </pageHeader> <columnHeader> <band/> </columnHeader> <detail> <band height="262"> <staticText> <reportElement x="0" y="0" width="139" height="20"/> <textElement> <font size="12"/> </textElement> <text><![CDATA[TicketNumber]]></text> </staticText> <textField> <reportElement x="139" y="0" width="416" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{TicketNumber}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="20" width="139" height="20"/> <textElement> <font size="12"/> </textElement> <text><![CDATA[information]]></text> </staticText> <textField> <reportElement stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="139" y="20" width="253" height="126" isPrintWhenDetailOverflows="true"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{Information}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band/> </columnFooter> <pageFooter> <band height="149"> <textField evaluationTime="Report" pattern="" isBlankWhenNull="false"> <reportElement key="textField" x="516" y="6" width="36" height="19" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement> <font size="10"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="false"> <reportElement key="textField" x="342" y="6" width="170" height="19" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right"> <font size="10"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="false"> <reportElement key="textField" x="1" y="6" width="209" height="19" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement> <font size="10"/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band/> </summary></jasperReport>

Hello- I am trying to change the from email address that shows up on emailed reports(jasper@jaspersoft.com). I set the address that I would like to use in this file /opt/jasperserver-2.1/apache-tomcat/webapps/jasperserver/WEB-INF/js.mail.properties. Is there another place that I should set this address? Any help is greatly appreciated. Thanks, Brett Post edited by: bbenson193, at: 2008/03/12 14:23