Webby

Hi, I am trying to solve exactly the same problem. How did you fix it in the end? Much appreciated. Thanks

I have downloaded version 1.2.5 of jasper reports and put this into my ireport lib folder. I have also set the compatibility back to version 1.2.5 on iReport. Unfortunately this has not fixed the 'Print Repeated Values' bug. How many versions do I have to go back or what else do I need to do in order get this working. Any help is much appreciated as I have a boss who wants reports very soon!! ;)

Yes, I am using version 1.2.6 of Jasper Reports. It's a pity because I had just downloaded the latest version source and compiled it using ANT in order to fix the SQL alias problem we were having. :lol: Never mind at least it won't take me that long this time. Newbie Java users! What are they like? ;)

I'm having a similar problem and do not have anything in my printWhenExpression field. My report uses two groups and the FIELD that I'm having problems with is in the detail band. Here is my jrxml file if it helps. Code: <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="ac_diary_aircraft_totals" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="539" columnSpacing="0" leftMargin="28" rightMargin="28" topMargin="28" bottomMargin="28" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false" whenResourceMissingType="Error"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <import value="java.text.*" /> <parameter name="SQLWHERE" isForPrompting="true" class="java.lang.String"/> <queryString><![CDATA[$P!{SQLWHERE}]]></queryString> <field name="INTDIARYID" class="java.lang.Integer"/> <field name="INTAIRCRAFTID" class="java.lang.Integer"/> <field name="INTBASEID" class="java.lang.Integer"/> <field name="INTOWNERBASEID" class="java.lang.Integer"/> <field name="DATFROM" class="java.sql.Timestamp"/> <field name="DATTO" class="java.sql.Timestamp"/> <field name="STRFMV" class="java.lang.String"/> <field name="STRINSURED" class="java.lang.String"/> <field name="STRINSURER" class="java.lang.String"/> <field name="STRFLEETNAME" class="java.lang.String"/> <field name="STRBASENAME" class="java.lang.String"/> <field name="STRBASENAME_OWNER" class="java.lang.String"/> <field name="STRCOUNTRY" class="java.lang.String"/> <field name="STRCOUNTRY_OWNER" class="java.lang.String"/> <field name="STRFLEETCODE" class="java.lang.String"/> <field name="STRREGISTRATION" class="java.lang.String"/> <field name="DATFROMTIME" class="java.sql.Time"/> <field name="DATTOTIME" class="java.sql.Time"/> <field name="STRUNIT" class="java.lang.String"/> <field name="STRUNIT_OWNER" class="java.lang.String"/> <variable name="FLEETCOUNT" class="java.lang.Integer" resetType="Group" resetGroup="fleet_group" calculation="Nothing"> <variableExpression><![CDATA[new Integer($V{FLEETCOUNT}.intValue() + 1)]]></variableExpression> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression> </variable> <group name="base_group" > <groupExpression><![CDATA[$F{STRBASENAME}]]></groupExpression> <groupHeader> <band height="60" isSplitAllowed="true" > <rectangle> <reportElement x="0" y="40" width="539" height="20" forecolor="#4C4C4C" backcolor="#ECE9E2" key="header_background-1"/> <graphicElement stretchType="NoStretch" pen="2Point" fill="Solid" /> </rectangle> <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="2" y="41" width="341" height="18" key="base_group_header"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font size="12" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{STRBASENAME}]]></textFieldExpression> </textField> </band> </groupHeader> <groupFooter> <band height="0" isSplitAllowed="true" > </band> </groupFooter> </group> <group name="fleet_group" > <groupExpression><![CDATA[$F{STRFLEETCODE}]]></groupExpression> <groupHeader> <band height="30" isSplitAllowed="true" > <staticText> <reportElement x="15" y="8" width="80" height="18" key="fleet_code_header"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="12" isBold="true"/> </textElement> <text><![CDATA[Fleet Code]]></text> </staticText> <staticText> <reportElement x="133" y="6" width="80" height="18" key="base_fleet_total"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="12" isBold="true"/> </textElement> <text><![CDATA[Total]]></text> </staticText> </band> </groupHeader> <groupFooter> <band height="25" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="133" y="3" width="100" height="18" key="base_fleet_count"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{FLEETCOUNT}]]></textFieldExpression> </textField> </band> </groupFooter> </group> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="48" isSplitAllowed="true" > <rectangle> <reportElement x="0" y="0" width="539" height="48" forecolor="#4C4C4C" backcolor="#ECE9E2" key="header_background"/> <graphicElement stretchType="NoStretch" pen="2Point" fill="Solid" /> </rectangle> <image scaleImage="RetainShape" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="3" y="4" width="146" height="40" key="bristow_image" isPrintRepeatedValues="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <graphicElement stretchType="NoStretch" pen="None"/> <imageExpression class="java.lang.String"><![CDATA["http://intops.bristow.co.uk/intops_prod/images/bristow_lofi.gif"]]></imageExpression> </image> <staticText> <reportElement x="175" y="16" width="189" height="27" key="report_header"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement verticalAlignment="Bottom"> <font pdfFontName="Helvetica-Bold" size="18" isBold="true"/> </textElement> <text><![CDATA[Aircraft Totals Report]]></text> </staticText> </band> </title> <pageHeader> <band height="0" isSplitAllowed="false" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="20" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Column" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement mode="Transparent" x="13" y="1" width="84" height="18" key="fleet_code_detail" isPrintRepeatedValues="false"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{STRFLEETCODE}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="35" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="212" y="9" width="114" height="16" key="textField"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center"> <font/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="0" isSplitAllowed="true" > </band> </summary> </jasperReport> Post edited by: Webby, at: 2006/09/14 14:24

