2004 IR Help Posted September 2, 2006 Share Posted September 2, 2006 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now