MScalli

Hi I have a problem with an simple Report. Who can help plz?? now my prob.. I create datasets in an database with an self created Key. For example, i have 10 datasets with the same key 'z0504_1234.spv'. Now I want to show the datasets with this key in an Report(select * from part2 where pkey = 'z0504_1234.spv') the fields w221-w230 from this table stands one below the other. if field = blank jasper should not show this field and the other fields slides higher. This works.. the except is the last set on page... theres a lot of room at the bottom of all pages. Here´s the jrxml created with IReport 2.0.2 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="TestZ0504Sub4" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="535" pageHeight="842" columnWidth="535" columnSpacing="0" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" 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="ident" isForPrompting="false" class="java.lang.String"> <defaultValueExpression ><![CDATA["z0504572_3647.spv"]]></defaultValueExpression> </parameter> <queryString><![CDATA[select * from part2 where pkey = $P{ident}]]></queryString> <field name="pkey" class="java.lang.String"/> <field name="w201" class="java.lang.String"/> <field name="w202" class="java.lang.String"/> <field name="w203" class="java.lang.String"/> <field name="w204" class="java.lang.String"/> <field name="w205" class="java.lang.String"/> <field name="w206" class="java.lang.String"/> <field name="w207" class="java.lang.String"/> <field name="w208" class="java.lang.String"/> <field name="w209" class="java.lang.String"/> <field name="w210" class="java.lang.String"/> <field name="w211" class="java.lang.String"/> <field name="w212" class="java.lang.String"/> <field name="w213" class="java.lang.String"/> <field name="w214" class="java.lang.String"/> <field name="w215" class="java.lang.String"/> <field name="w216" class="java.lang.String"/> <field name="w217" class="java.lang.String"/> <field name="w218" class="java.lang.String"/> <field name="w219" class="java.lang.String"/> <field name="w220" class="java.lang.String"/> <field name="w221" class="java.lang.String"/> <field name="w222" class="java.lang.String"/> <field name="w223" class="java.lang.String"/> <field name="w224" class="java.lang.String"/> <field name="w225" class="java.lang.String"/> <field name="w226" class="java.lang.String"/> <field name="w227" class="java.lang.String"/> <field name="w228" class="java.lang.String"/> <field name="w229" class="java.lang.String"/> <field name="w230" class="java.lang.String"/> <field name="w231" class="java.lang.String"/> <field name="w232" class="java.lang.String"/> <field name="w233" class="java.lang.String"/> <field name="w234" class="java.lang.String"/> <field name="w235" class="java.lang.String"/> <field name="w236" class="java.lang.String"/> <field name="w237" class="java.lang.String"/> <field name="w238" class="java.lang.String"/> <field name="w239" class="java.lang.String"/> <field name="w240" class="java.lang.String"/> <field name="w241" class="java.lang.String"/> <field name="w242" class="java.lang.String"/> <field name="w243" class="java.lang.String"/> <field name="w244" class="java.lang.String"/> <field name="w245" class="java.lang.String"/> <field name="w246" class="java.lang.String"/> <field name="w247" class="java.lang.String"/> <field name="w248" class="java.lang.String"/> <field name="w249" class="java.lang.String"/> <field name="w250" class="java.lang.String"/> <field name="w251" class="java.lang.String"/> <field name="w252" class="java.lang.String"/> <field name="w253" class="java.lang.String"/> <field name="w254" class="java.lang.String"/> <field name="w255" class="java.lang.String"/> <field name="w256" class="java.lang.String"/> <field name="w257" class="java.lang.String"/> <field name="w258" class="java.lang.String"/> <field name="w259" class="java.lang.String"/> <field name="w260" class="java.lang.String"/> <field name="w261" class="java.lang.String"/> <field name="w262" class="java.lang.String"/> <field name="w263" class="java.lang.String"/> <field name="w264" class="java.lang.String"/> <field name="w265" class="java.lang.String"/> <field name="w266" class="java.lang.String"/> <field name="w267" class="java.lang.String"/> <field name="w268" class="java.lang.String"/> <field name="w269" class="java.lang.String"/> <field name="w270" class="java.lang.String"/> <field name="w301" class="java.lang.String"/> <field name="w302" class="java.lang.String"/> <field name="w303" class="java.lang.String"/> <field name="w304" class="java.lang.String"/> <field name="w305" class="java.lang.String"/> <field name="w306" class="java.lang.String"/> <field name="w307" class="java.lang.String"/> <field name="w308" class="java.lang.String"/> <field name="w309" class="java.lang.String"/> <field name="w310" class="java.lang.String"/> <field name="w311" class="java.lang.String"/> <field name="w312" class="java.lang.String"/> <field name="w313" class="java.lang.String"/> <field name="w314" class="java.lang.String"/> <field name="w315" class="java.lang.String"/> <field name="w316" class="java.lang.String"/> <field name="w317" class="java.lang.String"/> <field name="w318" class="java.lang.String"/> <field name="w319" class="java.lang.String"/> <field name="w320" class="java.lang.String"/> <field name="w321" class="java.lang.String"/> <field name="w322" class="java.lang.String"/> <field name="w323" class="java.lang.String"/> <field name="w324" class="java.lang.String"/> <field name="w325" class="java.lang.String"/> <field name="w326" class="java.lang.String"/> <field name="w327" class="java.lang.String"/> <field name="w328" class="java.lang.String"/> <field name="w329" class="java.lang.String"/> <field name="w330" class="java.lang.String"/> <field name="w331" class="java.lang.String"/> <field name="w332" class="java.lang.String"/> <field name="w333" class="java.lang.String"/> <field name="w334" class="java.lang.String"/> <field name="w335" class="java.lang.String"/> <field name="w336" class="java.lang.String"/> <field name="w337" class="java.lang.String"/> <field name="w338" class="java.lang.String"/> <field name="w339" class="java.lang.String"/> <field name="w340" class="java.lang.String"/> <field name="w341" class="java.lang.String"/> <field name="w342" class="java.lang.String"/> <field name="w343" class="java.lang.String"/> <field name="w344" class="java.lang.String"/> <field name="w345" class="java.lang.String"/> <field name="w346" class="java.lang.String"/> <field name="w347" class="java.lang.String"/> <field name="w348" class="java.lang.String"/> <field name="w349" class="java.lang.String"/> <field name="w350" class="java.lang.String"/> <field name="w401" class="java.lang.String"/> <field name="w402" class="java.lang.String"/> <field name="w403" class="java.lang.String"/> <field name="w404" class="java.lang.String"/> <field name="w405" class="java.lang.String"/> <field name="w406" class="java.lang.String"/> <field name="w407" class="java.lang.String"/> <field name="w408" class="java.lang.String"/> <field name="w409" class="java.lang.String"/> <field name="w410" class="java.lang.String"/> <field name="w411" class="java.lang.String"/> <field name="w412" class="java.lang.String"/> <field name="w413" class="java.lang.String"/> <field name="w414" class="java.lang.String"/> <field name="w415" class="java.lang.String"/> <field name="w416" class="java.lang.String"/> <field name="w417" class="java.lang.String"/> <field name="w418" class="java.lang.String"/> <field name="w419" class="java.lang.String"/> <field name="w420" class="java.lang.String"/> <field name="w421" class="java.lang.String"/> <field name="w422" class="java.lang.String"/> <field name="w423" class="java.lang.String"/> <field name="w424" class="java.lang.String"/> <field name="w425" class="java.lang.String"/> <field name="w426" class="java.lang.String"/> <field name="w427" class="java.lang.String"/> <field name="w428" class="java.lang.String"/> <field name="w429" class="java.lang.String"/> <field name="w430" class="java.lang.String"/> <field name="w431" class="java.lang.String"/> <field name="w432" class="java.lang.String"/> <field name="w433" class="java.lang.String"/> <field name="w434" class="java.lang.String"/> <field name="w435" class="java.lang.String"/> <field name="w436" class="java.lang.String"/> <field name="w437" class="java.lang.String"/> <field name="w438" class="java.lang.String"/> <field name="w439" class="java.lang.String"/> <field name="w440" class="java.lang.String"/> <field name="w441" class="java.lang.String"/> <field name="w442" class="java.lang.String"/> <field name="w443" class="java.lang.String"/> <field name="w444" class="java.lang.String"/> <field name="w445" class="java.lang.String"/> <field name="w446" class="java.lang.String"/> <field name="w447" class="java.lang.String"/> <field name="w448" class="java.lang.String"/> <field name="w449" class="java.lang.String"/> <field name="w450" class="java.lang.String"/> <field name="w500" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="192" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Auto" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="7" width="100" height="18" key="textField" positionType="Float" isRemoveLineWhenBlank="true"/> <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{w221}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Auto" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="25" width="100" height="18" key="textField" positionType="Float" isRemoveLineWhenBlank="true"/> <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{w222}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Auto" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="43" width="100" height="18" key="textField" positionType="Float" isRemoveLineWhenBlank="true"/> <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{w223}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Auto" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="61" width="100" height="18" key="textField" positionType="Float" isRemoveLineWhenBlank="true"/> <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{w224}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Auto" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="79" width="100" height="18" key="textField" positionType="Float" isRemoveLineWhenBlank="true"/> <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{w225}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Auto" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="97" width="100" height="18" key="textField" positionType="Float" isRemoveLineWhenBlank="true"/> <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{w226}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Auto" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="115" width="100" height="18" key="textField" positionType="Float" isRemoveLineWhenBlank="true"/> <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{w227}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Auto" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="133" width="100" height="18" key="textField" positionType="Float" isRemoveLineWhenBlank="true"/> <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{w228}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Auto" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="151" width="100" height="18" key="textField" positionType="Float" isRemoveLineWhenBlank="true"/> <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{w229}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Auto" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="169" width="100" height="18" key="textField" positionType="Float" isRemoveLineWhenBlank="true"/> <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{w230}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="0" isSplitAllowed="true" > </band> </summary></jasperReport>

