Jump to content

Jasper Report blank page at Page 1 (export to excel) & Group sum

lasaca

By lasaca
in Products

 Share

Recommended Posts

lasaca Newbie

lasaca

Posted
Posted 

<?xml version="1.0" encoding="UTF-8"?>

<!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0 -->

<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="LoStock_PrintPreview4_2" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="NoPages" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" whenResourceMissingType="Empty" isIgnorePagination="true" uuid="a3b49131-2ff3-48ad-8c3f-30ccc4afdec1">

 

<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>

<property name="net.sf.jasperreports.export.xls.one.page.per.sheet " value="true"/>

 

<propertyExpression name="net.sf.jasperreports.export.xls.sheet.names.{arbitrary_name}" evaluationTime="Late"><![CDATA[$F{MAKER}]]></propertyExpression>

<parameter name="minDeliveryDate" class="java.lang.String"/>

<parameter name="maxDeliveryDate" class="java.lang.String"/>

<queryString>

.

.

.

</queryString>

<field name="MAKER" class="java.lang.String">

<property name="com.jaspersoft.studio.field.label" value="MAKER"/>

</field>

<field name="NAME" class="java.lang.String">

<property name="com.jaspersoft.studio.field.label" value="NAME"/>

</field>

<field name="PORT" class="java.lang.String">

<property name="com.jaspersoft.studio.field.label" value="PORT"/>

</field>

<field name="CYL_QTY" class="java.math.BigDecimal">

<property name="com.jaspersoft.studio.field.label" value="CYL_QTY"/>

</field>

<field name="CYL_PRICE" class="java.lang.Double">

<property name="com.jaspersoft.studio.field.label" value="CYL_PRICE"/>

</field>

<field name="CYL_AMOUNT" class="java.lang.Double">

<property name="com.jaspersoft.studio.field.label" value="CYL_AMOUNT"/>

</field>

<field name="ME_QTY" class="java.math.BigDecimal">

<property name="com.jaspersoft.studio.field.label" value="ME_QTY"/>

</field>

<field name="ME_PRICE" class="java.lang.Double">

<property name="com.jaspersoft.studio.field.label" value="ME_PRICE"/>

</field>

<field name="ME_AMOUNT" class="java.lang.Double">

<property name="com.jaspersoft.studio.field.label" value="ME_AMOUNT"/>

</field>

<field name="DG_QTY" class="java.math.BigDecimal">

<property name="com.jaspersoft.studio.field.label" value="DG_QTY"/>

</field>

<field name="DG_PRICE" class="java.lang.Double">

<property name="com.jaspersoft.studio.field.label" value="DG_PRICE"/>

</field>

<field name="DG_AMOUNT" class="java.lang.Double">

<property name="com.jaspersoft.studio.field.label" value="DG_AMOUNT"/>

</field>

<variable name="CYL_PRICE_SUM" class="java.math.BigDecimal" calculation="Sum">

<variableExpression><![CDATA[$F{CYL_PRICE}]]></variableExpression>

</variable>

<variable name="CYL_QTY_SUM" class="java.math.BigDecimal" calculation="Sum">

<variableExpression><![CDATA[$F{CYL_QTY}]]></variableExpression>

</variable>

<variable name="CYL_QTY_AMOUNT" class="java.math.BigDecimal" calculation="Sum">

<variableExpression><![CDATA[$F{CYL_AMOUNT}]]></variableExpression>

</variable>

<variable name="ME_PRICE_SUM" class="java.math.BigDecimal" calculation="Sum">

<variableExpression><![CDATA[$F{ME_PRICE}]]></variableExpression>

</variable>

<variable name="ME_QTY_SUM" class="java.math.BigDecimal" calculation="Sum">

<variableExpression><![CDATA[$F{ME_QTY}]]></variableExpression>

</variable>

<variable name="ME_AMOUNT_SUM" class="java.math.BigDecimal" calculation="Sum">

<variableExpression><![CDATA[$F{ME_AMOUNT}]]></variableExpression>

</variable>

<variable name="DG_QTY_SUM" class="java.math.BigDecimal" calculation="Sum">

<variableExpression><![CDATA[$F{DG_QTY}]]></variableExpression>

</variable>

<variable name="DG_PRICE_SUM" class="java.math.BigDecimal" calculation="Sum">

