90 lines
4.4 KiB
XML
Executable File
90 lines
4.4 KiB
XML
Executable File
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!-- Created with Jaspersoft Studio version 5.6.1.final using JasperReports Library version 5.6.1 -->
|
|
<!-- 2015-06-03T18:47:37 -->
|
|
<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="transactionmenusublevelsubreport" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="842" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="027b9f69-a8b1-4a8b-b2f5-9a40a3d73b01">
|
|
<property name="ireport.zoom" value="1.0"/>
|
|
<property name="ireport.x" value="0"/>
|
|
<property name="ireport.y" value="0"/>
|
|
<template><![CDATA[$P{pathstyle}]]></template>
|
|
<parameter name="pathstyle" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/style/style"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="languagecode" class="java.lang.String"/>
|
|
<parameter name="menucode" class="java.math.BigDecimal"/>
|
|
<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/security/"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="sublevelcode" class="java.math.BigDecimal"/>
|
|
<parameter name="levelcode" class="java.math.BigDecimal"/>
|
|
<parameter name="parameter1" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select distinct TRANSACTIONMODULE, TRANSACTIONCODE, TRANSACTIONVERSION, NOMBRE from (
|
|
select TGMST.TRANSACTIONMODULE,
|
|
TGMST.TRANSACTIONCODE,
|
|
TGMST.TRANSACTIONVERSION,
|
|
(select TGT.NAME
|
|
from TGENETRANSACTION TGT
|
|
where TGT.TRANSACTIONMODULE = TGMST.TRANSACTIONMODULE
|
|
and TGT.TRANSACTIONCODE = TGMST.TRANSACTIONCODE
|
|
and TGT.TRANSACTIONVERSION = TGMST.TRANSACTIONVERSION) NOMBRE
|
|
from TGENEMENUSUBLEVELTRAN TGMST
|
|
where TGMST.MENUCODE = $P{menucode}
|
|
and TGMST.LEVELCODE = $P{levelcode}
|
|
and TGMST.SUBLEVEL = $P{sublevelcode})
|
|
order by 4, 1,2,3]]>
|
|
</queryString>
|
|
<field name="TRANSACTIONMODULE" class="java.lang.String"/>
|
|
<field name="TRANSACTIONCODE" class="java.math.BigDecimal"/>
|
|
<field name="TRANSACTIONVERSION" class="java.math.BigDecimal"/>
|
|
<field name="NOMBRE" class="java.lang.String"/>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<columnHeader>
|
|
<band height="13">
|
|
<staticText>
|
|
<reportElement style="headercolumn" x="320" y="0" width="437" height="13" uuid="95513ad3-352c-4dc1-8c8f-027413b5cc2d"/>
|
|
<text><![CDATA[Nombre transacción]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn" x="70" y="0" width="69" height="13" uuid="8e599c0e-9b62-4a77-b80c-18d5d16ef9e8"/>
|
|
<textElement textAlignment="Left"/>
|
|
<text><![CDATA[Módulo]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn" x="234" y="0" width="86" height="13" uuid="2c3b9e26-8020-43cf-8af8-d2a668a3d313"/>
|
|
<textElement textAlignment="Left"/>
|
|
<text><![CDATA[Versión]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="headercolumn" x="139" y="0" width="95" height="13" uuid="9a6c9f5c-4801-4e43-8b00-0cb0e8ff9cd5"/>
|
|
<textElement textAlignment="Left"/>
|
|
<text><![CDATA[Transacción]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="13">
|
|
<textField>
|
|
<reportElement style="detail" x="70" y="0" width="40" height="13" uuid="b5d368b9-81ed-42c5-9d2c-e7174d636489"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{TRANSACTIONMODULE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="detail" x="320" y="0" width="437" height="13" uuid="4036f6ba-c2aa-4b76-997c-62b225cd72c3"/>
|
|
<textFieldExpression><![CDATA[$F{NOMBRE}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="detail" x="234" y="0" width="50" height="13" uuid="da3f46d2-6197-48f7-bd38-9267f2aa7edf"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{TRANSACTIONVERSION}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="detail" x="139" y="0" width="70" height="13" uuid="366e0f6b-96b5-4229-8338-83c2bcc4c00d"/>
|
|
<textElement textAlignment="Left"/>
|
|
<textFieldExpression><![CDATA[$F{TRANSACTIONCODE}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</detail>
|
|
</jasperReport>
|