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="prontuario_questionario" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="4465bb96-c2e8-4bea-a08a-9c0162468e30">
        <property name="ireport.zoom" value="1.0"/>
        <property name="ireport.x" value="0"/>
        <property name="ireport.y" value="0"/>
        <parameter name="pSequencialAtendimento" class="java.lang.Integer">
                <defaultValueExpression><![CDATA[]]></defaultValueExpression>
        </parameter>
        <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
                <defaultValueExpression><![CDATA[""]]></defaultValueExpression>
        </parameter>
        <queryString>
                <![CDATA[SELECT
pe.seq_questionario,
(select qu.dsc_questionario from sc_adm.adm_questionario qu where qu.seq_questionario = pe.seq_questionario) as dsc_questionario,
se.nom_secao,
pe.seq_pergunta,
pe.num_pergunta,
pe.dsc_pergunta,
pe.tip_resposta
FROM sc_adm.adm_pergunta pe
left join sc_adm.adm_secao se on (se.seq_secao = pe.seq_secao)
where pe.seq_questionario in (select p.seq_questionario from sc_cln.cln_atendimento_itemrespquest air
join sc_adm.adm_item_resposta ir on (ir.seq_item_resposta = air.seq_item_resposta)
join sc_adm.adm_pergunta p on (p.seq_pergunta = ir.seq_pergunta)
where air.seq_atendimento = $P{pSequencialAtendimento})
order by pe.seq_questionario, pe.num_pergunta]]>
        </queryString>
        <field name="seq_questionario" class="java.lang.Long">
                <fieldDescription><![CDATA[Sequencial Identificador do questionário.]]></fieldDescription>
        </field>
        <field name="dsc_questionario" class="java.lang.String">
                <fieldDescription><![CDATA[Descrição do questionário.]]></fieldDescription>
        </field>
        <field name="nom_secao" class="java.lang.String">
                <fieldDescription><![CDATA[Nome da seção.]]></fieldDescription>
        </field>
        <field name="seq_pergunta" class="java.lang.Integer">
                <fieldDescription><![CDATA[Sequencial Identificador da pergunta.]]></fieldDescription>
        </field>
        <field name="num_pergunta" class="java.lang.Long">
                <fieldDescription><![CDATA[Número da pergunta. Usado para ordenar a exibição das perguntas do questionário.]]></fieldDescription>
        </field>
        <field name="dsc_pergunta" class="java.lang.String">
                <fieldDescription><![CDATA[Descrição da Pergunta]]></fieldDescription>
        </field>
        <field name="tip_resposta" class="java.lang.String">
                <fieldDescription><![CDATA[Tipo de resposta da pergunta.
Valores Possíveis: Única escolha, Multipla escolha e Texto livre.]]></fieldDescription>
        </field>
        <group name="questionario">
                <groupExpression><![CDATA[$F{seq_questionario}]]></groupExpression>
                <groupHeader>
                        <band height="25">
                                <textField>
                                        <reportElement uuid="96008fa9-4c97-43f6-ad57-a4e7822232b9" x="0" y="5" width="555" height="20"/>
                                        <textElement>
                                                <font fontName="Arial" size="12" isBold="true" isUnderline="false" pdfFontName="Helvetica-Bold"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA["FORMULÁRIO: " + $F{dsc_questionario}]]></textFieldExpression>
                                </textField>
                        </band>
                </groupHeader>
                <groupFooter>
                        <band height="2">
                                <line>
                                        <reportElement uuid="da930f95-61fe-4791-88aa-2ad604013920" x="0" y="1" width="555" height="1"/>
                                        <graphicElement>
                                                <pen lineWidth="0.5" lineStyle="Dashed"/>
                                        </graphicElement>
                                </line>
                        </band>
                </groupFooter>
        </group>
        <group name="secao">
                <groupExpression><![CDATA[$F{nom_secao}]]></groupExpression>
                <groupHeader>
                        <band height="29">
                                <printWhenExpression><![CDATA[$F{nom_secao} != null]]></printWhenExpression>
                                <textField>
                                        <reportElement uuid="bad4838c-e58e-455f-bf48-bdb7188ca8f3" x="0" y="5" width="555" height="20"/>
                                        <textElement>
                                                <font fontName="Arial" isBold="false" isUnderline="true"/>
                                        </textElement>
                                        <textFieldExpression><![CDATA[$F{nom_secao}]]></textFieldExpression>
                                </textField>
                        </band>
                </groupHeader>
        </group>
        <background>
                <band splitType="Stretch"/>
        </background>
        <detail>
                <band height="46">
                        <textField isStretchWithOverflow="true">
                                <reportElement uuid="49d922ef-d1a6-4ec0-9eb5-49ecbaefb251" x="0" y="0" width="555" height="20" isPrintWhenDetailOverflows="true"/>
                                <textElement>
                                        <font fontName="Arial" size="10"/>
                                        <paragraph spacingAfter="2"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$F{num_pergunta} + ". " + $F{dsc_pergunta}]]></textFieldExpression>
                        </textField>
                        <subreport>
                                <reportElement uuid="e6d7e728-1c5b-4c99-9c65-e278c507fe2b" positionType="Float" x="0" y="22" width="555" height="23" isPrintWhenDetailOverflows="true"/>
                                <subreportParameter name="pTipoResposta">
                                        <subreportParameterExpression><![CDATA[$F{tip_resposta}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="pSequencialAtendimento">
                                        <subreportParameterExpression><![CDATA[$P{pSequencialAtendimento}]]></subreportParameterExpression>
                                </subreportParameter>
                                <subreportParameter name="pSequencialPergunta">
                                        <subreportParameterExpression><![CDATA[$F{seq_pergunta}]]></subreportParameterExpression>
                                </subreportParameter>
                                <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                                <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "prontuario_itens_resposta_pergunta_subreport.jasper"]]></subreportExpression>
                        </subreport>
                </band>
        </detail>
</jasperReport>