2006 IR Open Dicussion

By: Giulio Toffoli - gt78 [ANN] iReport 1.2.4 released! 2006-06-26 00:43 iReport Release 1.2.4 June 23, 2006 The following changes have been made to software since release 1.2.3 * Full support for JasperReports 1.2.4 * New calculation type Distinct Count * Advanced support for MDX (Mondrian) * Improved support for EJBQL and HQL * Support for time zones * Several bug fixes See details on iReport 1.2.3 What's new? page! (http://ireport.sourceforge.net/index.php?p_module=page&pageid=35) iReport home page: http://ireport.sf.net Download it now: http://sourceforge.net/project/showfiles.php?group_id=64348 Giulio

By: Speed - jftan3 field with database problem 2006-06-20 22:52 after i run through the wizard to create a new document for a new report. it was successful but after that i need extra table to combine with my report to just ad up a field. can u guys help me out??? is it using subdata set? By: TBG - thebiggunner RE: field with database problem 2006-06-21 04:07 O, i see...you dont't use query, you use wizard. Do not use any wizards, create your report with "hand".:) By: TBG - thebiggunner RE: field with database problem 2006-06-22 23:22 Yeha. As i know, you cannot use two different queries in your report. You have to use subreport.:( By: TBG - thebiggunner RE: field with database problem 2006-06-21 04:05 Hi. Did you try LEFT JOIN or NATURAL JOIN in your query? By: Speed - jftan3 RE: field with database problem 2006-06-22 08:40 ya... i also tried before using query with no wizard used.. does u meant that after i submit query for choosing the table, i cannot add anymore table that i want? for jus a field only in different table. By: Speed - jftan3 RE: field with database problem 2006-06-23 03:38 oh... nope... din try out yet...

By: Tony - tt_linux iReport 1.2.3 cannot startup 2006-06-07 22:10 hi, I downloaded iReport 1.2.3 and it cannot startup. I could startup 1.2.1 and 1.2.2 with no problems after doing a chmod +x for the iReport.sh and startup.sh (for 1.2.1 and 1.2.2). I did the same for 1.2.3 but it did not work ? Did anyone have the same problem. I am running on linux. regards tony By: Tony - tt_linux RE: iReport 1.2.3 cannot startup 2006-06-07 22:37 hi, Found the problem. There was corruption in the iReport.sh and startup.sh script. Copied from 1.2.2 and it worked. By: Taryn - tarynocs RE: iReport 1.2.3 cannot startup 2006-06-22 15:54 I extracted iReport-1.2.3-windows-installer.exe to C:Program FilesJasperSoftiReport-1.2.3 When I try to run it it gets stuck with that little windows saying "Loading available font family names" How do I get it to finish loading. By: Taryn - tarynocs RE: iReport 1.2.3 cannot startup 2006-06-22 16:10 More info on my iReports not starting Exception in thread "main" java.lang.NullPointerException at com.digitprop.tonic.SplitPaneDivider.oneTouchExpandableChanged(SplitP aneDivider.java:70) at javax.swing.plaf.basic.BasicSplitPaneDivider.setBasicSplitPaneUI(Unkn own Source) at javax.swing.plaf.basic.BasicSplitPaneDivider.<init>(Unknown Source) at com.digitprop.tonic.SplitPaneDivider.<init>(SplitPaneDivider.java:56) at com.digitprop.tonic.SplitPaneUI.createDefaultDivider(SplitPaneUI.java :57) at javax.swing.plaf.basic.BasicSplitPaneUI.installDefaults(Unknown Sourc e) at javax.swing.plaf.basic.BasicSplitPaneUI.installUI(Unknown Source) at com.digitprop.tonic.SplitPaneUI.installUI(SplitPaneUI.java:64) at javax.swing.JComponent.setUI(Unknown Source) at javax.swing.JSplitPane.setUI(Unknown Source) at javax.swing.JSplitPane.updateUI(Unknown Source) at it.businesslogic.ireport.gui.docking.DockingContainer.recreateAll(Doc kingContainer.java:517) at it.businesslogic.ireport.gui.docking.DockingContainer.insertPanel(Doc kingContainer.java:247) at it.businesslogic.ireport.gui.docking.DockingContainer.insertPanel(Doc kingContainer.java:256) at it.businesslogic.ireport.gui.docking.DockingContainer.addPanel(Dockin gContainer.java:124) at it.businesslogic.ireport.gui.MainFrame.<init>(MainFrame.java:552) at it.businesslogic.ireport.gui.MainFrame.main(MainFrame.java:7056)