<variableExpression><![CDATA[$F{DG_PRICE}]]></variableExpression>

</variable>

<variable name="DG_AMOUNT_SUM" class="java.math.BigDecimal" calculation="Sum">

<variableExpression><![CDATA[$F{DG_AMOUNT}]]></variableExpression>

</variable>

<group name="Maker_groupExp" isStartNewColumn="true" isStartNewPage="true">

<groupExpression><![CDATA[$F{MAKER}]]></groupExpression>

<groupHeader>

<band height="22" splitType="Stretch">

<textField>

<reportElement x="0" y="0" width="410" height="22" isRemoveLineWhenBlank="true" forecolor="#201919" uuid="710665d1-5e7f-4ba1-be7d-169cd0d63d5c">

<property name="net.sf.jasperreports.export.xls.break.before.row" value="true"/>

<property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>

<propertyExpression name="net.sf.jasperreports.export.xls.sheet.name"><![CDATA[$F{MAKER}]]></propertyExpression>

</reportElement>

<textElement>

<font size="16" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$F{MAKER}]]></textFieldExpression>

</textField>

</band>

</groupHeader>

</group>

<group name="Name_groupExp">

<groupExpression><![CDATA[$F{NAME}]]></groupExpression>

<groupHeader>

<band height="60" splitType="Stretch">

<textField>

<reportElement x="0" y="3" width="400" height="20" isRemoveLineWhenBlank="true" forecolor="#CC6B04" uuid="7f9f6864-3a02-4a38-906d-d97f05d54307"/>

<textElement verticalAlignment="Middle">

<font size="13" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$F{NAME}]]></textFieldExpression>

</textField>

<staticText>

<reportElement mode="Opaque" x="0" y="26" width="100" height="34" backcolor="#00FFEA" uuid="3562cacb-4dfb-41ec-b7d1-5b11d1c7bb26"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[PORT]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="100" y="26" width="240" height="20" backcolor="#00FFF2" uuid="7c3f820d-db9f-423a-9b56-b01ee368caa7"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[CYL]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="410" y="46" width="85" height="14" backcolor="#00FFEA" uuid="e24ef525-5eba-4ad2-9020-074c427ebdde"/>

<box>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[Q'TY]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="340" y="46" width="70" height="14" backcolor="#00FFEA" uuid="d631cbb1-ac96-481f-9164-12cb7326bd57"/>

<box>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[PRICE]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="495" y="46" width="85" height="14" backcolor="#00FFEA" uuid="adec8070-2b1c-4094-aa89-a8bf781f64b3"/>

<box>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[AMOUNT]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="340" y="26" width="240" height="20" backcolor="#00FFF2" uuid="87e4fcb1-120e-42f6-a30d-75fe283ec505"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[ME / SYS]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="650" y="46" width="85" height="14" backcolor="#00FFEA" uuid="ba43da97-dcd4-4f84-a7f0-1dace3f914bf"/>

<box>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[Q'TY]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="580" y="46" width="70" height="14" backcolor="#00FFEA" uuid="5260f0e7-d6ff-4561-b095-493860f541cc"/>

<box>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[PRICE]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="735" y="46" width="85" height="14" backcolor="#00FFEA" uuid="48cd7d3e-2394-4dfb-81df-d73c8afbdad4"/>

<box>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[AMOUNT]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="580" y="26" width="240" height="20" backcolor="#00FFF2" uuid="18bb2008-09a1-4e80-9fd6-ae3fac42951d"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[DG / SYS]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="170" y="46" width="85" height="14" backcolor="#00FFEA" uuid="690195d6-cfe6-4e0c-9d83-1edeb7147bca"/>

<box>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[Q'TY]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="100" y="46" width="70" height="14" backcolor="#00FFEA" uuid="69dc96f3-1264-428c-98cc-36f297d8589c"/>

<box>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[PRICE]]></text>

</staticText>

<staticText>

<reportElement mode="Opaque" x="255" y="46" width="85" height="14" backcolor="#00FFEA" uuid="17259991-f449-4f6b-8734-f221e2063fa9"/>

<box>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font size="11" isBold="true"/>

</textElement>

<text><![CDATA[AMOUNT]]></text>

</staticText>

</band>

</groupHeader>

<groupFooter>

<band height="26">

<staticText>

<reportElement mode="Opaque" x="0" y="0" width="100" height="19" isRemoveLineWhenBlank="true" forecolor="#1414F5" backcolor="#00FFEA" uuid="477d2f42-c986-4ff2-aed0-56d60268bfb7"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font fontName="SansSerif" size="10" isBold="true"/>

</textElement>

<text><![CDATA[AVE.PRICE]]></text>

</staticText>

<textField>

<reportElement mode="Opaque" x="170" y="0" width="85" height="19" forecolor="#1414F5" backcolor="#00FFEA" uuid="21c29d8e-aac7-4827-bff5-9854e5225f51"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font fontName="SansSerif" size="10" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{CYL_QTY_SUM}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($V{CYL_QTY_SUM})]]></textFieldExpression>