no one know whats the failure??? i`ve tried to close the window later with the PID like Tasklist /FI "PID eq 1234" but it doesn´t works?!?! why the javaw.exe doesn´t stop when i close the viewer. plz help me.. can´t find any solution..

hi all. first sry for my english ;) hope anyone can help me. have probs calling the viewer. i can call him without any problem, but if i close them the javaw.exe in the taskmanager stays open. for example.. i open 10 times the viewer, then i have 10 times the javax.exe in the manager. must i close them manual??? heres my code Code: jasperReport=JasperCompileManager.compileReport(path_jrxml + "\" + fn_jrxml); jasperPrint=JasperFillManager.fillReport(jasperReport, parameter, con); viewer = new JRViewer(jasperPrint); add(viewer); setVisible(true); plz help me!! greetz MScalli

thx thx thx.... the idea with the groups was the rescue.. it works.. merci svenn!! @ mehdi2 thx too.. but i have to change the height to runtime.. and how should i calculate this ?? ^^

hi. sry for my english first ;) i try few days to include 2 subreports in the detail-Band. My problem is that the second subreport overwrites the first one!! one sample... i have my head in the pageHeader .. now comes the first subreport.. and then(after the first subreport is shown COMPLETELY) comes the second subreport. i´ve tried to put the second subreport into the summary band.. this works.. but now i miss the pageHeader at this pages. plz help me!!!!! greetz MScalli

hi. I´m new here and want to knew.. ist it possible to include a text file to iReport. an example. my adresses and other infos are saved in a text-files. looks like.. 1000 name 1001 adress 1002 country... can i read the text file in iReport like databases?? thx 4 help!! MScalli