By: Dennis M - dennis2681 Summation total in group header 2006-06-22 06:39 Is this possible? When I try to put a variable in a group header that is a summation over a group I get unexpected results -- however if I put it in the group footer it works fine. am I doing something wrong or is this not implemented yet? thanks! also - there seems to be an error in 1.2.3 when trying to create a summation variable. i keep getting class not found errors even though the same report works fine in 1.2.2 By: Marcelo Fernandes - mcf-rocha RE: Summation total in group header 2006-06-22 07:03 Dennis, Check the "Evaluation Group" or "Evaluation Time" properties of your field. Good luck, Marcelo Carvalho Fernandes. By: Dennis M - dennis2681 RE: Summation total in group header 2006-06-22 07:40 worked like a charm, thanks!

By: BenDurand - bendurand percentage in crosstab and in charts 2006-06-22 02:04 Hi, In the detail of the crosstab, I want to have the percentage of subtotal. In a pie charts, I would like the percentage of the parts. I tried but there is a problem : For example if there are 2 parts 25% and 75%. The report shows 25% and 100%. Can you give me hints please ? Kind regards Ben By: BenDurand - bendurand RE: percentage in crosstab and in charts 2006-06-22 07:00 I must use IReport 1.2.0 or older. :(

By: fabian_steels - fabian_steels Scatter chart problem 2006-06-22 06:20 i have a problem with a scatter chart: i have a query who returns 3 columns: c1(float), c2(float) and c3(string) this query is right (already tested) and return more than 1000 records but when i make a serie with as value c1 and c2, only 30 points are displayed.... what's the problem??? is there a limit of records treated by jfreechart? nb: max records is disabled thanks for your answer Fabian Steels from cetic

By: mamazia - alzia ClassCastException on a field 2006-06-22 01:34 I tried to pass a date value from master report to subreport. However, I keep on getting the classCastException on a the date field. The exception is as follows: Compiling to file... .Stage2Master.jasper -> C:Program FilesJasperSoftiReport-1.2.3Stage2Master.java it.businesslogic.ireport.ReportClassLoader@1793040 Compilation running time : 360 Filling report... Locale: English (United States) Error filling print... java.lang.ClassCastException at TreatedWaterRecord_1150860566250_54847.evaluate(TreatedWaterRecord_1150860566250_54847:297) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:172) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:556) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:524) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:952) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:337) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:324) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:351) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:222) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:479) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:137) at java.lang.Thread.run(Unknown Source) NESTED BY : java.lang.ClassCastException at TreatedWaterRecord_1150860566250_54847.evaluate(TreatedWaterRecord_1150860566250_54847:297) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:172) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:556) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:524) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:952) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:337) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:324) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:351) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:222) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:479) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:137) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{date} at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:183) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:556) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:524) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:952) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:337) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:324) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:351) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:222) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:479) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:137) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassCastException at TreatedWaterRecord_1150860566250_54847.evaluate(TreatedWaterRecord_1150860566250_54847:297) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:172) ... 17 more NESTED BY : java.lang.ClassCastException at TreatedWaterRecord_1150860566250_54847.evaluate(TreatedWaterRecord_1150860566250_54847:297) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:172) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:556) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:524) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:952) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:337) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:324) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:351) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:222) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:479) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:137) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{date} at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:183) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:556) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:524) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:952) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:337) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:324) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:351) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:222) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:479) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:137) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassCastException at TreatedWaterRecord_1150860566250_54847.evaluate(TreatedWaterRecord_1150860566250_54847:297) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:172) ... 17 more NESTED BY : net.sf.jasperreports.engine.JRRuntimeException: Error evaluating expression : Source text : $F{date} at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:568) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:343) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:311) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:275) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1291) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:631) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:228) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:701) at java.lang.Thread.run(Unknown Source) Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{date} at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:183) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:556) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:524) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:952) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:337) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:324) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:351) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:222) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:479) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:137) ... 1 more Caused by: java.lang.ClassCastException at TreatedWaterRecord_1150860566250_54847.evaluate(TreatedWaterRecord_1150860566250_54847:297) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:172) ... 17 more could somebody help me.. By: mamazia - alzia RE: ClassCastException on a field 2006-06-22 01:38 The report template is as follows: <?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="Stage2Master" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="1190" pageHeight="842" columnWidth="1130" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <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.*" /> <parameter name="SUBREPORT_DIR" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["D:\PhD\wtp\TreatedWaterRecord.jasper"]]></defaultValueExpression> </parameter> <parameter name="DATE" isForPrompting="true" class="java.lang.String"/> <queryString><![CDATA[sELECT distinct date FROM F40array GROUP BY date ORDER BY date]]></queryString> <field name="date" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="55" isSplitAllowed="true" > <staticText> <reportElement x="1" y="2" width="534" height="47" key="staticText-3"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica-Bold" size="14" isBold="true"/> </textElement> <text><![CDATA[sTRATEGI TEGAS TREATED WATER PUMPING RECORD(SG.JOHOR) ISSUE NO.3 DOCUMENT REF.:F/40 ]]></text> </staticText> </band> </title> <pageHeader> <band height="10" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="13" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="72" isSplitAllowed="true" > <staticText> <reportElement x="0" y="10" width="81" height="20" key="staticText-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> <font fontName="Arial" pdfFontName="Helvetica-Bold" size="12" isBold="true"/> </textElement> <text><![CDATA[DATE:]]></text> </staticText> <textField isStretchWithOverflow="false" pattern="yyyy-MM-dd" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="90" y="12" width="60" height="20" key="textField"/> <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{date}]]></textFieldExpression> </textField> <subreport isUsingCache="true"> <reportElement x="0" y="42" width="360" height="30" key="subreport"/> <subreportParameter name="DATE"> <subreportParameterExpression><![CDATA[$F{date}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR}]]></subreportExpression> </subreport> </band> </detail> <columnFooter> <band height="30" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="50" isSplitAllowed="true" > </band> </pageFooter> <lastPageFooter> <band height="50" isSplitAllowed="true" > </band> </lastPageFooter> <summary> <band height="50" isSplitAllowed="true" > </band> </summary> </jasperReport>

