<?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="rtpClaseGasto" language="groovy" columnDirection="RTL" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="748" leftMargin="24" rightMargin="20" topMargin="20" bottomMargin="20" uuid="3d9f3a11-043f-4a27-9087-bd5ed7133799">
<property name="ireport.zoom" value="2.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<property name="ireport.jasperserver.reportUnit" value="/reports/SISAP/rptLibroDiarioLinea_2_1"/>
<property name="ireport.jasperserver.url" value="http://172.16.13.12:8080/jasperserver/services/repository"/>
<style name="style1">
<conditionalStyle>
<style/>
</conditionalStyle>
</style>
<subDataset name="libroDiario" uuid="b79cb7c0-521e-4951-b21a-40a8f01b7ae2">
<parameter name="fecIni" class="java.util.Date"/>
<parameter name="fecFin" class="java.util.Date"/>
<parameter name="idLinea" class="java.lang.Integer"/>
<queryString>
<![CDATA[SELECT c...]]>
</queryString>
<field name="id_coe" class="java.lang.Integer">
<fieldDescription><![CDATA[Cor...]]></fieldDescription>
</field>
<field name="glosa" class="java.lang.String">
<fieldDescription><![CDATA[Glo..o]]></fieldDescription>
</field>
<field name="descripcion" class="java.lang.String"/>
<field name="fecha_comprobante" class="java.sql.Date">
<fieldDescription><![CDATA[Fe..]]></fieldDescription>
</field>
<field name="codigo_comp" class="java.lang.String">
<fieldDescription><![CDATA[Có...]]></fieldDescription>
</field>
<field name="nombre" class="java.lang.String"/>
</subDataset>
<subDataset name="libroDiario2" uuid="49afba33-34fe-4d5b-9ad8-e7ef433e92c3">
<parameter name="id_ce" class="java.lang.Integer"/>
<queryString>
<![CDATA[select pc.cod...]]>
</queryString>
<field name="codigo_cuenta" class="java.lang.String">
<fieldDescription><![CDATA[Có...]]></fieldDescription>
</field>
<field name="descripcion" class="java.lang.String"/>
<field name="glosa_detalle" class="java.lang.String">
<fieldDescription><![CDATA[Glo...]]></fieldDescription>
</field>
<field name="tipo_cambio" class="java.lang.String">
<fieldDescription><![CDATA[E...]]></fieldDescription>
</field>
<field name="debe_me" class="java.math.BigDecimal">
<fieldDescription><![CDATA[E...]]></fieldDescription>
</field>
<field name="haber_me" class="java.math.BigDecimal">
<fieldDescription><![CDATA[E...]]></fieldDescription>
</field>
<field name="debe_ml" class="java.math.BigDecimal">
<fieldDescription><![CDATA[E...]]></fieldDescription>
</field>
<field name="haber_ml" class="java.math.BigDecimal">
<fieldDescription><![CDATA[E..]]></fieldDescription>
</field>
</subDataset>
<subDataset name="libroDiarioDetalle" uuid="4935fd90-2040-4fa0-96e0-fd329084b27e">
<parameter name="id_c" class="java.lang.Integer">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT
c.i..]]>
</queryString>
<field name="id_ce" class="java.lang.Integer">
<fieldDescription><![CDATA[Co..]]></fieldDescription>
</field>
<field name="glosa" class="java.lang.String">
<fieldDescription><![CDATA[...]]></fieldDescription>
</field>
<field name="descripcion" class="java.lang.String"/>
<field name="fecha_coe" class="java.sql.Date">
<fieldDescription><![CDATA[...]]></fieldDescription>
</field>
<field name="codigo_come" class="java.lang.String">
<fieldDescription><![CDATA[C...]]></fieldDescription>
</field>
<field name="nombre" class="java.lang.String"/>
</subDataset>
<subDataset name="libroDiario2totales" uuid="85773bda-a20a-4cda-9fdc-9c609760e84e">
<parameter name="id_c" class="java.lang.Integer">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select su...]]>
</queryString>
<field name="sum1" class="java.math.BigDecimal"/>
<field name="sum2" class="java.math.BigDecimal"/>
<field name="sum3" class="java.math.BigDecimal"/>
<field name="sum4" class="java.math.BigDecimal"/>
</subDataset>
<parameter name="fecIni" class="java.util.Date"/>
<parameter name="fecFin" class="java.util.Date"/>
<parameter name="idLinea" class="java.lang.Integer"/>
<parameter name="nombreLinea" class="java.lang.String"/>
<queryString>
<![CDATA[select g...]]>
</queryString>
<field name="gestion" class="java.lang.Integer"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="47" splitType="Stretch">
<staticText>
<reportElement x="345" y="2" width="64" height="11" uuid="02f22801-64d3-4024-91f1-7ed59b5b4bb0"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[LIBRO DIARIO]]></text>
</staticText>
<line>
<reportElement mode="Opaque" x="8" y="46" width="738" height="1" forecolor="#666666" uuid="e0e46ab6-efdd-4729-89d8-2b4c77bd66d6"/>
</line>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
<reportElement x="336" y="30" width="58" height="14" uuid="8cbc9e4c-1ecd-401a-bb8e-553cbb791dde"/>
<textElement>
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$P{fecIni}]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
<reportElement x="409" y="30" width="70" height="14" uuid="f66b3086-3aab-4052-b866-76ead10f6d49"/>
<textElement>
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$P{fecFin}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="313" y="30" width="23" height="14" uuid="b39ea9e7-c7aa-42ef-a94d-86d44a3c7edc"/>
<textElement>
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[Del]]></text>
</staticText>
<staticText>
<reportElement x="394" y="30" width="10" height="14" uuid="fdd163d4-e53a-4ddd-b146-b2fff83f30a8"/>
<textElement>
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[Al]]></text>
</staticText>
<textField>
<reportElement x="241" y="10" width="281" height="23" uuid="1775b852-0be0-4826-9aff-2bc2eb265dd4"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["....]]></textFieldExpression>
</textField>
<textField evaluationTime="Report" pattern="dd/MM/yyyy HH:mm:ss">
<reportElement x="660" y="22" width="84" height="10" uuid="2e6a703c-591f-4b3c-8dbd-9ee89c170736"/>
<textElement>
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[new Date()]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="660" y="13" width="32" height="9" uuid="4fe3a977-e524-49fe-90f4-0281df4a0b72"/>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="7" isBold="true"/>
</textElement>
<text><![CDATA[S.I.S.....]]></text>
</staticText>
</band>
</pageHeader>
<detail>
<band height="98" splitType="Stretch">
<componentElement>
<reportElement key="table" mode="Transparent" x="8" y="3" width="740" height="93" uuid="e90fcf19-883a-4226-a5be-9b33c0d65ed7"/>
<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail">
<datasetRun subDataset="libroDiario" uuid="682ee970-19a5-4421-b107-b5ecdc174966">
<datasetParameter name="fecIni">
<datasetParameterExpression><![CDATA[$P{fecIni}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="fecFin">
<datasetParameterExpression><![CDATA[$P{fecFin}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="idLinea">
<datasetParameterExpression><![CDATA[$P{id..}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:column width="750" uuid="3ae1c405-e049-45da-bee8-79571b902563">
<jr:detailCell height="93" rowSpan="1">
<componentElement>
<reportElement key="table" mode="Transparent" x="0" y="0" width="750" height="93" uuid="e907336c-0182-425e-8826-4119dde37446"/>
<jr:table whenNoDataType="AllSectionsNoDetail">
<datasetRun subDataset="libroDiario2" uuid="a935f37f-cdf3-43a0-92aa-6e986414c654">
<datasetParameter name="id_co">
<datasetParameterExpression><![CDATA[$F{id}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:columnGroup width="734" uuid="6c2e2f9e-44f6-4988-ae0e-447975d44476">
<jr:tableHeader height="44" rowSpan="1">
<componentElement>
<reportElement x="0" y="0" width="734" height="44" uuid="9eaedfbb-1687-41e8-9c9e-8e7edc26da1d"/>
<jr:list printOrder="Vertical" ignoreWidth="true">
<datasetRun subDataset="libroDiarioDetalle" uuid="b7155172-a713-49f1-bc74-d909200aac95">
<datasetParameter name="id_co">
<datasetParameterExpression><![CDATA[$P{id}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="44" width="734">
<textField>
<reportElement x="299" y="0" width="136" height="20" uuid="df54011f-84f9-4b71-be8d-8750c482d97a"/>
<textElement verticalAlignment="Middle">
<font size="7" isBold="true" isUnderline="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{cod}]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy">
<reportElement x="12" y="0" width="131" height="19" uuid="e615b38e-cb55-4ea4-b8d3-64af3be569d1"/>
<textElement verticalAlignment="Middle">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{fecha_comprobante}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="445" y="0" width="35" height="20" uuid="f79361a2-7059-48a5-93a8-19c488d01326"/>
<textElement verticalAlignment="Middle">
<font size="7" isBold="true"/>
</textElement>
<text><![CDATA[M.E.:]]></text>
</staticText>
<textField>
<reportElement x="480" y="0" width="250" height="20" uuid="631c7854-eee9-4dc5-becb-b3622ebf272a"/>
<textElement verticalAlignment="Middle">
<font size="7" isBold="true" isUnderline="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{nombre}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="5" y="19" width="40" height="20" uuid="7bafc62e-de69-4f12-9745-0707b932d4e0"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="7" isBold="true"/>
</textElement>
<text><![CDATA[ GLOSA:]]></text>
</staticText>
<textField>
<reportElement x="45" y="19" width="685" height="20" uuid="947cfbb7-2988-42db-ab5d-78f4601e962d"/>
<box>
<bottomPen lineWidth="0.0"/>
</box>
<textElement verticalAlignment="Middle">
<font size="8" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{glo}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</jr:tableHeader>
<jr:column width="90" uuid="0272decc-d6a9-46cf-9929-f01e4439d5b4">
<jr:columnHeader height="14" rowSpan="1">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="90" height="14" backcolor="#CCCCCC" uuid="5e9f3a5a-d109-41cb-b764-9f249705a300"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[CODIGO]]></text>
</staticText>
</jr:columnHeader>
<jr:columnFooter height="14" rowSpan="1"/>
<jr:detailCell height="15" rowSpan="1">
<textField>
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="90" height="15" uuid="b1fef7ee-bd89-4558-b072-63c7fc256f2a"/>
<box leftPadding="2">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement>
<font fontName="SansSerif" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{cod}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="259" uuid="2b6e694e-d9b0-4d2e-b640-a7f2a710e837">
<jr:columnHeader height="14" rowSpan="1">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="259" height="14" backcolor="#CCCCCC" uuid="3093b509-d57b-43ae-b1d3-55e4a7704095"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[DETALLE]]></text>
</staticText>
</jr:columnHeader>
<jr:columnFooter height="14" rowSpan="1"/>
<jr:detailCell height="15" rowSpan="1">
<textField>
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="259" height="15" uuid="3e000c5f-4d91-406e-a3fa-27825ed46ce6"/>
<box leftPadding="2">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement>
<font fontName="SansSerif" size="8" isUnderline="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{descripcion}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="51" uuid="efd24952-3c5c-413b-8497-cc3320448d7d">
<jr:columnHeader height="14" rowSpan="1">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="51" height="14" backcolor="#CCCCCC" uuid="bf0ef492-9be0-4b25-a7ba-ad042241d33b"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[T. C.]]></text>
</staticText>
</jr:columnHeader>
<jr:columnFooter height="14" rowSpan="1">
<staticText>
<reportElement x="0" y="0" width="51" height="14" uuid="83fcf396-29ce-4705-8699-1d98d9caee95"/>
<box rightPadding="5">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[TOTALES]]></text>
</staticText>
</jr:columnFooter>
<jr:detailCell height="15" rowSpan="1">
<textField pattern="">
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="51" height="15" uuid="47f89ec1-7e2b-40c0-8011-9829b43f8bc9"/>
<box rightPadding="5">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{tipo_cambio}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="80" uuid="3f9f94ad-d453-4978-80b3-1989cf2e2f21">
<jr:columnHeader height="14" rowSpan="1">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="80" height="14" backcolor="#CCCCCC" uuid="455b89a6-317e-4b44-b790-783a870e8e2a"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[DEBE M.E.]]></text>
</staticText>
</jr:columnHeader>
<jr:columnFooter height="14" rowSpan="1">
<componentElement>
<reportElement x="0" y="0" width="80" height="14" uuid="45d4467b-fb25-46b6-aff9-d633480efdce"/>
<jr:list printOrder="Vertical">
<datasetRun subDataset="libroDiario2totales" uuid="197739e8-d30b-47cf-8c2e-879a80d34d2b">
<datasetParameter name="id_c">
<datasetParameterExpression><![CDATA[$P{id_ce}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="14" width="80">
<textField isStretchWithOverflow="true" pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
<reportElement x="0" y="0" width="80" height="14" uuid="0aff68e8-475f-459b-9c69-a30cf81f93ab"/>
<box rightPadding="5">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{sum1}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</jr:columnFooter>
<jr:detailCell height="15" rowSpan="1">
<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="80" height="15" uuid="70404a5f-bf94-4d0b-83e8-d243bd6ac4b5"/>
<box rightPadding="5">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{debe_me}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="83" uuid="40c2ad19-e8e0-41ad-8f9a-e4de521f5faa">
<jr:columnHeader height="14" rowSpan="1">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="83" height="14" backcolor="#CCCCCC" uuid="9c79f41a-12bb-4a13-b86e-0e7e3acb934a"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[HABER M.E.]]></text>
</staticText>
</jr:columnHeader>
<jr:columnFooter height="14" rowSpan="1">
<componentElement>
<reportElement x="0" y="0" width="83" height="14" uuid="e8a2bb6c-58bb-4b41-a928-42d549a07214"/>
<jr:list printOrder="Vertical">
<datasetRun subDataset="libroDiario2totales" uuid="1e90dae1-9d4c-4946-8624-f76324c48725">
<datasetParameter name="id_ce">
<datasetParameterExpression><![CDATA[$P{i}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="14" width="83">
<textField isStretchWithOverflow="true" pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
<reportElement x="0" y="0" width="83" height="14" uuid="18c7a778-7a9f-49d1-b693-51f2ef4b829a"/>
<box rightPadding="5">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{sum2}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</jr:columnFooter>
<jr:detailCell height="15" rowSpan="1">
<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="83" height="15" uuid="3e7b592f-080b-407e-835b-f651bf85d4e1"/>
<box rightPadding="5">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{haber_me}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="83" uuid="2105f092-7c4a-4959-9713-ad2fdd1de87c">
<jr:columnHeader height="14" rowSpan="1">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="83" height="14" backcolor="#CCCCCC" uuid="0820d8ae-a948-4206-8ddc-c18d1b44b6f0"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[DEBE S. ]]></text>
</staticText>
</jr:columnHeader>
<jr:columnFooter height="14" rowSpan="1">
<componentElement>
<reportElement x="0" y="0" width="83" height="14" uuid="46004989-7a2a-405c-b6f9-c2f878876a2c"/>
<jr:list printOrder="Vertical">
<datasetRun subDataset="libroDiario2totales" uuid="82483e68-5f0d-41b7-901b-97668a6441f4">
<datasetParameter name="ide">
<datasetParameterExpression><![CDATA[$P{id}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="14" width="83">
<textField isStretchWithOverflow="true" pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
<reportElement x="0" y="0" width="83" height="14" uuid="f9126663-2ba2-40a1-befd-3b153d146e06"/>
<box rightPadding="5">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{sum3}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</jr:columnFooter>
<jr:detailCell height="15" rowSpan="1">
<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="83" height="15" uuid="a462de03-9800-41f4-9376-eb6aef618212"/>
<box rightPadding="5">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{debe_ml}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="88" uuid="362659cc-c8a8-4fb4-b527-3ad3ac99b246">
<jr:columnHeader height="14" rowSpan="1">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="88" height="14" backcolor="#CCCCCC" uuid="6a23b2b2-da34-4775-97be-c72c70eeac60"/>
<box>
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<text><![CDATA[HABER S.]]></text>
</staticText>
</jr:columnHeader>
<jr:columnFooter height="14" rowSpan="1">
<componentElement>
<reportElement x="0" y="0" width="88" height="14" uuid="d7428286-09df-412b-9c74-060cac26f978"/>
<jr:list printOrder="Vertical">
<datasetRun subDataset="libroDiario2totales" uuid="e8d428bf-7f87-4178-b7c2-3917b38681f7">
<datasetParameter name="id">
<datasetParameterExpression><![CDATA[$P{i}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="14" width="88">
<textField isStretchWithOverflow="true" pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
<reportElement x="0" y="0" width="85" height="14" uuid="58aa32f4-846a-40e5-86e9-25f37dd0d8dd"/>
<box rightPadding="5">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="8" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{sum4}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</jr:columnFooter>
<jr:detailCell height="15" rowSpan="1">
<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="88" height="15" uuid="dc22995d-7d3d-4ca6-952b-7d660991ce6f"/>
<box rightPadding="5">
<topPen lineWidth="0.5"/>
<leftPen lineWidth="0.5"/>
<bottomPen lineWidth="0.5"/>
<rightPen lineWidth="0.5"/>
</box>
<textElement textAlignment="Right">
<font fontName="SansSerif" size="8"/>
</textElement>
<textFieldExpression><![CDATA[$F{haber_ml}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
</jr:columnGroup>
</jr:table>
</componentElement>
</jr:detailCell>
</jr:column>
</jr:table>
</componentElement>
</band>
</detail>
<pageFooter>
<band height="24" splitType="Stretch">
<staticText>
<reportElement x="22" y="6" width="364" height="9" uuid="8fdaf7bb-be34-4632-b1e9-2365766737c4"/>
<textElement>
<font fontName="Arial" size="6"/>
</textElement>
<text><![CDATA[DI...]]></text>
</staticText>
<textField>
<reportElement mode="Opaque" x="409" y="6" width="283" height="9" backcolor="#FFFFFF" uuid="d383283a-89b2-41ca-ae57-180ab0b4c7b1"/>
<textElement textAlignment="Right">
<font fontName="Arial" size="7"/>
</textElement>
<textFieldExpression><![CDATA["Pag. "+$V{PAGE_NUMBER}+" de"]]></textFieldExpression>
</textField>
<textField pattern="yyyy">
<reportElement x="170" y="14" width="231" height="9" uuid="9f82e590-7fa7-4c31-81d5-26cb613c0ceb"/>
<textElement>
<font fontName="Arial" size="6"/>
</textElement>
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="22" y="14" width="314" height="9" uuid="b86f425f-5eee-49d8-9e1f-d28d07627aad"/>
<textElement>
<font fontName="Arial" size="6"/>
</textElement>
<text><![CDATA[U... - ]]></text>
</staticText>
<line>
<reportElement mode="Opaque" x="21" y="4" width="711" height="1" forecolor="#666666" uuid="34466524-688d-4111-9e19-66cbd63c4e14"/>
</line>
<textField evaluationTime="Report">
<reportElement mode="Opaque" x="692" y="6" width="40" height="9" backcolor="#FFFFFF" uuid="19634fe4-4183-48ee-aa64-c1a562872385"/>
<textElement>
<font fontName="Arial" size="7"/>
</textElement>
<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
</band>
</pageFooter>
</jasperReport>