158 lines
6.9 KiB
XML
Executable File
158 lines
6.9 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:51:12 -->
|
|
<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="transactionsperprofile" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="2fca705c-116c-4056-861a-6929a0d1a813">
|
|
<property name="ireport.zoom" value="1.2100000000000002"/>
|
|
<property name="ireport.x" value="0"/>
|
|
<property name="ireport.y" value="0"/>
|
|
<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="workingdate" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["2011-12-31"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="pathimage" class="java.lang.String" isForPrompting="false">
|
|
<parameterDescription><![CDATA[]]></parameterDescription>
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/image/logo"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="company" class="java.lang.Integer" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA[1]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="dateto" class="java.sql.Timestamp" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
|
|
<parameterDescription><![CDATA[]]></parameterDescription>
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/modules/security/subreports/"]]></defaultValueExpression>
|
|
</parameter>
|
|
<parameter name="languagecode" class="java.lang.String">
|
|
<defaultValueExpression><![CDATA["ES"]]></defaultValueExpression>
|
|
</parameter>
|
|
<queryString>
|
|
<![CDATA[select TGMP.PROFILECODE,
|
|
(select TSP.DESCRIPTION
|
|
from TSAFEPROFILE TSP
|
|
where TSP.PROFILECODE = TGMP.PROFILECODE) PROFILEDESC,
|
|
TGMP.MENUCODE,
|
|
(select TGM.DESCRIPTION
|
|
from TGENEMENU TGM
|
|
where TGM.MENUCODE = TGMP.MENUCODE) MENUDESC
|
|
from TGENEMENUPROFILE TGMP
|
|
order by MENUDESC]]>
|
|
</queryString>
|
|
<field name="PROFILECODE" class="java.lang.String"/>
|
|
<field name="PROFILEDESC" class="java.lang.String"/>
|
|
<field name="MENUCODE" class="java.math.BigDecimal"/>
|
|
<field name="MENUDESC" class="java.lang.String"/>
|
|
<group name="profilecode">
|
|
<groupExpression><![CDATA[$F{PROFILECODE}]]></groupExpression>
|
|
<groupHeader>
|
|
<band height="15">
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement style="detail" x="35" y="0" width="765" height="15" uuid="6ac6b0f4-c336-4b6c-9029-04b5a39cfdcb"/>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{PROFILEDESC}]]></textFieldExpression>
|
|
</textField>
|
|
<staticText>
|
|
<reportElement style="subtitle" x="0" y="0" width="35" height="15" uuid="6bd4b295-dd3f-4c20-9b37-ac2ebafa67ba"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Perfil:]]></text>
|
|
</staticText>
|
|
</band>
|
|
</groupHeader>
|
|
</group>
|
|
<group name="menucode">
|
|
<groupExpression><![CDATA[$F{MENUCODE}]]></groupExpression>
|
|
<groupHeader>
|
|
<band height="15">
|
|
<staticText>
|
|
<reportElement style="subtitle" x="0" y="0" width="35" height="15" uuid="e5a9d268-756c-40f0-9a28-c677b26e55d0"/>
|
|
<textElement>
|
|
<font isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[Menú:]]></text>
|
|
</staticText>
|
|
<textField isBlankWhenNull="true">
|
|
<reportElement style="detail" x="35" y="0" width="765" height="15" uuid="b34b5c46-4676-4791-9cf6-e19484a35a23"/>
|
|
<textElement verticalAlignment="Middle"/>
|
|
<textFieldExpression><![CDATA[$F{MENUCODE}+"-"+$F{MENUDESC}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</groupHeader>
|
|
</group>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="35" splitType="Stretch">
|
|
<image>
|
|
<reportElement x="0" y="0" width="800" height="35" uuid="2e3bd35b-d512-4a49-8b85-06e21bfda772"/>
|
|
<imageExpression><![CDATA[$P{pathimage}]]></imageExpression>
|
|
</image>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band height="29" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement style="title" x="0" y="3" width="800" height="22" uuid="b9f1791e-e716-44b1-accd-c22c19c19851"/>
|
|
<textElement textAlignment="Center" verticalAlignment="Middle">
|
|
<font fontName="SansSerif" size="14" isBold="true"/>
|
|
</textElement>
|
|
<text><![CDATA[LISTADO DE TRANSACCIONES POR PERFIL]]></text>
|
|
</staticText>
|
|
</band>
|
|
</pageHeader>
|
|
<detail>
|
|
<band height="13" splitType="Stretch">
|
|
<subreport>
|
|
<reportElement x="0" y="0" width="800" height="13" uuid="ea3fd517-e636-4d51-8619-f36e31c52023"/>
|
|
<subreportParameter name="menucode">
|
|
<subreportParameterExpression><![CDATA[$F{MENUCODE}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="pathstyle">
|
|
<subreportParameterExpression><![CDATA[$P{pathstyle}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="languagecode">
|
|
<subreportParameterExpression><![CDATA[$P{languagecode}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
|
|
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "menulevelsubreport"]]></subreportExpression>
|
|
</subreport>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band splitType="Stretch"/>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band height="15" splitType="Stretch">
|
|
<textField pattern="">
|
|
<reportElement style="footerinfo" x="3" y="0" width="150" height="15" uuid="486f0e72-f72b-4326-9fe3-b95a7895455a"/>
|
|
<textElement>
|
|
<font size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$P{workingdate}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="footerinfo" x="427" y="0" width="329" height="15" uuid="204ba90b-0617-43ca-abd4-c15ccc40380c"/>
|
|
<textElement textAlignment="Right">
|
|
<font fontName="SansSerif" size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA["Página "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
|
|
</textField>
|
|
<textField evaluationTime="Report">
|
|
<reportElement style="footerinfo" x="760" y="0" width="40" height="15" uuid="7bebdc0e-25ef-4c61-8f17-d81ea872d7ff"/>
|
|
<textElement>
|
|
<font fontName="SansSerif" size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</pageFooter>
|
|
<summary>
|
|
<band height="42" splitType="Stretch"/>
|
|
</summary>
|
|
</jasperReport>
|