By: luiaard - vta_123 Javabean DataSource example 2006-06-22 02:17 Hi, I have implemented the xml datasource sucessfully by following the steps in the IReport manual version 1.2. When implementing the Javabean example from the manual exactly as explained it fails to fill the fields with the correct data. The following error message is displayed in IReport 1.2.3 when executing the report with the active connection : Error filling print... java.lang.NoSuchMethodException: Unknown property ... ... Do I have to implement JRDataSource interface? And if so is there some example available? Thank you By: luiaard - vta_123 RE: Javabean DataSource example 2006-06-22 04:06 Ignore the previous post.If only I implemented the example exactly as I should ... "getter" method must start with capital and member variable must be small caps. It works fine now.Nothing wrong with the manual.

By: sandro - sandrobe Remote custom template 2006-06-22 03:23 It's possible using a custom template, saved on a remote server, without having to copy them in the "templates" subdirectory of iReport? Thanks

By: sandro - sandrobe Element on the bottom of the title band 2006-06-22 03:17 I would want to print an element on the bottom of the title band without having to increase (in phase of design) the band to the dimension of the page. How I can make? Thanks

By: Manfred Cerny - zephyrfredi Displaying Html code 2006-06-22 01:34 Hi all, I have a Problem using iReport and JR. I need to display html code in a text field object. The html content will be received through a Field. I've tried it already with the "Is styled text" attribute but this doesn't work. I would be very happy if anyone knows a solution. Thanks Fredi

