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

start on new page


2004 IR Help

Recommended Posts

By: frassy - frassyman

start on new page

2004-07-22 06:14

I want my report to fill the pages from top to bottom(a4) without starting on new page after a specific band.

 

Can someone please give me a brief explanation how I control when the report will start on a new page or not.

 

I have reports will multiple bands and sometimes the pages will not fill up the way I want them to.

 

I would really appriciate it

 

 

 

 

By: frassy - frassyman

RE: start on new page

2004-07-22 06:29

although my report design doesn't have any blank spaces between my bands, and between my bands and the top or bottom the report is always exported (into pdf format) with approx 5 cm of blank space in the bottom of my pages(this is before page number).

 

As I said before I want fill upp my pages entirely, but how?

 

 

 

 

By: frassy - frassyman

RE: start on new page

2004-07-22 06:53

<?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="Turnover_reportAR013"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="595"

pageHeight="842"

columnWidth="535"

columnSpacing="0"

leftMargin="30"

rightMargin="30"

topMargin="20"

bottomMargin="20"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

<property name="ireport.scriptlethandling" value="2" />

<parameter name="Logo" isForPrompting="false" class="java.lang.String">

<defaultValueExpression ><![CDATA["Store Master Reporting"]]></defaultValueExpression>

</parameter>

<parameter name="Title" isForPrompting="true" class="java.lang.String">

<defaultValueExpression ><![CDATA["M审dsoms䴴ning butik/kundnr"]]></defaultValueExpression>

</parameter>

<parameter name="CopyRight" isForPrompting="true" class="java.lang.String">

<defaultValueExpression ><![CDATA["©2003-2004 by ICA Sverige AB"]]></defaultValueExpression>

</parameter>

<parameter name="SelectRegion" isForPrompting="true" class="java.lang.String">

<defaultValueExpression ><![CDATA["Norr"]]></defaultValueExpression>

</parameter>

<parameter name="SelectDistrict" isForPrompting="true" class="java.lang.String">

<defaultValueExpression ><![CDATA["%"]]></defaultValueExpression>

</parameter>

<parameter name="SelectMunicipality" isForPrompting="true" class="java.lang.String">

<defaultValueExpression ><![CDATA["Ųe"]]></defaultValueExpression>

</parameter>

<parameter name="SelectDate" isForPrompting="true" class="java.lang.String">

<defaultValueExpression ><![CDATA["1999-01-01"]]></defaultValueExpression>

</parameter>

<parameter name="ReturnedValuesMap" isForPrompting="false" class="java.util.Map">

<defaultValueExpression ><![CDATA[new java.util.HashMap()]]></defaultValueExpression>

</parameter>

<queryString><![CDATA[select s.STORE_ID,

s.MARKETING_NAME,

a.CUSTOMER_NUMBER,

a2.CUSTOMER_NUMBER as PAST_CUSTOMER_NUMBER,

s.PROFILE_ID,

p.PROFILE_NAME,

pl.PROFILE_LEVEL_NAME,

re.REGION_NAME,

d.DISTRICT_NAME,

m.MUNICIPALITY_NAME,

mt.TURNOVER_MONTH as PRESENT

from STORE s,

Account a,

Account a2,

STORE_OWNER so,

STORE_OWNER so2,

PROFILE p,

PROFILE_LEVEL pl,

MONTHLY_TURNOVER mt,--present

DISTRICT d,

REGION re,

MUNICIPALITY m

where s.CLOSING_DATE is null

and s.profile_id is not null

and s.store_group_id in(1) --Bara ICA butiker

--kundnummer nu (baserat på©ndata)

and s.STORE_ID=so.STORE_ID

and ((TO_DATE('$P!{SelectDate}', 'yyyy-mm-dd') between so.START_DATE and so.END_DATE)

or (TO_DATE('$P!{SelectDate}', 'yyyy-mm-dd') >= so.START_DATE and so.END_DATE is null))

and ((TO_DATE('$P!{SelectDate}', 'yyyy-mm-dd') between a.START_DATE and a.END_DATE)

or (TO_DATE('$P!{SelectDate}', 'yyyy-mm-dd') >= a.START_DATE and a.END_DATE is null))

and so.STORE_OWNER_ID=a.STORE_OWNER_ID

and a.master_account=1

--kundnummer f?olv m审der sen

and s.STORE_ID=so2.STORE_ID

and ((ADD_MONTHS(TO_DATE('$P!{SelectDate}', 'yyyy-mm-dd'),-12) between so2.START_DATE and so2.END_DATE)

or (ADD_MONTHS(TO_DATE('$P!{SelectDate}', 'yyyy-mm-dd'),-12) >= so2.START_DATE and so2.END_DATE is null))

and ((ADD_MONTHS(TO_DATE('$P!{SelectDate}', 'yyyy-mm-dd'),-12) between a2.START_DATE and a2.END_DATE)

or (ADD_MONTHS(TO_DATE('$P!{SelectDate}', 'yyyy-mm-dd'),-12) >= a2.START_DATE and a2.END_DATE is null))

and so2.STORE_OWNER_ID=a2.STORE_OWNER_ID

and a2.master_account=1

--Profil--

and s.PROFILE_ID=p.PROFILE_ID

and s.PROFIlE_LEVEL_ID=pl.PROFILE_LEVEL_ID

--distrikt,region och kommun butiken ligger i

and d.DISTRICT_ID=s.DISTRICT_ID

and re.REGION_ID=s.REGION_ID

and m.MUNICIPALITY_ID=s.MUNICIPALITY_ID

---omsä´´ning

and a.CUSTOMER_NUMBER=mt.CUSTOMER_NUMBER

--and a2.CUSTOMER_NUMBER=mt.CUSTOMER_NUMBER

and s.STORE_ID = mt.STORE_ID

and mt.TURNOVER_MONTH between ADD_MONTHS(TO_DATE('$P!{SelectDate}', 'yyyy-mm-dd'),-11) and TO_DATE('$P!{SelectDate}', 'yyyy-mm-dd')

and REGION_NAME like $P{SelectRegion}

and MUNICIPALITY_NAME like $P{SelectMunicipality}

and DISTRICT_NAME like $P{SelectDistrict}

order by REGION_NAME, DISTRICT_NAME, MUNICIPALITY_NAME]]></queryString>

