165 lines
7.6 KiB
XML
Executable File
165 lines
7.6 KiB
XML
Executable File
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!-- Created with Jaspersoft Studio version 5.6.2.final using JasperReports Library version 5.6.1 -->
|
|
<!-- 2014-10-22T12:53:49 -->
|
|
<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="requisitos" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="3190ca62-574f-4c0a-8783-decda02d61e1">
|
|
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
|
|
<template><![CDATA[$P{pathstyle}]]></template>
|
|
<parameter name="pathstyle" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/style/style"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="csolicitud" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select
|
|
rownum,
|
|
--DATOS DE LA SOLICITUD
|
|
requisito.nombre as descripcion
|
|
from tarmsolicitud solicitud
|
|
inner join tarmsolicitudtramite soltramite on soltramite.csolicitud = solicitud.csolicitud
|
|
inner join tarmtramite tramite on tramite.ctramite = soltramite.ctramite
|
|
--TIPO DE TRAMITE
|
|
left join tgenecatalogdetail tipotramite on tipotramite.catalog=tramite.tipotramite and tipotramite.catalogcode=tramite.tipotramitecodigo
|
|
--REQUISITO X TRAMITE
|
|
inner join tarmrequisitoportipotramite reqxtramite
|
|
on reqxtramite.ctramite = solicitud.ctramite
|
|
and reqxtramite.ctramite = soltramite.ctramite
|
|
and reqxtramite.ctramite = tramite.ctramite
|
|
and soltramite.ctramite = tramite.ctramite
|
|
inner join tarmrequisito requisito on requisito.crequisito = reqxtramite.crequisito
|
|
--FILTRO DE BUSQUEDA
|
|
where solicitud.csolicitud=$P{csolicitud}]]>
|
|
</queryString>
|
|
<field name="ROWNUM" class="java.lang.Integer"/>
|
|
<field name="DESCRIPCION" class="java.lang.String"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="22" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement style="title2" x="0" y="0" width="190" height="16" forecolor="#000000" uuid="8305a6db-e590-43c8-82ac-1701e8b1cc4c"/>
|
|
<textElement textAlignment="Left"/>
|
|
<text><![CDATA[REQUISITOS:]]></text>
|
|
</staticText>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band splitType="Stretch"/>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="29" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement style="title2" x="1" y="0" width="19" height="29" forecolor="#000000" uuid="7c46dbc1-c1e1-4cc1-97f0-baebaa589395">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[No.]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="20" y="0" width="450" height="29" forecolor="#000000" uuid="21baab56-6ab8-4a18-8ea5-74b64532c24c">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[Descripcion requisitos]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="title2" x="470" y="0" width="84" height="29" forecolor="#000000" uuid="e49be1b4-a86b-4cc2-8dde-9143e0674296">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box>
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center"/>
|
|
<text><![CDATA[Estado]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="13" splitType="Stretch">
|
|
<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>
|
|
<textField isStretchWithOverflow="true">
|
|
<reportElement key="" style="normal" stretchType="RelativeToTallestObject" x="1" y="0" width="19" height="13" forecolor="#000000" uuid="7a491d80-7d1a-449d-828b-8a6c55cc212c">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
</reportElement>
|
|
<box leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{ROWNUM}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" stretchType="RelativeToTallestObject" x="20" y="0" width="450" height="13" forecolor="#000000" uuid="8071cb46-2f66-4760-a09b-b37db47caedd">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Left" verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{DESCRIPCION}]]></textFieldExpression>
|
|
</textField>
|
|
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
|
|
<reportElement key="" style="normal" stretchType="RelativeToTallestObject" x="470" y="0" width="84" height="13" forecolor="#000000" uuid="d6c11315-b565-44fb-900d-d49ca941c1c4">
|
|
<property name="local_mesure_unitheight" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.height" value="px"/>
|
|
<property name="local_mesure_unitx" value="pixel"/>
|
|
<property name="com.jaspersoft.studio.unit.x" value="px"/>
|
|
<property name="com.jaspersoft.studio.unit.width" value="px"/>
|
|
</reportElement>
|
|
<box leftPadding="2" rightPadding="2">
|
|
<topPen lineWidth="0.5"/>
|
|
<leftPen lineWidth="0.5"/>
|
|
<bottomPen lineWidth="0.5"/>
|
|
<rightPen lineWidth="0.5"/>
|
|
</box>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[""]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band splitType="Stretch"/>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band splitType="Stretch"/>
|
|
</pageFooter>
|
|
<summary>
|
|
<band splitType="Stretch"/>
|
|
</summary>
|
|
</jasperReport>
|