By: ben - bension Hibernate Datasource 2006-06-22 01:00 Hi there, I am attempting to set up a hibernate data source in iReport. Note that I am using annotations. I have added the appropriate jar files to the lib dir of iReport (ejb3-persistance.jar, hibernate-annotations.jar, + my application's jar files), but when I attempt to test the connection I get the following error: An AnnoationConfiguration instance is required to use <mapping class="x.x.x.x.MyClass"/> Anyone have an idea how to set up a hibernate datasource in iReport where the hibernate configuration uses annotations? Setup info: OS: Windows XP JVM: 1.5 iReport: 1.2.2 hibernate: 3.2.0rc2 hibernate-annotations: 3.2.0rc1 DB: HyperSonic 1.8 thanks in advance, Ben

By: Leo Geoffrion - ldgpangeo Unable to start iReport on Linux 2006-05-15 11:28 This may be a dumb newbie question, but... When I try to launch iReport using the iReport.sh script, it immediately dies with an error message of "Cannot find lib in iReport home directory (null)" I've even tried setting it using the -ireport-home= flag but get the same error. The same code works fine on Windows and MacOSX. My Linux environment is Fedora Core 4. By: Chris Collins - crusty_collins RE: Unable to start iReport on Linux 2006-05-15 13:18 I get the same error but the app loads. Cannot find lib in iReport home directory (null) try and add -x to the bin/startup.sh and see if the script knows what EXEDIR is . By: golablues - golablues RE: Unable to start iReport on Linux 2006-05-16 10:56 I am having the problem, just installed on Fedora COre 5 with JDK 1.5..where do I add the -x? when running the script? By: Richard Thorne - atoren RE: Unable to start iReport on Linux 2006-05-18 22:33 Here is a hint that worked for me. If you are using the iReport.sh you need to chmod -R -x bin from the installation otherwise the iReport.sh doesn't can not execute the scripts inside the bin folder. Richard By: matias - el_itur RE: Unable to start iReport on Linux 2006-06-12 15:46 I'm getting the same message on kubuntu jdk 1.4.2 and I already check those files as executable... I presume there is another way, some classpath that's not defined or something but just can't get it work. if somebody has an idea it will be welcome since I need to get iReports working quickly or I had lost a job. Thanks By: Tony - tt_linux RE: Unable to start iReport on Linux 2006-06-12 23:54 hi, check my post last week. may help you. i have a feeling the startup.sh and ireport.sh files were not transferred properly for linux use. The <cr<lf> ... maybe i took a older addition (1.2.2 or 1.2.1) and it worked after that. Obviously, do a chmod to make it executable. Hope it helps. By: matias - el_itur RE: Unable to start iReport on Linux 2006-06-20 16:19 no, I' Already done that and I still get that message By: matias - el_itur RE: Unable to start iReport on Linux 2006-06-21 15:34 in fact I'm runnig ireport 1.2.2

By: Javy Dreamer - javydreamercsw Open Report with viewer by default 2006-06-15 12:47 I've been able to make Windows open *.jrxml files with iReport by default but it opens as a developer. Is there a way to open with a viewer by default from Windows so it opens and prompts for parameters, etc? Thanks in advance. By: Remo Fritzsche - remofritzsche RE: Open Report with viewer by default 2006-06-21 05:06 the .jrxml isn't a compiled file. i'm not sure if you want to open the .jasper file directly? in this case I think you'll have to start the report througt java (possible with a batch file). remo

By: venz98 - venz Datasource problem 2006-06-21 04:12 hi! I am using stored procedures in my query...the title of my report is one stored procedure and the detail is another stored procedures. I think this is not possible...is their other way? tnx -venz

By: Remo Fritzsche - remofritzsche Can't move fields! 2006-06-21 01:01 Hi there, I work with iReport V 1.2.0 (1.2.3 won't work on my machine). It worked all fine, but suddenly I can't move any type of field througt the Mouse. With the Keyboard or coordinates it's still possible. Now all other (older) iReport Versions will do it the same way...I hope somebody can help me. Thank's a lot Remo By: Remo Fritzsche - remofritzsche RE: Can't move fields! 2006-06-21 02:39 okay, sorry for the stupid post! I found it in the menu...! Thank's a lot Remo

By: tolga gucuk - e111982 4-Pages report 2006-06-16 00:57 Hi. I have a form. It has 4 pages. All the pages are simply report. However I have to combine them in one report. How can i do that? Thanks. By: missioncoder - missioncoder RE: 4-Pages report 2006-06-16 08:01 I had a similar issue and I used the samples which can in the JasperReports demo, i.e. PrintService and PrintManager. I think you will be happy with the results. -MissionCoder By: tolga gucuk - e111982 RE: 4-Pages report 2006-06-19 01:15 thanks. Where can I find the demos? And I use ireport. By: missioncoder - missioncoder RE: 4-Pages report 2006-06-20 12:58 The demos are part of the JaperReport download, http://sourceforge.net/project/showfiles.php?group_id=36382&package_id=28579 . This .jar file contains ALL the samples you need for most development efforts. At the very least it will get you started. Let me know if you need any help installing it on Tomcat, I am currently using JR on Tomcat 5.27. ~Enjoy