<field name="STORE_ID" class="java.lang.Double"/>

<field name="MARKETING_NAME" class="java.lang.String"/>

<field name="CUSTOMER_NUMBER" class="java.lang.Double"/>

<field name="PAST_CUSTOMER_NUMBER" class="java.lang.Double"/>

<field name="PROFILE_ID" class="java.lang.Double"/>

<field name="PROFILE_NAME" class="java.lang.String"/>

<field name="PROFILE_LEVEL_NAME" class="java.lang.String"/>

<field name="REGION_NAME" class="java.lang.String"/>

<field name="DISTRICT_NAME" class="java.lang.String"/>

<field name="MUNICIPALITY_NAME" class="java.lang.String"/>

<field name="PRESENT" class="java.sql.Timestamp"/>

<group name="REGiON_NAME" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

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

<groupHeader>

<band height="25" isSplitAllowed="true" >

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="0"

y="0"

width="535"

height="25"

forecolor="#FFFFFF"

backcolor="#666666"

key="element-356"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="None" fill="Solid" />

</rectangle>

<staticText>

<reportElement

mode="Transparent"

x="0"

y="0"

width="96"

height="23"

forecolor="#FFFFFF"

backcolor="#FFFFFF"

key="element-357"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="18" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

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

</staticText>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="96"

y="0"

width="217"

height="23"

forecolor="#FFFFFF"

backcolor="#FFFFFF"

key="element-358"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="18" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{REGION_NAME}]]></textFieldExpression>

</textField>

</band>

</groupHeader>

<groupFooter>

<band height="0" isSplitAllowed="true" >

</band>

</groupFooter>

</group>

<group name="DISTRICT_NAME" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

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

<groupHeader>

<band height="25" isSplitAllowed="true" >

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="0"

y="0"

width="535"

height="25"

forecolor="#FFFFFF"

backcolor="#999999"

key="element-356"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="None" fill="Solid" />

</rectangle>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="96"

y="0"

width="217"

height="23"

forecolor="#FFFFFF"

backcolor="#FFFFFF"

key="element-362"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="18" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{DISTRICT_NAME}]]></textFieldExpression>

</textField>

<staticText>

<reportElement

mode="Transparent"

x="0"

y="0"

width="96"

height="23"

forecolor="#FFFFFF"

backcolor="#FFFFFF"

key="element-361"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="16" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

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

</staticText>

</band>

</groupHeader>

<groupFooter>

<band height="0" isSplitAllowed="true" >

</band>

</groupFooter>

</group>

<group name="MUNICIPALITY_NAME" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

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

<groupHeader>

<band height="26" isSplitAllowed="true" >

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="0"

y="0"

width="535"

height="25"

forecolor="#FFFFFF"

backcolor="#CCCCCC"