</textField>

<textField>

<reportElement mode="Opaque" x="255" y="0" width="85" height="19" forecolor="#1414F5" backcolor="#00FFEA" uuid="c2068d39-e294-4235-b105-d7a728a4717f"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font fontName="SansSerif" size="10" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{CYL_QTY_AMOUNT}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($V{CYL_QTY_AMOUNT})]]></textFieldExpression>

</textField>

<textField>

<reportElement mode="Opaque" x="340" y="0" width="70" height="19" forecolor="#1414F5" backcolor="#00FFEA" uuid="e9ed214e-f6c5-488a-9c26-2fa7ad9b9b43"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font fontName="SansSerif" size="10" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{ME_PRICE_SUM}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($V{ME_PRICE_SUM})]]></textFieldExpression>

</textField>

<textField>

<reportElement mode="Opaque" x="410" y="0" width="85" height="19" forecolor="#1414F5" backcolor="#00FFEA" uuid="8b7f8ff3-4981-495b-b0f7-663e34051cc2"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font fontName="SansSerif" size="10" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{ME_QTY_SUM}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($V{ME_QTY_SUM})]]></textFieldExpression>

</textField>

<textField>

<reportElement mode="Opaque" x="495" y="0" width="85" height="19" forecolor="#1414F5" backcolor="#00FFEA" uuid="fb8b8012-b9b0-46bf-a0c7-7be86b3c2aa7"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font fontName="SansSerif" size="10" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{ME_AMOUNT_SUM}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($V{ME_AMOUNT_SUM})]]></textFieldExpression>

</textField>

<textField>

<reportElement mode="Opaque" x="650" y="0" width="85" height="19" forecolor="#1414F5" backcolor="#00FFEA" uuid="a00a3975-73af-4018-8078-dfe9b8f692ec"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font fontName="SansSerif" size="10" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{DG_QTY_SUM}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($V{DG_QTY_SUM})]]></textFieldExpression>

</textField>

<textField>

<reportElement mode="Opaque" x="580" y="0" width="70" height="19" forecolor="#1414F5" backcolor="#00FFEA" uuid="487e0289-d43f-42d4-bc8a-5bd3c0131812"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font fontName="SansSerif" size="10" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{DG_PRICE_SUM}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($V{DG_PRICE_SUM})]]></textFieldExpression>

</textField>

<textField>

<reportElement mode="Opaque" x="735" y="0" width="85" height="19" forecolor="#1414F5" backcolor="#00FFEA" uuid="cbf1e03b-3615-4fbc-86e3-4cca04f123d0"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font fontName="SansSerif" size="10" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{DG_AMOUNT_SUM}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($V{DG_AMOUNT_SUM})]]></textFieldExpression>

</textField>

<textField>

<reportElement mode="Opaque" x="100" y="0" width="70" height="19" forecolor="#1414F5" backcolor="#00FFEA" uuid="47e54981-89ef-4788-b1e5-4bf5bac3f94a"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Center" verticalAlignment="Middle">

<font fontName="SansSerif" size="10" isBold="true"/>

</textElement>

<textFieldExpression><![CDATA[$V{CYL_PRICE_SUM}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($V{CYL_PRICE_SUM})]]></textFieldExpression>

</textField>

</band>

</groupFooter>

</group>

<detail>

<band height="19" splitType="Stretch">

<textField>

<reportElement x="0" y="0" width="100" height="19" uuid="7e30d84d-6b17-47d6-97db-21911d6de375">

