73 lines
3.6 KiB
XML
Executable File
73 lines
3.6 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:27:45 -->
|
|
<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="menusublevelsubreport" 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="levelcode" class="java.math.BigDecimal"/>
|
|
<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
|
|
<defaultValueExpression><![CDATA["repo:/maia/1/modules/security/subreports/"]]></defaultValueExpression>
|
|
</parameter>
|
|
<queryString language="SQL">
|
|
<![CDATA[SELECT DISTINCT SUBLEVEL, SUBLEVELDESC FROM(
|
|
select TGMSL.SUBLEVEL,
|
|
(select DESCRIPTION
|
|
from TGENEMENUSUBLEVELDESC
|
|
where MENUCODE = TGMSL.MENUCODE
|
|
and LEVELCODE = TGMSL.LEVELCODE
|
|
and SUBLEVEL = TGMSL.SUBLEVEL
|
|
and LANGUAGECODE = $P{languagecode}) SUBLEVELDESC
|
|
from TGENEMENUSUBLEVEL TGMSL
|
|
where TGMSL.MENUCODE = $P{menucode}
|
|
and TGMSL.LEVELCODE = $P{levelcode}
|
|
order by TGMSL.PRESENTATIONORDER)]]>
|
|
</queryString>
|
|
<field name="SUBLEVEL" class="java.math.BigDecimal"/>
|
|
<field name="SUBLEVELDESC" class="java.lang.String"/>
|
|
<group name="sublevel">
|
|
<groupExpression><![CDATA[$F{SUBLEVEL}]]></groupExpression>
|
|
<groupHeader>
|
|
<band height="13">
|
|
<textField>
|
|
<reportElement style="detail" x="60" y="0" width="495" height="13" uuid="6b6ca375-73df-47d9-9dac-03094dcd433b"/>
|
|
<textFieldExpression><![CDATA[($F{SUBLEVELDESC} == null) ? $F{SUBLEVEL}+" - "+"SUBNIVEL NO DEFINIDO" : $F{SUBLEVELDESC}]]></textFieldExpression>
|
|
</textField>
|
|
</band>
|
|
</groupHeader>
|
|
</group>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<detail>
|
|
<band height="13">
|
|
<subreport>
|
|
<reportElement x="0" y="0" width="842" height="13" uuid="0ffdf7db-4bd6-4f44-b47d-81b33e23a8af"/>
|
|
<subreportParameter name="sublevelcode">
|
|
<subreportParameterExpression><![CDATA[$F{SUBLEVEL}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="menucode">
|
|
<subreportParameterExpression><![CDATA[$P{menucode}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="pathstyle">
|
|
<subreportParameterExpression><![CDATA[$P{pathstyle}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="levelcode">
|
|
<subreportParameterExpression><![CDATA[$P{levelcode}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<subreportParameter name="languagecode">
|
|
<subreportParameterExpression><![CDATA[$P{languagecode}]]></subreportParameterExpression>
|
|
</subreportParameter>
|
|
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
|
|
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "transactionmenusublevelsubreport"]]></subreportExpression>
|
|
</subreport>
|
|
</band>
|
|
</detail>
|
|
</jasperReport>
|