joseluismen Posted July 26, 2019 Share Posted July 26, 2019 <?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> 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