Jakub

Hi, I must remove imported package gnujaxp.jar

Hi, I compile my report in my code as JasperReport jasperReport = JasperCompileManager.compileReport(reportSource); and NetBeans show this message 2.11.2006 14:02:36 org.apache.commons.digester.Digester getParser SEVERE: Digester.getParser: org.xml.sax.SAXNotRecognizedException: http://apache.org/xml/features/validation/dynamic at gnu.xml.aelfred2.JAXPFactory.setFeature(JAXPFactory.java:102) at org.apache.commons.digester.parser.XercesParser.configureXerces(XercesParser.java:185) at org.apache.commons.digester.parser.XercesParser.newSAXParser(XercesParser.java:138) at org.apache.commons.digester.ParserFeatureSetterFactory.newSAXParser(ParserFeatureSetterFactory.java:71) at org.apache.commons.digester.Digester.getParser(Digester.java:692) at org.apache.commons.digester.Digester.getXMLReader(Digester.java:899) at org.apache.commons.digester.Digester.parse(Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:142) Where have I error, please? Thank

Hi, Properties - > Pattern :unsure:

Hi, I have in database table column with date type Double. In database table I have value 100.00 215.14 etc. This is ok, but if I load data to my report, value with two null (100.00) is trim to one null (100.0). I need value with two null. Please, help me. Thank you for your help me.

Hi, good resolution is JasperPrint pr= JasperFillManager.fillReport (jasperReport,params,conn); I have had BeanCollectionDataSource on place conn.

Hi, I create report in iReport. In this report I have 3 field 1 - $F{inventarni} 2 - $F{nazev} 3 - $F{cena} This name are equivalent as columns name in database table. In report I have a SQL question, which load data from database to my fields SELECT inventarni,nazev,cena from majetek In iReport is every ok, I load and see data in my report. If I parse my jrxml and java file to my project in NetBeans, add jasper library, and run my code, I see this error ///////////////////////////////////////////////////// java.lang.NoSuchMethodException: Unknown property 'inventarni' at org.apache.commons.beanutils.PropertyUtils.getSimpleProperty(PropertyUtils.java:1157) at org.apache.commons.beanutils.PropertyUtils.getNestedProperty(PropertyUtils.java:754) at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:783) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:104) at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:93) at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:788) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:752) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1019) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:685) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) ////////////////////////////////////////////////////////////////////////////////// I evoke, that "inventarni" is F{inventarni}expression text field. Thank you for help me.

Hi, today my report is load data from database, but I have only one problem. If my report include etc. 5 rows, this rows are through all report. In between are big white rows. How I load rows under himself? Thanks size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/report.jpg Post edited by: Jakub, at: 2006/08/09 16:41

Thank you for your help me, my friend me send function jrxml file, I rewrite this file for me and work it! I don`t know, where I have error. I generate report from iReport. Yet another how I load data from database and I am happiest man. :) Regards

Hi, I debug my application, and con include valid informations from my database. On example I do not load any data from database, I need visit title and summary text in text fields in report. Map<String, Object> params = new HashMap<String, Object>(); params.put("Nadpis","Text my title "); params.put("Soucet","Text my summary"); But report is empty. :( . Thanks

Hi, I rewrite my jrxml file, copy this file to my Netbeans project directory, .java file I copy to src directory in my project. Every ok, any errors or warning, but in application is show JOption pane with message Document is empty. My code in application is /////////////////////////////////////////////////// java.sql.Connection conn = null; Map<String, Object> params = new HashMap<String, Object>(); params.put("My title text","Nadpis"); // params.put("SELECT id,nazev,cena from majetek","sqlDotaz"); params.put("My summary text","Soucet"); try { JasperReport jasperReport = JasperCompileManager.compileReport(reportSource); JeUzivPrihlasen je = new JeUzivPrihlasen(); if(je.jeNastaveno()){ SpojDatabazi db = new SpojDatabazi(true); conn = db.getConnection(); db = null; je = null; } je = null; JasperPrint jasperPrint = JasperFillManager.fillReport( jasperReport, params, conn); JasperViewer.viewReport(jasperPrint); } catch (JRException ex) { JOptionPane.showMessageDialog(this,"Error with load data!","Error",JOptionPane.ERROR_MESSAGE); ex.printStackTrace(); } ///////////////my jrxml file//////////////////////// <?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="Tisk" columnCount="1" printOrder="Horizontal" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="2" /> <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="Nadpis" isForPrompting="false" class="java.lang.String"/> <parameter name="sqlDotaz" isForPrompting="false" class="java.lang.String"/> <parameter name="Soucet" isForPrompting="false" class="java.lang.String"/> <field name="nazev" class="java.lang.String"/> <field name="cena" class="java.lang.Double"/> <field name="inventarni" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="50" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="1" width="533" height="36" key="textField-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font pdfEncoding ="Cp1250"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{Nadpis}]]></textFieldExpression> </textField> </band> </title> <pageHeader> <band height="50" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="30" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="100" isSplitAllowed="true" > </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="48" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="2" y="16" width="532" height="32" key="textField-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font pdfEncoding ="Cp1250"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{Soucet}]]></textFieldExpression> </textField> </band> </summary> </jasperReport>

Post edited by: Jakub, at: 2006/08/07 08:55

Hi, I am total beginner with JasperReport. I read tutorials on this website or google, but I have a problem with run my report. I have 3 requierements on my report. 1. I want set up title report from my swing application 2. I would like set up data from MySQL database (I paste in my .jrxml file SQL base answer, and I want add specify data - WHERE name LIKE "John" etc. - from my swing application) 3. One last page I want sum 3th columns - price. I create .jrxml file in iReport, in this file I create 3 field id, name, price (some names as columns from database table), variable Celkem (Sum price), but I know not how next. iReport compile .java file with same name as .jrxml file, this .java and .jrxml files I paste to my NetBeans project.In .java file I want create set functions (title etc.)? Thanks you for your help me My jrxml file /****************************************************/ <?xml version="1.0" encoding="Cp1250" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="Tisk" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="842" columnWidth="535" 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="Cp1250" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <queryString><![CDATA[sELECT id,name,price from foo;]]></queryString> <field name="id" class="java.lang.Integer"/> <field name="name" class="java.lang.String"/> <field name="price" class="java.lang.Double"/> <variable name="Celkem" class="java.lang.Double" resetType="Report" calculation="Sum"> <variableExpression><![CDATA[$F{price}]]></variableExpression> </variable> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="50" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="50" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="30" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="100" isSplitAllowed="true" > </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> Post edited by: Jakub, at: 2006/08/07 08:57