By: rwdenney5 - rwdenney5 Bar Chart: Rotating the Category Expression 2006-06-14 14:21 I've created a simple 3D bar chart but the category labels are being truncated because they are too long. Some of JFreeChart's demos show the category lables rotated at a 45 degree angle... any idea how to do that in iReport? Thanks, Ryan By: Marcelo Fernandes - mcf-rocha RE: Bar Chart: Rotating the Category Expressi 2006-06-15 13:06 Ryan, I think it's impossible nowadays with iReport. Although it's possible to be done using the JFreeChart in your application, there isn't such option in iReport's GUI. You will have to create your JFreeChart outside iReport and pass it as a parameter for JasperReport to be displayed as an image. Finally, about rotating the labels, try this on JasperReports: final JFreeChart chart = ChartFactory.createBarChart3D( "blablabla", // chart title "domain", // domain axis label "range", // range axis label dataset, // data PlotOrientation.HORIZONTAL, // orientation true, // include legend true, // tooltips false // urls ); final CategoryPlot plot = chart.getCategoryPlot(); final CategoryAxis axis = plot.getDomainAxis(); axis.setCategoryLabelPositions( CategoryLabelPositions.createUpRotationLabelPositions(2*Math.PI) ); I've been trying to find a way to fix the range axis of a a simple 3D bar chart in iReport but it's only possible in the same way. Marcelo Carvalho Fernandes By: rwdenney5 - rwdenney5 RE: Bar Chart: Rotating the Category Expression 2006-06-19 11:33 Thanks Marcelo. I kind of figured as much. I'm wondering though if I could use a customizer class to extend the functionality of iReport's charting. I'm assuming that the customizer class would allow access to the entire jfreechart api, but I've not been able to implement it. I'm not sure of the classpath. Anyone have any ideas? Thanks, Ryan By: Marcelo Fernandes - mcf-rocha RE: Bar Chart: Rotating the Category Expressi 2006-06-19 11:39 You're welcome Ryan, I have no idea about using the Customizer Class. Can you send to me the source-code of your class so that I can make some tests? Marcelo By: rwdenney5 - rwdenney5 RE: Bar Chart: Rotating the Category Expression 2006-06-19 13:52 I was actually just trying to test one of the samples included in the jasperreports download... jasperreports-1.2.2demosampleschartsBarChartCustomizer.java If I can figure out how to get my chart to compile using the customizer class then I should be all set because I think I'll be able to customize the charts using the jfreechart api. Thanks, Ryan

By: TBG - thebiggunner Problem with special characters 2006-06-19 00:40 Hi. I use special, hungarian characters, like 'ő', 'ű' and everything is working well till i print. Every string that contains one of this characters will be bold...but only on the printed page. The jasperviewer shows them correctly..:) Any ideaa? I use Suse 10.1 and a simple HP printer with ghostscript..

By: wgyr - wgyr jasper to jrxml conversion 2006-06-13 10:41 is there any way i can convert *.jasper file to *.jrxml file By: TBG - thebiggunner RE: jasper to jrxml conversion 2006-06-13 22:46 Hi. You should load the jasper file into the designer and you'll get the jrxml.:) By: wgyr - wgyr RE: jasper to jrxml conversion 2006-06-16 10:14 can u give more detailed information regarding how to load the jasper file to designer.If u r telling to open the jasper file in ireport designer then it is not opening correctly.A blank report is comming By: Martyn - martyn-hi-ss-nl RE: jasper to jrxml conversion 2006-06-17 05:30 I'm not usre but I think this is impossible. The jasper file is a compiled java class. Unless iReport can reverse engineer the file it's impossible but I could be wrong. By: TBG - thebiggunner RE: jasper to jrxml conversion 2006-06-19 00:34 Hmm...i use iReport 1.2.1. I created a jrxml file, compiled it and deleted the jrxml. Loaded into the designer and the report is on the screen.