<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="236f597c-1bbe-4799-92d8-d9ea8c88dc56"/>

</reportElement>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<pen lineWidth="0.75"/>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Left" verticalAlignment="Middle">

<font size="10"/>

</textElement>

<textFieldExpression><![CDATA[$F{PORT}]]></textFieldExpression>

</textField>

<textField>

<reportElement x="170" y="0" width="85" height="19" uuid="32c4f27f-08a2-43ad-913a-84f0d8668fc7"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<pen lineWidth="0.75"/>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font size="10"/>

</textElement>

<textFieldExpression><![CDATA[$F{CYL_QTY}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($F{CYL_QTY})]]></textFieldExpression>

</textField>

<textField>

<reportElement x="100" y="0" width="70" height="19" uuid="b0189cf7-7121-41c3-a35e-0abdad332269"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<pen lineWidth="0.75"/>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font size="10"/>

</textElement>

<textFieldExpression><![CDATA[$F{CYL_PRICE}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($F{CYL_PRICE})]]></textFieldExpression>

</textField>

<textField>

<reportElement x="255" y="0" width="85" height="19" uuid="decd02b9-e2b6-47f0-a3a4-a210f32e6d0e"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<pen lineWidth="0.75"/>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font size="10"/>

</textElement>

<textFieldExpression><![CDATA[$F{CYL_AMOUNT}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($F{CYL_AMOUNT})]]></textFieldExpression>

</textField>

<textField>

<reportElement x="410" y="0" width="85" height="19" uuid="040120e5-a232-4d4e-b9cc-4d6a6c511650"/>

<box leftPadding="4">

<pen lineWidth="0.75"/>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font size="10"/>

</textElement>

<textFieldExpression><![CDATA[$F{ME_QTY}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($F{ME_QTY})]]></textFieldExpression>

</textField>

<textField>

<reportElement x="340" y="0" width="70" height="19" uuid="a6c2a1df-c5e6-4d38-a977-8f2a09d1dbd1"/>

<box leftPadding="4">

<pen lineWidth="0.75"/>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font size="10"/>

</textElement>

<textFieldExpression><![CDATA[$F{ME_PRICE}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($F{ME_PRICE})]]></textFieldExpression>

</textField>

<textField>

<reportElement x="495" y="0" width="85" height="19" uuid="15a84dd1-5588-430b-88ba-2dcb9d83594e"/>

<box leftPadding="4">

<pen lineWidth="0.75"/>

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font size="10"/>

</textElement>

<textFieldExpression><![CDATA[$F{ME_AMOUNT}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($F{ME_AMOUNT})]]></textFieldExpression>

</textField>

<textField>

<reportElement x="650" y="0" width="85" height="19" uuid="616771cb-68d2-4a07-a379-d39c7f2bc6ea"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font size="10"/>

</textElement>

<textFieldExpression><![CDATA[$F{DG_QTY}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($F{DG_QTY})]]></textFieldExpression>

</textField>

<textField>

<reportElement x="580" y="0" width="70" height="19" uuid="cb0730e6-0f39-4f78-8425-21f7f7205e40"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font size="10"/>

</textElement>

<textFieldExpression><![CDATA[$F{DG_PRICE}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($F{DG_PRICE})]]></textFieldExpression>

</textField>

<textField>

<reportElement x="735" y="0" width="85" height="19" uuid="75c06759-15d8-44f1-a02a-824cf84aa25d"/>

<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="4">

<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>

</box>

<textElement textAlignment="Right" verticalAlignment="Middle">

<font size="10"/>

</textElement>

<textFieldExpression><![CDATA[$F{DG_AMOUNT}==null?"0.00":new java.text.DecimalFormat("#,##0.00").format($F{DG_AMOUNT})]]></textFieldExpression>

</textField>

</band>

</detail>

</jasperReport>

[/code]

 

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

lasaca Newbie

lasaca

Posted
  • Author
Posted

Hi, can someone please help me.

I am trying to export an excel that can produce excel sheet every group expression but it always gives me PAGE 1 blank sheet.

Also, can you show me how to generate sum per group.

 

Thank you very much.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

© 2025 Cloud Software Group,
Inc. All rights reserved.

Products

Explore