key="element-356"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="None" fill="Solid" />

</rectangle>

<staticText>

<reportElement

mode="Transparent"

x="0"

y="0"

width="96"

height="21"

forecolor="#FFFFFF"

backcolor="#FFFFFF"

key="element-364"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

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

</staticText>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="96"

y="0"

width="217"

height="21"

forecolor="#FFFFFF"

backcolor="#FFFFFF"

key="element-732"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="14" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{MUNICIPALITY_NAME}]]></textFieldExpression>

</textField>

</band>

</groupHeader>

<groupFooter>

<band height="0" isSplitAllowed="true" >

</band>

</groupFooter>

</group>

<group name="STORE_ID" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

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

<groupHeader>

<band height="44" isSplitAllowed="true" >

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="0"

y="3"

width="535"

height="37"

forecolor="#CCCCCC"

backcolor="#CCCCCC"

key="element-107"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</rectangle>

<staticText>

<reportElement

mode="Transparent"

x="0"

y="3"

width="45"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1188"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[butiks id]]></text>

</staticText>

<staticText>

<reportElement

mode="Transparent"

x="45"

y="3"

width="98"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1188"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Marknadsf?gsn.]]></text>

</staticText>

<staticText>

<reportElement

mode="Transparent"

x="143"

y="3"

width="63"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1188"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Akt. kund.nr]]></text>

</staticText>

<staticText>

<reportElement

mode="Transparent"

x="206"

y="3"

width="67"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1188"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[F?. kund.nr]]></text>

</staticText>

<textField isStretchWithOverflow="false" pattern=" #0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="0"

y="18"

