Jasper Report

**sysout** · 09-06-2009, 01:08 PM

Invoice.jrxml

Java Code:

<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<queryString language="SQL">
		<![CDATA[SELECT * FROM trheaderpemesanan]]>
	</queryString>
	<field name="kdPemesanan" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="tanggalPemesanan" class="java.sql.Timestamp">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="totalHarga" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="totalVolume" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="diskonPlus" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="kdPelanggan" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="statusPemesanan" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<group name="kdPemesanan">
		<groupExpression><![CDATA[$F{kdPemesanan}]]></groupExpression>
		<groupHeader>
			<band height="27" splitType="Stretch">
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="139" height="27" forecolor="#FFFFFF" backcolor="#000000"/>
					<textElement>
						<font size="18"/>
					</textElement>
					<text><![CDATA[Kode Invoice]]></text>
				</staticText>
				<textField>
					<reportElement mode="Opaque" x="139" y="0" width="416" height="27" forecolor="#FFFFFF" backcolor="#000000"/>
					<textElement>
						<font size="18" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{kdPemesanan}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="8" splitType="Stretch">
				<line direction="BottomUp">
					<reportElement key="line" x="1" y="4" width="554" height="1"/>
				</line>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="58" splitType="Stretch">
			<line>
				<reportElement x="0" y="8" width="555" height="1"/>
			</line>
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="51" width="555" height="1"/>
			</line>
			<staticText>
				<reportElement x="65" y="13" width="424" height="35"/>
				<textElement textAlignment="Center">
					<font size="26" isBold="true"/>
				</textElement>
				<text><![CDATA[Laporan Pemesanan]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="120" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="139" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Tanggal Pemesanan]]></text>
			</staticText>
			<textField>
				<reportElement x="139" y="0" width="416" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{tanggalPemesanan}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="20" width="139" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Total Harga]]></text>
			</staticText>
			<textField>
				<reportElement x="139" y="20" width="416" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalHarga}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="40" width="139" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Total Volume]]></text>
			</staticText>
			<textField>
				<reportElement x="139" y="40" width="416" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalVolume}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="60" width="139" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Diskon]]></text>
			</staticText>
			<textField>
				<reportElement x="139" y="60" width="416" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{diskonPlus}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="80" width="139" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Kode Pelanggan]]></text>
			</staticText>
			<textField>
				<reportElement x="139" y="80" width="416" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{kdPelanggan}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="100" width="139" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Status Pemesanan]]></text>
			</staticText>
			<textField>
				<reportElement x="139" y="100" width="416" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{statusPemesanan}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="26" splitType="Stretch">
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="516" y="6" width="36" height="19" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="342" y="6" width="170" height="19" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Right">
					<font size="10"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="1" y="6" width="209" height="19" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="10"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>

Thats the jrxml that I generated with Report Wizard.
It's successfull but, just generate 1 row, no loop at all, how to modif this xml code?

is there any template for report?
thanks

**r035198x** · 09-06-2009, 03:08 PM

Just use iReport for generating jasper reports.

**sysout** · 09-07-2009, 04:41 AM

Originally Posted by r035198x

Just use iReport for generating jasper reports.

any links buddy?

**quad64bit** · 09-07-2009, 05:23 AM

Google provided: JasperForge: iReport Project Home

**sysout** · 09-08-2009, 04:38 PM

Originally Posted by quad64bit

Google provided: JasperForge: iReport Project Home

successfully downloaded, palz.
hmm..but it's still not working, I still don't understand how to use the tools :( (absolutely blank)

**r035198x** · 09-08-2009, 04:50 PM

That's why they come with manuals. If you get a specific error with it then post the error message that you got.

**sysout** · 09-09-2009, 12:53 AM

Originally Posted by r035198x

That's why they come with manuals. If you get a specific error with it then post the error message that you got.

it's successfully generate the jrxml, but it's failed to preview.
if I use ireport as a plugin of Netbeans, it's successfully gives a preview, even it can be saved as a pdf, but the template design is standard, and it doesn't loop for some parts.

the code is like above.

**r035198x** · 09-09-2009, 09:17 AM

How did it fail to preview? What error message did you get?
The looping depends on what you put in the detail band and is all explained the iReport manual.

**sysout** · 09-10-2009, 01:01 PM

Originally Posted by r035198x

How did it fail to preview? What error message did you get?
The looping depends on what you put in the detail band and is all explained the iReport manual.

there's no any error message. If I pressed the preview Button, it's automatically turn back to design :confused:

i c, so I just search in report manual?

**r035198x** · 09-10-2009, 01:12 PM

Originally Posted by sysout

...

i c, so I just search in report manual?

Well there is no point in doing anything without first reading any manuals if available. It takes guessing out of the game which is a good thing.

**sysout** · 09-11-2009, 03:01 AM

This is the Result, it loops successfully, but I just want to loop for the detail (the blues one), the black one I want it on header, and the red one, I want it on footer.

watch the color of this file :
Free File Hosting Made Simple - MediaFire

Actually, This is the best preview for the report.
As Example, I want to create Report for Invoice #0000001, then, it gives me report for all items, and their details.
The header of the report is about the invoice detail, and the footer is about the shipment detail.

this is the screen shot of my .jar

Thanks palz, for your help until today :)

**sysout** · 09-16-2009, 03:35 PM

anyone has successfully used JasperReport combined with Java? So it can send parameters from Java to the report.

Please, I really need your hands :(

**r035198x** · 09-16-2009, 03:37 PM

So make the part you want the looping to happen on be a subreport and do the looping in it's detail band. As I said before, it's all explained in the manuals.

Thread: Jasper Report

LinkBack

Thread Tools

Search Thread

Display

Jasper Report

Similar Threads

jasper report

jasper report in struts

JSP and Jasper Report in Netbeans 6.1

Cannot compile or run jasper report!!!!!!!

Jasper report + JPQL

Bookmarks

Bookmarks

Posting Permissions

Size Reduced for Images in PDF &...

myBill 13.05.2013

Bugzero 6.6

Marvin 1.4.3

NetXMS 1.2.7

AppScale 1.7.0

Aspose.Slides for Java 7.3.0

DBeaver 2.2.0

TripleA 1.6.1.4

Remote Launcher Server 0.2.15

New with Java

Application with ODBC connection- ...

New to java and having issues

need help with Database class

Fonts displaying strange?

Help T T i'm so frustrating now

Telnet Client ?

Access to KeyStore

Java Graphics JAR .. Double Click...

netscape.javascript - Error