Subversion Repositories Integrator Subversion

<?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="itens_prontuario_subreport" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="c0d2bf3f-f03a-4b22-95e5-684ea0a5ab4c">
        <property name="ireport.zoom" value="1.4641000000000006"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="0"/>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <parameter name="pSequencialAtendimento" class="java.lang.Integer">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[select at.seq_atendimento,
(select exists(select 1 from sc_cln.cln_atendimento_itemrespquest air where air.seq_atendimento = at.seq_atendimento)) as questionario,
(select exists(select 1 from sc_cln.cln_solicitacao_procedimento sp where sp.seq_atendimento = at.seq_atendimento)) as procedimento,
(select exists(select 1 from sc_cln.cln_atendimento_texto ap where ap.seq_atendimento = at.seq_atendimento)) as prescricao
from sc_cln.cln_atendimento at
where at.seq_atendimento = $P{pSequencialAtendimento}]]>
        </queryString>
        <field name="seq_atendimento" class="java.lang.Integer"/>
        <field name="questionario" class="java.lang.Boolean"/>
        <field name="procedimento" class="java.lang.Boolean"/>
        <field name="prescricao" class="java.lang.Boolean"/>
        <group name="questionario">
                <groupExpression><![CDATA[1]]></groupExpression>
        </group>
        <group name="procedimento">
                <groupExpression><![CDATA[1]]></groupExpression>
        </group>
        <group name="prescricao">
                <groupExpression><![CDATA[1]]></groupExpression>
        </group>
        <background>
                <band splitType="Stretch"/>
        </background>
        <detail>
                <band height="38">
                        <printWhenExpression><![CDATA[$F{questionario} == true]]></printWhenExpression>
                        <subreport>
                                <reportElement uuid="8753163d-8311-40f4-8036-c34fb5932a6e" x="0" y="0" width="555" height="38"/>
                                <subreportParameter name="pSequencialAtendimento">
                                        <subreportParameterExpression><![CDATA[$F{seq_atendimento}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "prontuario_questionario.jasper"]]></subreportExpression>
                        </subreport>
                </band>
                <band height="40">
                        <printWhenExpression><![CDATA[$F{procedimento} == true]]></printWhenExpression>
                        <subreport>
                                <reportElement uuid="6cb8bf8e-8274-410c-8089-524cd223cf94" x="0" y="0" width="555" height="40"/>
                                <subreportParameter name="pSequencialAtendimento">
                                        <subreportParameterExpression><![CDATA[$F{seq_atendimento}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "prontuario_procedimento_subreport1.jasper"]]></subreportExpression>
                        </subreport>
                </band>
                <band height="40">
                        <printWhenExpression><![CDATA[$F{prescricao} == true]]></printWhenExpression>
                        <subreport>
                                <reportElement uuid="64031487-0380-4b37-9f00-ea0343d1503c" x="0" y="0" width="555" height="40"/>
                                <subreportParameter name="pSequencialAtendimento">
                                        <subreportParameterExpression><![CDATA[$F{seq_atendimento}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "prontuario_prescricao_subreport.jasper"]]></subreportExpression>
                        </subreport>
                </band>
        </detail>
</jasperReport>