By: Cameron Taggart - ctaggart Classpath problems w/ a JRDataSourceProvider 2006-06-15 23:20 I'm having difficulties with a custom JRDataSourceProvider. I put my library containing the JRDataSourceProvider and its dependencies in the ./lib directory. One of the dependencies is Spring. Spring is in the ./lib folder, but I keep getting errors like: java.lang.IllegalArgumentException: interface org.springframework.aop.framework.Advised is not visible from class loader at java.lang.reflect.Proxy.getProxyClass(Unknown Source) at java.lang.reflect.Proxy.newProxyInstance(Unknown Source) at org.springframework.aop.framework.JdkDynamicAopProxy.getProxy(JdkDynamicAopProxy.java:104) at org.springframework.aop.framework.JdkDynamicAopProxy.getProxy(JdkDynamicAopProxy.java:94) at org.springframework.aop.framework.ProxyFactory.getProxy(ProxyFactory.java:72) at org.springframework.aop.framework.ProxyFactory.getProxy(ProxyFactory.java:101) at org.springframework.remoting.caucho.HessianProxyFactoryBean.afterPropertiesSet(HessianProxyFactoryBean.java:52) at I can't help but think it has something to do with: Object obj = Class.forName((String)jTextFieldJRDataSourceProvider.getText().trim(), true, MainFrame.getMainInstance().getReportClassLoader()).newInstance(); Any idea what I'm doing wrong? What does ReportClassLoader do? Will it not load the Spring jar? Cameron By: Martyn - martyn-hi-ss-nl RE: Classpath problems w/ a JRDataSourceProvi 2006-06-17 05:35 Have you added both jar files to the class path in iReport? Dont forget about the bug where your classpath is deleted when you reload iReport. It's possible your classpath is empty. By: Cameron Taggart - ctaggart RE: Classpath problems w/ a JRDataSourceProvi 2006-06-17 11:07 I placed all necessary jars in the "lib" directory to add them to the classpath. Is anything else needed? I haven't heard about that bug yet. Simple editing the source code and changing it to get "this"'s ClassLoader works. I also changed the remote communication protocol from Hessian to Spring Framework's HttpInvoker, which gives a lot clearer error messages.

By: soolch - soolch Page Total In CrossTab 2006-06-14 00:29 Can anyone give me some hints on how to make the page total in crosstab. I found that it has only the grand total on the last page of the crosstab. Thanks By: sun - sunilkumaar RE: Page Total In CrossTab 2006-06-16 02:10 In variable add variable and sum the page count

By: AA2 - aa2 Error: whenResourceMissingType? 2006-06-15 21:23 I had made 5 reports with IReport and everything was good with the 4 reports but when I wanted to run the last one, there was a error: whenResourceMissingType? I didn't know how it could happen, Can Anyone tell me what it means and how to solve the problem? thanx.

By: Zoneblade - zoneblade Sorting data from Zirius 2006-06-15 02:47 I'm new with ireport, and i'm trying to get data from a program called Zirius. Now, what i'm trying to do, is get the info from this post called "printed orders"(in norwegian, that is "utskrevne faktura"). But, i only want some of the orders to appear in ireport, how do i eliminate the ones i don't want to show? Or said in another way: How do i get only the ones that i want, without all the other "orderId's" appearing in ireport? By: Zoneblade - zoneblade RE: Sorting data from Zirius 2006-06-15 05:49 Guess i'll have to wait then(My coding skills are B A D...). But thanks for clearifying that for me... I was about to go crazy from not finding out how to do that... By: Giulio Toffoli - gt78 RE: Sorting data from Zirius 2006-06-15 05:27 You can write your own JRDataSource, or wait for the next version of JR, when a filterExpression will be available to filter data without using a filtered query. Giulio By: C-Box - c-box RE: Sorting data from Zirius 2006-06-15 08:15 what a great news!!!!!!!!! I'm really looking forward to this feature! thx a lot C-Box

By: mloudon - mloudon Hibernate+Wizard:Cannot Open Connection 2006-05-04 01:42 I'm trying to use the Report Wizard in iReport 1.2.2 . I can add a hibernate data source, and when I press 'test' the test is successful. However when I enter a query I get the message 'General Problem:Cannot Open Connection' If anyone can help, I'd really appreciate it. Melissa By: mloudon - mloudon RE:FIXED Cannot Open Connection 2006-05-05 06:07 Fixed it - the problem was that the relevant jdbc driver (postgresql, in my case) needed to be copied into the lib/ directory of iReport By: abioye - abioye RE: Hibernate+Wizard:Cannot Open Connection 2006-05-18 08:02 i am getting the same error but i am using sqlserver and i have copied the 3 jar files: mssqlserver, msbase and msutil to the lib directory. however, the error persists! Please, any help, anyone? i need to sort this out quickly. By: Andrea Gioia - drjey RE: Hibernate+Wizard:Cannot Open Connection 2006-06-13 03:36 I faced the same problem just today. I noticed that ireport is unable to build the hibernate connection just when it is started up from the exe file. Try to start it up from the bat file and the problem should be fixed. Probably this is juat a bug of ireport exe file but i'm not sure about that. Obviusly you have to check that your class path is properly configured before doing this try. Bye By: Giulio Toffoli - gt78 RE: Hibernate+Wizard:Cannot Open Connection 2006-06-15 05:25 It's a limitation of the wrapper that is not able to fill dynamically the static classpath Using iReport.bat should fix the problem. Giulio