Jump to content
We've recently updated our Privacy Statement, available here ×

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]

 

Link to comment
Share on other sites
  • 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.

Link to comment
Share on other sites

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...

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

Products

Explore