ktalarico Posted September 21, 2012 Share Posted September 21, 2012 I am trying to prevent crosstab header from repeating when exporting to csv.I've tried the following (replacing "suffix" with group, band, report or crosstab): <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.suffix.crosstabColumnHeader" value="crosstabColumnHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.suffix.crosstabHeaderCell" value="crosstabHeaderCell"/> I'm not sure what to supply for a suffix or if this option exists. I'm not also sure if I've provided the correct values.Any help is appreciated!<?xml version="1.0" encoding="UTF-8"?> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="payroll_report_STD" pageWidth="792" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="754" leftMargin="19" rightMargin="19" topMargin="20" bottomMargin="20"> <property name="ireport.scriptlethandling" value="0"/> <property name="ireport.encoding" value="UTF-8"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.crosstab.crosstabColumnHeader" value="crosstabColumnHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.keep.first.crosstab.crosstabHeaderCell" value="crosstabHeaderCell"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.columnFooter" value="columnFooter"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.pageHeader" value="pageHeader"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.pageFooter" value="pageFooter"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.title" value="title"/> <property name="net.sf.jasperreports.export.csv.exclude.origin.band.lastPageFooter" value="lastPageFooter"/> <import value="net.sf.jasperreports.engine.*"/> <import value="java.util.*"/> <import value="net.sf.jasperreports.engine.data.*"/> <style name="Column Heading" isDefault="false" backcolor="#B0B0FF" vAlign="Middle" isBold="true"> <box leftPadding="3"/> </style> <style name="Text Field" isDefault="false" vAlign="Middle" isBlankWhenNull="true"> <box leftPadding="3"/> </style> <style name="Report Title" isDefault="false" hAlign="Right" vAlign="Middle" fontName="Arial" fontSize="18" isBold="false"/> <style name="Report Header" isDefault="false" vAlign="Middle" fontSize="12" isBold="true"/> <style name="Group Header" isDefault="false" vAlign="Middle" isBlankWhenNull="true" fontSize="14" isBold="true"/> <style name="Crosstab Data Text" isDefault="false" hAlign="Center"/> <parameter name="p_site_id" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["DAL"]]></defaultValueExpression> </parameter> <parameter name="p_pay_period" class="java.lang.String"> <parameterDescription><![CDATA[<DN>Pay period</DN><LOV>select distinct to_char(start_date,'DD-MON-YY') || ' - ' || to_char(end_date,'DD-MON-YY') START_CH, start_date START_DT from pay_period where customer_department_id='$P!{p_customer_department_id}' order by start_dt desc</LOV>]]></parameterDescription> <defaultValueExpression><![CDATA["16-JUN-11 - 30-JUN-11"]]></defaultValueExpression> </parameter> <parameter name="p_noop" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["1=1"]]></defaultValueExpression> </parameter> <parameter name="p_root_path" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["."]]></defaultValueExpression> </parameter> <parameter name="p_customer_department_id" class="java.lang.String" isForPrompting="false"> <parameterDescription><![CDATA[]]></parameterDescription> <defaultValueExpression><![CDATA["SWADI"]]></defaultValueExpression> </parameter> <parameter name="P_CURRENT_DATE" class="java.lang.String" isForPrompting="false"/> <parameter name="p_worker_type" class="java.util.Collection"> <parameterDescription><![CDATA[<DN>Worker type</DN><LOV>select 'ALL' type, 1 dummy from dual union select employee_type_code type, 2 dummy from employee_type where customer_department_id = '$P!{p_customer_department_id}' and status='A' and employee_type_code <> 'NR' order by dummy,type</LOV>]]></parameterDescription> <defaultValueExpression><![CDATA[Arrays.asList(new String[] {"ALL"})]]></defaultValueExpression> </parameter> <parameter name="p_worker_type_string" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[($P{p_worker_type}).toString().replaceAll("[\[\]]", "'").replaceAll(", ", "', '")]]></defaultValueExpression> </parameter> <parameter name="p_worker_type_query_string" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["pr.work_type in (" + $P{p_worker_type_string} + ")"]]></defaultValueExpression> </parameter> <parameter name="p_worker_type_where_clause" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[($P{p_worker_type_string}).matches("'ALL'") ? $P{p_noop} : $P{p_worker_type_query_string}]]></defaultValueExpression> </parameter> <parameter name="p_worker_type_string_1" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[($P{p_worker_type}).toString().replaceAll("[\[\]]", "")]]></defaultValueExpression> </parameter> <parameter name="p_emp_name" class="java.util.Collection"> <parameterDescription><![CDATA[<DN>Worker name</DN><LOV>select 'ALL' name, 1 dummy from dual union select ed.last_name || ' ' || ed.first_name || ' ' || ed.middle_name name, 2 dummy from employee_detail ed, employee e where ed.is_fake = 'N' and e.employee_status_code = 'A' and e.employee_id = ed.employee_id and e.customer_department_id = '$P!{p_customer_department_id}' order by dummy</LOV>]]></parameterDescription> <defaultValueExpression><![CDATA[Arrays.asList(new String[] {"ALL"})]]></defaultValueExpression> </parameter> <parameter name="p_emp_name_string" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[($P{p_emp_name}).toString().replaceAll("[\[\]]", "'").replaceAll(", ", "', '")]]></defaultValueExpression> </parameter> <parameter name="p_emp_name_string_1" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[($P{p_emp_name}).toString().replaceAll("[\[\]]", " ")]]></defaultValueExpression> </parameter> <parameter name="p_emp_name_query_string" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[" ed.last_name || ' ' || ed.first_name || ' ' || ed.middle_name in (" + $P{p_emp_name_string} + ")"]]></defaultValueExpression> </parameter> <parameter name="p_emp_name_where_clause" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA[($P{p_emp_name_string}).matches("'ALL'") ? $P{p_noop} : $P{p_emp_name_query_string}]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECT --the nvl2 serves the purpose of eliminating the empty name row in crosstab with all zeros (lumps the null pay codes into another worker's row) nvl2(ed.last_name,ed.last_name || ', ' || ed.first_name || ' ' || ed.middle_name, (select last_name || ', ' || first_name || ' ' || middle_name from employee_detail q where rownum=1 and EXISTS (SELECT 'X' FROM payroll_report_view WHERE WORKER_ID=Q.EMPLOYEE_ID AND PAY_PERIOD = '$P!{p_pay_period}'))) NAME, nvl2(ed.alt_employee_id,ed.alt_employee_id,(select alt_employee_id from employee_detail q where rownum=1 and EXISTS (SELECT 'X' FROM payroll_report_view WHERE WORKER_ID=Q.EMPLOYEE_ID AND PAY_PERIOD = '$P!{p_pay_period}'))) WORKER_ID, nvl2(pr.work_type,pr.work_type,(select employee_type_code from employee q where rownum=1 and EXISTS (SELECT 'X' FROM payroll_report_view WHERE WORKER_ID=Q.EMPLOYEE_ID AND PAY_PERIOD = '$P!{p_pay_period}'))) WORK_TYPE, pr.pay_code PAY_CODE, pr.pc, pr.pay_rate PAY_RATE, decode(pr.pay_rate,0,pr.hours,null,pr.hours,(pr.hours*pr.pay_rate)) HOURS FROM --begin inline view (SELECT pc.pay_code PC, pc.external_code || chr(13) || ' (' || pc.pay_code || ')' || chr(13) || pc.description PAY_CODE, pr.hours HOURS, pr.worker_id, pr.work_type, pr.pay_period, pc.pay_rate FROM payroll_report_view pr, pay_code pc WHERE pr.pay_code_id (+) =pc.pay_code_id AND pr.pay_period (+) = '$P!{p_pay_period}' and $P!{p_worker_type_where_clause}) PR, --end inline view --begin inline view employee_detail ed --end inline view where pr.worker_id = ed.employee_id (+) and ed.is_fake (+) = 'N' and $P!{p_emp_name_where_clause} --begin pay code filter and (CASE WHEN EXISTS (SELECT 'X' FROM ARIS_REPORT_MANAGER_PARAMETER WHERE property_name='EXCLUDE-PAY-CODES' and report_name='payroll_report_STD' and customer_department_id = '$P!{p_customer_department_id}') and pr.pc not in (select regexp_substr(string_value,'[^ ]+', 1, level) from aris_report_manager_parameter where property_name='EXCLUDE-PAY-CODES' and report_name='payroll_report_STD' and customer_department_id = '$P!{p_customer_department_id}' connect by regexp_substr(string_value, '[^ ]+', 1, level) is not null) THEN 1 WHEN NOT EXISTS (SELECT 'X' FROM ARIS_REPORT_MANAGER_PARAMETER WHERE property_name='EXCLUDE-PAY-CODES' and report_name='payroll_report_STD' and customer_department_id = '$P!{p_customer_department_id}') THEN 1 ELSE 0 END) = 1 --end pay code filter ORDER BY NAME, work_type, pr.pay_code]]> </queryString> <field name="NAME" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="WORKER_ID" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="WORK_TYPE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PAY_CODE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PC" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PAY_RATE" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="HOURS" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <group name="DUMMY"> <groupFooter> <band height="50"> <crosstab> <reportElement x="0" y="0" width="754" height="50"/> <crosstabDataset isDataPreSorted="true"> <dataset resetType="None"/> </crosstabDataset> <crosstabHeaderCell> <cellContents> <box> <topPen lineWidth="0.25"/> </box> <staticText> <reportElement style="Crosstab Data Text" stretchType="RelativeToTallestObject" x="0" y="0" width="100" height="62"/> <box topPadding="2" leftPadding="3"> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Left" markup="none"/> <text><![CDATA[Name]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" stretchType="RelativeToTallestObject" x="100" y="0" width="65" height="62"/> <box topPadding="2" leftPadding="3"> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Left" markup="none"/> <text><![CDATA[iD]]></text> </staticText> <staticText> <reportElement style="Crosstab Data Text" stretchType="RelativeToTallestObject" x="165" y="0" width="55" height="62"/> <box topPadding="2" leftPadding="3"> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Left" markup="none"/> <text><![CDATA[Worker Type]]></text> </staticText> </cellContents> </crosstabHeaderCell> <rowGroup name="NAME" width="100" totalPosition="End"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{NAME}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField isBlankWhenNull="true"> <reportElement style="Crosstab Data Text" x="0" y="0" width="100" height="25"/> <box topPadding="2" leftPadding="3"/> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.String"><![CDATA[$V{NAME}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement x="0" y="0" width="100" height="25"/> <box leftPadding="3"> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[Total]]></text> </staticText> </cellContents> </crosstabTotalRowHeader> </rowGroup> <rowGroup name="WORKER_ID" width="65"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{WORKER_ID}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textField isBlankWhenNull="true"> <reportElement style="Crosstab Data Text" x="0" y="0" width="65" height="25"/> <box topPadding="2" leftPadding="3"/> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.String"><![CDATA[$V{WORKER_ID}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents> <staticText> <reportElement x="100" y="87" width="65" height="25"/> <box leftPadding="3"> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[]]></text> </staticText> </cellContents> </crosstabTotalRowHeader> </rowGroup> <rowGroup name="WORK_TYPE" width="55"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{WORK_TYPE}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents> <box> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textField isBlankWhenNull="true"> <reportElement style="Crosstab Data Text" x="0" y="0" width="55" height="25" isRemoveLineWhenBlank="true"/> <box topPadding="2" leftPadding="3"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$V{WORK_TYPE}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents> <staticText> <reportElement x="165" y="87" width="55" height="25"/> <box leftPadding="3"> <pen lineWidth="0.25"/> <topPen lineWidth="0.25"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"/> <text><![CDATA[]]></text> </staticText> </cellContents> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="PAY_CODE" height="62"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{PAY_CODE}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField isStretchWithOverflow="true"> <reportElement style="Crosstab Data Text" stretchType="RelativeToTallestObject" x="0" y="0" width="53" height="62"/> <box topPadding="2" leftPadding="1" rightPadding="3"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$V{PAY_CODE}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents/> </crosstabTotalColumnHeader> </columnGroup> <measure name="HOURSMeasure" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{HOURS}]]></measureExpression> </measure> <measure name="PCmeasure" class="java.lang.String"> <measureExpression><![CDATA[$F{PC}]]></measureExpression> </measure> <measure name="PAY_RATEmeasure" class="java.math.BigDecimal"> <measureExpression><![CDATA[$F{PAY_RATE}]]></measureExpression> </measure> <crosstabCell width="53" height="25"> <cellContents> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField isBlankWhenNull="true"> <reportElement style="Crosstab Data Text" x="0" y="0" width="53" height="25"/> <box topPadding="2"/> <textElement/> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{HOURSMeasure}]]></textFieldExpression> </textField> <staticText> <reportElement style="Crosstab Data Text" x="0" y="0" width="15" height="25"> <printWhenExpression><![CDATA[boolean.valueOf($V{PAY_RATEmeasure}.intValue()>0)]]></printWhenExpression> </reportElement> <box topPadding="2" leftPadding="2"/> <textElement textAlignment="Left"/> <text><![CDATA[$]]></text> </staticText> </cellContents> </crosstabCell> <crosstabCell width="53" height="25" rowTotalGroup="NAME"> <cellContents backcolor="#FFFFFF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="53" height="25"/> <box topPadding="2"/> <textElement/> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{HOURSMeasure}]]></textFieldExpression> </textField> <staticText> <reportElement style="Crosstab Data Text" x="0" y="0" width="15" height="25"> <printWhenExpression><![CDATA[boolean.valueOf($V{PAY_RATEmeasure}.intValue()>0)]]></printWhenExpression> </reportElement> <box topPadding="2" leftPadding="2"/> <textElement textAlignment="Left"/> <text><![CDATA[$]]></text> </staticText> </cellContents> </crosstabCell> <crosstabCell width="45" columnTotalGroup="PAY_CODE"> <cellContents backcolor="#FFE4BF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="45" height="25"/> <textElement/> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{HOURSMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell rowTotalGroup="NAME" columnTotalGroup="PAY_CODE"> <cellContents backcolor="#FFE4BF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="45" height="25"/> <textElement/> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{HOURSMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell rowTotalGroup="WORKER_ID"> <cellContents/> </crosstabCell> <crosstabCell rowTotalGroup="WORKER_ID" columnTotalGroup="PAY_CODE"> <cellContents/> </crosstabCell> <crosstabCell rowTotalGroup="WORK_TYPE"> <cellContents/> </crosstabCell> <crosstabCell rowTotalGroup="WORK_TYPE" columnTotalGroup="PAY_CODE"> <cellContents/> </crosstabCell> </crosstab> </band> </groupFooter> </group> <background> <band splitType="Stretch"/> </background> <title> <band height="63" splitType="Stretch"> <image scaleImage="FillFrame" hAlign="Left" vAlign="Top" isUsingCache="true"> <reportElement key="image-1" positionType="Float" mode="Opaque" x="0" y="0" width="754" height="63" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <graphicElement fill="Solid"> <pen lineWidth="0.0" lineStyle="Solid"/> </graphicElement> <imageExpression class="java.lang.String"><![CDATA[$P{p_root_path} + "/images/report-header-landscape.gif"]]></imageExpression> </image> <staticText> <reportElement key="staticText-12" x="442" y="15" width="312" height="25"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="18" isBold="true" pdfFontName="Helvetica-Bold"/> </textElement> <text><![CDATA[Payroll report]]></text> </staticText> <staticText> <reportElement key="staticText-17" positionType="Float" mode="Transparent" x="590" y="49" width="52" height="9" forecolor="#FFE382" backcolor="#CCCCCC"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <text><![CDATA[Report run on: ]]></text> </staticText> <textField pattern="" isBlankWhenNull="false"> <reportElement key="textField-12" positionType="Float" mode="Transparent" x="646" y="49" width="106" height="9" isPrintWhenDetailOverflows="true" forecolor="#CCCCCC" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{P_CURRENT_DATE}]]></textFieldExpression> </textField> <subreport isUsingCache="true"> <reportElement key="subreport-2" x="0" y="0" width="125" height="43"/> <subreportParameter name="p_customer_department_id"> <subreportParameterExpression><![CDATA[$P{p_customer_department_id}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{p_root_path} + "/report_logo.jasper"]]></subreportExpression> </subreport> </band> </title> <pageHeader> <band height="30" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="754" height="30"/> <textElement> <font size="12" isBold="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Payroll for pay period " + $P{p_pay_period} + ", worker type " + $P{p_worker_type_string_1} + ", worker " + $P{p_emp_name_string_1}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band splitType="Stretch"/> </columnHeader> <detail> <band splitType="Prevent"/> </detail> <columnFooter> <band splitType="Stretch"/> </columnFooter> <pageFooter> <band height="22" splitType="Stretch"> <staticText> <reportElement key="staticText-7" positionType="Float" mode="Transparent" x="653" y="10" width="29" height="12" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <text><![CDATA[Page]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false"> <reportElement key="textField-7" positionType="Float" mode="Transparent" x="685" y="10" width="24" height="12" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Bottom" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> <staticText> <reportElement key="staticText-8" positionType="Float" mode="Transparent" x="709" y="10" width="18" height="12" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <text><![CDATA[of]]></text> </staticText> <textField evaluationTime="Report" pattern="" isBlankWhenNull="false"> <reportElement key="textField-8" positionType="Float" mode="Transparent" x="728" y="10" width="24" height="12" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Bottom" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <lastPageFooter> <band height="20" splitType="Stretch"> <staticText> <reportElement key="staticText-16" positionType="Float" mode="Transparent" x="0" y="8" width="188" height="12" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <text><![CDATA[Version 20120921]]></text> </staticText> <staticText> <reportElement key="staticText-18" positionType="Float" mode="Transparent" x="653" y="8" width="29" height="12" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <text><![CDATA[Page]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false"> <reportElement key="textField-13" positionType="Float" mode="Transparent" x="685" y="8" width="24" height="12" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Bottom" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> <staticText> <reportElement key="staticText-19" positionType="Float" mode="Transparent" x="709" y="8" width="18" height="12" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Top" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <text><![CDATA[of]]></text> </staticText> <textField evaluationTime="Report" pattern="" isBlankWhenNull="false"> <reportElement key="textField-14" positionType="Float" mode="Transparent" x="728" y="8" width="24" height="12" forecolor="#000000" backcolor="#FFFFFF"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Bottom" rotation="None" lineSpacing="Single"> <font fontName="Arial" size="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </lastPageFooter> <summary> <band height="100" splitType="Stretch"> <subreport> <reportElement x="0" y="0" width="754" height="50"/> <subreportParameter name="p_customer_department_id"> <subreportParameterExpression><![CDATA[$P{p_customer_department_id}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="p_emp_name"> <subreportParameterExpression><![CDATA[$P{p_emp_name}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="p_pay_period"> <subreportParameterExpression><![CDATA[$P{p_pay_period}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="p_worker_type"> <subreportParameterExpression><![CDATA[$P{p_worker_type}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{p_root_path} + "/payroll_STD_subreport0.jasper"]]></subreportExpression> </subreport> <subreport> <reportElement x="0" y="50" width="754" height="50"/> <subreportParameter name="p_customer_department_id"> <subreportParameterExpression><![CDATA[$P{p_customer_department_id}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="p_emp_name"> <subreportParameterExpression><![CDATA[$P{p_emp_name}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="p_pay_period"> <subreportParameterExpression><![CDATA[$P{p_pay_period}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="p_worker_type"> <subreportParameterExpression><![CDATA[$P{p_worker_type}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{p_root_path} + "/payroll_STD_subreport1.jasper"]]></subreportExpression> </subreport> </band> </summary> <noData> <band height="30" splitType="Stretch"> <staticText> <reportElement key="staticText-15" x="0" y="11" width="754" height="19"> <printWhenExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()==0)]]></printWhenExpression> </reportElement> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center"> <font size="12"/> </textElement> <text><![CDATA[No data was retrieved; please check your report selections.]]></text> </staticText> </band> </noData> </jasperReport> 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