Jasper Report

Invoice.jrxml

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> </textElement> <text><![CDATA[Kode Invoice]]></text> </staticText> <textField> <reportElement mode="Opaque" x="139" y="0" width="416" height="27" forecolor="#FFFFFF" backcolor="#000000"/> <textElement> </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"> </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> </textElement> <text><![CDATA[Tanggal Pemesanan]]></text> </staticText> <textField> <reportElement x="139" y="0" width="416" height="20"/> <textElement> </textElement> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{tanggalPemesanan}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="20" width="139" height="20"/> <textElement> </textElement> <text><![CDATA[Total Harga]]></text> </staticText> <textField> <reportElement x="139" y="20" width="416" height="20"/> <textElement> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalHarga}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="40" width="139" height="20"/> <textElement> </textElement> <text><![CDATA[Total Volume]]></text> </staticText> <textField> <reportElement x="139" y="40" width="416" height="20"/> <textElement> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{totalVolume}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="60" width="139" height="20"/> <textElement> </textElement> <text><![CDATA[Diskon]]></text> </staticText> <textField> <reportElement x="139" y="60" width="416" height="20"/> <textElement> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{diskonPlus}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="80" width="139" height="20"/> <textElement> </textElement> <text><![CDATA[Kode Pelanggan]]></text> </staticText> <textField> <reportElement x="139" y="80" width="416" height="20"/> <textElement> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{kdPelanggan}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="100" width="139" height="20"/> <textElement> </textElement> <text><![CDATA[Status Pemesanan]]></text> </staticText> <textField> <reportElement x="139" y="100" width="416" height="20"/> <textElement> </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> </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"> </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> </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

Just use iReport for generating jasper reports.

Quote:

Originally Posted by r035198x

Just use iReport for generating jasper reports.

any links buddy?

Google provided: JasperForge: iReport Project Home

Quote:

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)

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

Quote:

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.

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.

Quote:

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?

Quote:

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.

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
http://img134.imageshack.us/img134/9521/outputj.jpg

Thanks palz, for your help until today :)

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

Please, I really need your hands :(

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.