Jump to content

readonly

Members
  • Posts

    4
  • Joined

  • Last visited

readonly's Achievements

Rookie

Rookie (2/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Hello: A few weeks ago I posted a problem but I think I didn't gave details enough so I'm going to do an extensive explanation (screenshots included) in order to someone can help me. I'm about to shoot myself. I'm using iReport 3.0.0 because my project doesn't support a newer version. My problem isn't complex. Indeed, I have a problem with a helloworld report so I suppose I have any kind of configuration problem. I have a file named friends.csv which contains the following: name;email "Archimonde";"archy@argus.net" "Kil'Jaeden";"killy@argus.net" "Velen";"velly@argus.net" I launch iReport 3.0.0 and set up this datasource: <See SC01.jpg> I create a report and set the report query: <See SC02.jpg> I include my two tiny fields: <See SC03.jpg> And I get this: <See SC04.jpg> The file generated is in the "Code" section. I've tested this with CSV, MySQL and Postgres datasources, and in Windoes XP, Vista and Ubuntu. And I got always the same. Any idea? Thank you. 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="TestCSV" 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="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.*" /> <field name="name" class="java.lang.String"/> <field name="email" class="java.lang.String"/> <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" > <staticText> <reportElement x="16" y="10" width="104" height="18" key="staticText-1"/> <box></box> <textElement> <font/> </textElement> <text><![CDATA[Name]]></text> </staticText> <staticText> <reportElement x="133" y="10" width="104" height="18" key="staticText-2"/> <box></box> <textElement> <font/> </textElement> <text><![CDATA[email]]></text> </staticText> </band> </columnHeader> <detail> <band height="44" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="19" y="12" width="100" height="18" key="textField"/> <box></box> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="133" y="12" width="100" height="18" key="textField"/> <box></box> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{email}]]></textFieldExpression> </textField> </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>
  2. Sorry about the insistence but I'm working in an project and I need to solve this so, if you can't help me, I'd like to have documentation about 3.0.0 at least, in order to try solving on my own. Thanks in advance.
  3. Sorry, I must describe it better. The report makes a simple SELECT from a table which primary key is a field named "num_reg_ent". Report only must to print that field ("num_reg_ent") in the details band: a ver ugly report but a good helloworld report. The table contains a few records so I'd like to see some values in the report (values of "num_reg_ent" in the detail band). But report is empty. I've copypasted the query in MySQL Query browser and I get the wanted values there so, what's happening?
  4. Hello to everybody: I'm Román, a Spanish Developer with a special case. I'm developing an app which framework requires working with iReport 3.0.0 (I can't use the latest 3.6.2 version). First, I were not able to find documentation about 3.0.0. In addition, I'v tested it with the "very most" simple report I've been able to design: one SELECT, one field, that (unique) field in the details band... and it doen't work. I attach the xml file in case of anybody can help me. I must say I've tested the connection to the database in the datasource definition dialog and the test is successful and I've tested in both MySQL and PostgreSQL (with each JDBC driver). Thank you in advance. Code:<?xml version="1.0" encoding="ISO-8859-1" ?><!-- Created with iReport - A designer for JasperReports --><!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"><jasperReport name="Test" 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="2" /> <property name="ireport.encoding" value="ISO-8859-1" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <queryString><![CDATA[select num_reg_ent from eos_amendment;]]></queryString> <field name="num_reg_ent" class="java.lang.Integer"/> <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" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="140" y="74" width="100" height="18" key="textField"/> <box></box> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{num_reg_ent}]]></textFieldExpression> </textField> </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>
×
×
  • Create New...