sicura_1.7.x/sicura.web/WebContent/Reports/repAggregazioneDelegheSeda.jrxml

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.3.final utlizzo versione della libreria JasperReports6.4.3  -->
<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="repAggregazioneDelegheSeda" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="557b191f-b468-4354-a666-133b708c1f75">
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
	<parameter name="rangeEstrazione" class="java.lang.String"/>
	<queryString>
		<![CDATA[]]>
	</queryString>
	<field name="statoAllineamento" class="java.lang.String">
		<fieldDescription><![CDATA[statoAllineamento]]></fieldDescription>
	</field>
	<field name="numeroMandati" class="java.lang.Integer">
		<fieldDescription><![CDATA[numeroMandati]]></fieldDescription>
	</field>
	<field name="abi" class="java.lang.String">
		<fieldDescription><![CDATA[abi]]></fieldDescription>
	</field>
	<field name="class" class="java.lang.Class">
		<fieldDescription><![CDATA[class]]></fieldDescription>
	</field>
	<field name="banca" class="java.lang.String">
		<fieldDescription><![CDATA[banca]]></fieldDescription>
	</field>
	<variable name="numeroMandati1" class="java.lang.Integer" resetType="Group" resetGroup="statoAllienamento" calculation="Sum">
		<variableExpression><![CDATA[$F{numeroMandati}]]></variableExpression>
	</variable>
	<variable name="numeroMandati2" class="java.lang.Integer" calculation="Sum">
		<variableExpression><![CDATA[$F{numeroMandati}]]></variableExpression>
	</variable>
	<group name="statoAllienamento">
		<groupExpression><![CDATA[$F{abi}]]></groupExpression>
		<groupHeader>
			<band height="24">
				<textField>
					<reportElement x="0" y="4" width="50" height="20" uuid="c1837766-d7e4-4aa8-a043-7d0727d2d61b"/>
					<textElement textAlignment="Center" verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[$F{abi}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="70" y="4" width="240" height="20" uuid="a0054941-cb42-4e7d-bf68-fff7cc2165a3"/>
					<textElement textAlignment="Left" verticalAlignment="Middle"/>
					<textFieldExpression><![CDATA[$F{banca}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="32">
				<textField pattern="#,##0.###">
					<reportElement x="434" y="3" width="100" height="20" uuid="5c8c464c-9aaf-4d51-87d8-226e8d70b327"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{numeroMandati1}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement x="2" y="26" width="550" height="1" uuid="098a8fc7-b393-42a9-9da3-f55ff25e8d99">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
				</line>
				<line>
					<reportElement x="283" y="3" width="269" height="1" uuid="bf068b78-3296-4b76-b99b-fe5f77eed1c0">
						<property name="com.jaspersoft.studio.unit.height" value="px"/>
					</reportElement>
				</line>
				<staticText>
					<reportElement x="330" y="5" width="110" height="20" uuid="f25ed39c-67cf-4343-822e-6ec10b7e5da9"/>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="SansSerif" size="10" isBold="true"/>
					</textElement>
					<text><![CDATA[Totale:]]></text>
				</staticText>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="79" splitType="Stretch">
			<rectangle radius="4">
				<reportElement stretchType="ContainerHeight" x="-1" y="-2" width="552" height="74" uuid="21f80411-8f0d-4403-9be9-0ae24391af89"/>
			</rectangle>
			<staticText>
				<reportElement x="2" y="3" width="338" height="41" uuid="16e30aad-a679-4ca3-81b6-93bdb0a6ac34"/>
				<textElement verticalAlignment="Middle">
					<font fontName="SansSerif" size="18" isBold="true" isItalic="true"/>
				</textElement>
				<text><![CDATA[Totale Mandati SEDA per Banca]]></text>
			</staticText>
			<staticText>
				<reportElement x="356" y="23" width="191" height="21" uuid="988281ed-a0f5-4642-8ca4-95399ee821f8"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="SansSerif"/>
				</textElement>
				<text><![CDATA[SICURA - Pagamenti e Incassi Telematici]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="2" y="44" width="281" height="19" uuid="74790bce-609f-4fa8-baeb-3e642cbfab4e"/>
				<textElement verticalAlignment="Middle" markup="none"/>
				<textFieldExpression><![CDATA[$P{rangeEstrazione}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy HH:mm">
				<reportElement x="356" y="3" width="190" height="20" uuid="6fc732bd-4819-4f38-85ef-d244d8f6d8c1"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<columnHeader>
		<band height="35" splitType="Stretch">
			<rectangle>
				<reportElement x="0" y="5" width="551" height="25" backcolor="#E0E0E0" uuid="5717492b-9710-47be-9032-635d9b8dffc9"/>
			</rectangle>
			<staticText>
				<reportElement x="0" y="8" width="50" height="20" uuid="45829b66-4014-4ae1-b095-52052d7f4ade"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<text><![CDATA[ABI]]></text>
			</staticText>
			<staticText>
				<reportElement x="70" y="7" width="240" height="20" uuid="4e5e8b30-ecde-41a0-b2be-3a9193a39c36"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<text><![CDATA[Denominazione banca]]></text>
			</staticText>
			<staticText>
				<reportElement x="310" y="8" width="130" height="20" uuid="9f658f1f-7794-40d6-ad58-9763ad76bdc9"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<text><![CDATA[Stato deleghe]]></text>
			</staticText>
			<staticText>
				<reportElement x="440" y="8" width="105" height="20" uuid="4fb60a5a-c88f-41f8-be45-e4e690f12daa"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" isBold="true"/>
				</textElement>
				<text><![CDATA[N. Mandati]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="21" splitType="Stretch">
			<textField>
				<reportElement x="310" y="1" width="130" height="20" uuid="a2ded080-09bf-45ce-bd40-a85afba0f402"/>
				<textElement textAlignment="Left" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA["" + 
IF(EQUALS($F{statoAllineamento},"0"),"In attesa di esito","")+
IF(EQUALS($F{statoAllineamento},"1"),"Attive","")+
IF(EQUALS($F{statoAllineamento},"2"),"Non attive","")+
IF(EQUALS($F{statoAllineamento},"6"),"Attivate SDD","")]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.###">
				<reportElement x="450" y="1" width="84" height="20" uuid="d1cd8674-c2af-40eb-8380-0347b92f4d17"/>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$F{numeroMandati}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="42" splitType="Stretch">
			<textField evaluationTime="Report">
				<reportElement x="260" y="12" width="100" height="30" uuid="fdb19018-9df6-42a5-a745-58166c1d5b2e"/>
				<textElement textAlignment="Left">
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression><![CDATA[" di " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="160" y="12" width="100" height="30" uuid="33047c6b-ba70-474b-9452-73aef6e81dd4"/>
				<textElement textAlignment="Right">
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression><![CDATA["Pagina " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="31" splitType="Stretch">
			<textField pattern="#,##0.###">
				<reportElement x="410" y="10" width="124" height="20" uuid="3247a4ba-d155-41a4-873a-01f6a081c5e2"/>
				<textElement textAlignment="Right">
					<font size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{numeroMandati2}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="310" y="11" width="100" height="20" uuid="97681d9a-2165-415d-a500-5e5116a00c93"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Totale mandati:]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>