Hi, hopefully someone can help with this problem as I'm losing the will to live! ;) We have eventually managed to get reports working through Java Servlets and I have just started to build our first proper report. Part of the report requires me to test if a date is < 3 months from the supplied report parameter date and if it is then make the field blank. Also the expression needs to handle null dates. How on earth do I do this? I'm not to worried about calculating the difference on the fly as I could easily pass this into the report from my PHP page. I need the expression syntax for something like this:- (($FieldDate != null) AND ($FieldDate after $3MonthDate)) ? $FieldDate : "" We are not Java experts so please do not be offended if this is a stupid question. Is it possible to create a class that could manipulate/test dates and call this at runtime using the expression builder? Thank you in advance. :)

I am currently using iReport 1.2.4 and JasperReport 1.2.6. I use a JDBC driver to connect to an Interbase Database. When using iReport I have noticed that it doesn't allow Aliases to be used in SQL. eg. SELECT U.FIRSTNAME USERNAME FROM USER_TABLE U The alias 'NAME' fails with the error. Invalid column name : USERNAME. After reading many forums on the topic I have realized that if the JRResultSetDataSource Class is altered from metadata.getColumnName(i) to metadata.getColumnLabel(i) then this error can be avoided. Can anyone help by giving advise on where to alter this class as I cant find the file. I used the Windows Installer for iReport. Would I need to alter the Java source files before I compile the Java code? I'm not very experienced when it comes to Java so any help is appreciated. Thanks

I am currently using iReport 1.2.4 and JasperReport 1.2.6. I use a JDBC driver to connect to an Interbase Database. When using iReport I have noticed that it doesn't allow Aliases to be used in SQL. eg. SELECT U.FIRSTNAME USERNAME FROM USER_TABLE U The alias 'NAME' fails with the error. Invalid column name : USERNAME. After reading many forums on the topic I have realized that if the JRResultSetDataSource Class is altered from metadata.getColumnName(i) to metadata.getColumnLabel(i) then this error can be avoided. Can anyone help by giving advise on where to alter this class as I cant find the file. I used the Windows Installer for iReport. Would I need to alter the Java source files before I compile the Java code? I'm not very experienced when it comes to Java so any help is appreciated. Thanks

Tony, thank you for your quick response. What sort of timescale are we looking at regarding the updated version of the sample application? I really need to find a good reporting package and feel that Jasper fits the bill. Is there any other avenue that I could follow regarding php integration? We are about to purchase Zend Platform which has a java bridge. Excuse my ignorance but is it possible to directly call the jasper java api using this? Problem is I have absolutely no java experience whatsoever. I contacted someone at jaspersoft.com who said that they could offer tailored training. Would they just run into the same problems? Thanks

Can anyone explain to me how I go about calling reports using php and web services. I've found numerous articles telling me about this great capability but absolutely nothing about how to implement it!! Please, please, please I really need to find out how to do this. Cheers

Luca, thanks for your response. Do you have an example of how to implement this? I downloaded the 0.92 zip file that says it has a php example but can't find the example anywhere. Cheers

Hi, I have just downloaded and installed Jasper Intelligence version 1.0.1 and have now hit a brick wall as to how I integrate reports with our php application. I am essentially evaluating Jasper Reports as we were not entirely happy with BIRT as a reporting tool. None of our development team have any Java experience and are a little lost. Can anyone point me in the right direction? I'm looking for examples or documentation regarding PHP integration. I have trawled the net with no success and all I can find on http://www.jaspersoft.com/ is a snippet saying that it's possible to integrate with PHP. Thanks in advance Ps. I can provide more information on setup if required