width="45"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1269"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.Double"><![CDATA[$F{STORE_ID}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="45"

y="18"

width="96"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1269"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{MARKETING_NAME}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" pattern=" #0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="141"

y="18"

width="63"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1269"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.Double"><![CDATA[$F{CUSTOMER_NUMBER}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" pattern=" #0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="204"

y="18"

width="69"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1269"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.Double"><![CDATA[$F{PAST_CUSTOMER_NUMBER}]]></textFieldExpression>

</textField>

<staticText>

<reportElement

mode="Transparent"

x="283"

y="3"

width="64"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1188"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[M审d]]></text>

</staticText>

<staticText>

<reportElement

mode="Transparent"

x="347"

y="3"

width="50"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1188"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Akt. må®]></text>

</staticText>

<staticText>

<reportElement

mode="Transparent"

x="397"

y="3"

width="70"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1188"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[F?. må®]></text>

</staticText>

<staticText>

<reportElement

mode="Transparent"

x="467"

y="3"

width="37"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1188"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Diff.]]></text>

</staticText>

<staticText>

<reportElement

mode="Transparent"

x="504"

y="3"

width="31"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1188"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Diff. %]]></text>

</staticText>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="347"

y="30"

width="15"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-79"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[($P{ReturnedValuesMap}.put("RETURNED_PRESENT_TURNOVER_VALUE","0") == null)?Boolean.FALSE:Boolean.FALSE]]></printWhenExpression>

</reportElement>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</line>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="397"

y="30"

width="15"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-79"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[($P{ReturnedValuesMap}.put("RETURNED_PAST_TURNOVER_VALUE","0") == null)?Boolean.FALSE:Boolean.FALSE]]></printWhenExpression>

</reportElement>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</line>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="467"

y="30"

width="15"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-79"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false">

<printWhenExpression><![CDATA[($P{ReturnedValuesMap}.put("RETURNED_DIFFERENCE_TURNOVER_VALUE","0") == null)?Boolean.FALSE:Boolean.FALSE]]></printWhenExpression>

</reportElement>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</line>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="0"

y="2"

width="535"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-108"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</line>

</band>

</groupHeader>

<groupFooter>

<band height="62" isSplitAllowed="true" >

<textField isStretchWithOverflow="false" pattern=" #,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Opaque"

x="156"

y="2"

width="258"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-19"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.Double"><![CDATA[new Double($P{ReturnedValuesMap}.get("RETURNED_PRESENT_TURNOVER_VALUE").toString())]]></textFieldExpression>

</textField>

<staticText>

<reportElement

mode="Opaque"

x="0"

y="2"

width="156"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-72"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Total omsä´´ning f?kt 12 må®®]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="0"

y="17"

width="156"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-72"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Total omsä´´ning f??. 12 må®®]]></text>

</staticText>

<textField isStretchWithOverflow="false" pattern=" #,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Opaque"

x="156"

y="17"

width="258"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-19"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.Double"><![CDATA[new Double($P{ReturnedValuesMap}.get("RETURNED_PAST_TURNOVER_VALUE").toString())]]></textFieldExpression>

</textField>

<staticText>

<reportElement

mode="Opaque"

x="0"

y="32"

width="156"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-72"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Total differens]]></text>

</staticText>

<textField isStretchWithOverflow="false" pattern=" #,##0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Opaque"

x="156"

y="32"

width="258"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-19"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.Double"><![CDATA[new Double($P{ReturnedValuesMap}.get("RETURNED_DIFFERENCE_TURNOVER_VALUE").toString())]]></textFieldExpression>

</textField>

<staticText>

<reportElement

mode="Opaque"

x="0"

y="47"

width="157"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-72"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Total procentuell differens (%)]]></text>

</staticText>

<textField isStretchWithOverflow="false" pattern=" #,##0.0" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Opaque"

x="157"

y="47"

width="258"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-19"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.Double"><![CDATA[new Double((((new Double(($P{ReturnedValuesMap}.get("RETURNED_DIFFERENCE_TURNOVER_VALUE")).toString())).doubleValue())/((new Double(($P{ReturnedValuesMap}.get("RETURNED_PAST_TURNOVER_VALUE")).toString())).doubleValue()))*100)]]></textFieldExpression>

</textField>

<line direction="TopDown">

<reportElement

mode="Opaque"

x="0"

y="1"

width="535"

height="0"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-108"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</line>

</band>

</groupFooter>

</group>

<group name="MONTH_TURNOVER" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0" >

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

<groupHeader>

<band height="18" isSplitAllowed="true" >

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Opaque"

x="281"

y="0"

width="56"

height="18"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1276"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[(new String(($F{PRESENT}).toString())).substring(0,10)]]></textFieldExpression>

</textField>

<subreport isUsingCache="true">

<reportElement

mode="Opaque"

x="338"

y="0"

width="197"

height="17"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-1374"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<subreportParameter name="PRESENT">

<subreportParameterExpression><![CDATA[(new String(($F{PRESENT}).toString())).substring(0,10)]]></subreportParameterExpression>

</subreportParameter>

<subreportParameter name="ReturnedValuesMap">

<subreportParameterExpression><![CDATA[$P{ReturnedValuesMap}]]></subreportParameterExpression>

</subreportParameter>

<subreportParameter name="STORE_ID">

<subreportParameterExpression><![CDATA[$F{STORE_ID}]]></subreportParameterExpression>

</subreportParameter>

<subreportParameter name="CUSTOMER_NUMBER">

<subreportParameterExpression><![CDATA[$F{CUSTOMER_NUMBER}]]></subreportParameterExpression>

</subreportParameter>

<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>

<subreportExpression class="java.lang.String"><![CDATA["C:/Documents and Settings/h00hah/Desktop/rapporter/ireport/Turnover_reportAR013_monthcalc.jasper"]]></subreportExpression>

</subreport>

</band>

</groupHeader>

<groupFooter>

<band height="0" isSplitAllowed="true" >

</band>

</groupFooter>

</group>

<background>

<band height="0" isSplitAllowed="true" >

</band>

</background>

<title>

<band height="95" isSplitAllowed="true" >

<rectangle radius="0" >

<reportElement

mode="Opaque"

x="1"

y="1"

width="535"

height="31"

forecolor="#000000"

backcolor="#FF0000"

key="element-603"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<graphicElement stretchType="NoStretch" pen="Thin" fill="Solid" />

</rectangle>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="323"

y="7"

width="211"

height="22"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-604"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="18" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$P{Logo}]]></textFieldExpression>

</textField>

<staticText>

<reportElement

mode="Opaque"

x="304"

y="33"

width="127"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-628"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<text><![CDATA[Valt datum]]></text>

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="161"

y="33"

width="138"

height="16"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-628"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

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

</staticText>

<staticText>

<reportElement

mode="Opaque"

x="1"

y="33"

width="138"

height="15"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-628"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

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

</staticText>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Opaque"

x="1"

y="48"

width="138"

height="28"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-633"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$P{Title}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Opaque"

x="439"

y="33"

width="95"

height="15"

forecolor="#CCCCCC"

backcolor="#FFFFFF"

key="element-713"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

<textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single">

<font fontName="Arial" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="Cp1252" isStrikeThrough="false" />

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$P{CopyRight}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" > <reportElement

mode="Transparent"

x="3"

y="7"

width="209"

height="19"

forecolor="#000000"

backcolor="#FFFFFF"

key="element-381"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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

×
×
  • Create New...