<?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="Cuestionario_resolucion_1273" language="groovy" pageWidth="612" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="512" leftMargin="60" rightMargin="40" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.210000000000002"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/radicacionvirtualcuentas/declara_jura_depen"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<subDataset name="dataset1"/>
	<parameter name="id_contra_cuestionario" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[NULL]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select * from (SELECT
  q.id_contra_cuestionario,
  q.ID_CONTRATISTA,
  q.ID_CUESTIONARIO,
  q.FECHA_LOG,
  resp.ID_PREGUNTA,
  resp.RESPUESTA,
  resp.RESPUESTA_OBS,
  c.TITULO,
  c.TEXTO_ENCABEZADO,
  c.TEXTO_PIE,
  preg.TEXTO,
  preg.TEXTO_OBS,
  preg.numero

from RVC_CONTRA_CUESTIONARIO q
left join RVC_CUESTIONARIO c on c.ID_CUESTIONARIO= q.ID_CUESTIONARIO
left join RVC_RESP_CONTRA_CUESTION resp on resp.ID_CONTRA_CUESTIONARIO=q.ID_CONTRA_CUESTIONARIO
left join RVC_PREGUNTA_CUESTIONARIO preg on preg.ID_PREGUNTA = resp.ID_PREGUNTA)tab0
where 1=1
and tab0.id_contra_cuestionario = $P{id_contra_cuestionario}
order by tab0.id_contra_cuestionario,tab0.numero]]>
	</queryString>
	<field name="ID_CONTRA_CUESTIONARIO" class="java.math.BigDecimal"/>
	<field name="ID_CONTRATISTA" class="java.math.BigDecimal"/>
	<field name="ID_CUESTIONARIO" class="java.math.BigDecimal"/>
	<field name="FECHA_LOG" class="java.sql.Timestamp"/>
	<field name="ID_PREGUNTA" class="java.math.BigDecimal"/>
	<field name="RESPUESTA" class="java.lang.String"/>
	<field name="RESPUESTA_OBS" class="java.lang.String"/>
	<field name="TITULO" class="java.lang.String"/>
	<field name="TEXTO_ENCABEZADO" class="java.lang.String"/>
	<field name="TEXTO_PIE" class="java.lang.String"/>
	<field name="TEXTO" class="java.lang.String"/>
	<field name="TEXTO_OBS" class="java.lang.String"/>
	<field name="NUMERO" class="java.math.BigDecimal"/>
	<title>
		<band height="72" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement x="0" y="1" width="512" height="29"/>
				<box topPadding="2" leftPadding="2" bottomPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" markup="styled">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TITULO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="0" y="30" width="512" height="40"/>
				<box topPadding="2" leftPadding="2" bottomPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" markup="styled"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TEXTO_ENCABEZADO}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<detail>
		<band height="87" splitType="Prevent">
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="36" y="0" width="476" height="19"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TEXTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement positionType="Float" x="36" y="19" width="476" height="19"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font isUnderline="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RESPUESTA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="Float" x="36" y="38" width="476" height="19"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TEXTO_OBS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="FixRelativeToBottom" x="36" y="57" width="476" height="19"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Middle">
					<font isUnderline="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RESPUESTA_OBS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="0" width="36" height="19"/>
				<box leftPadding="2"/>
				<textElement verticalAlignment="Top">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUMERO}.toString()+".- "]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<summary>
		<band height="46">
			<textField isStretchWithOverflow="true">
				<reportElement x="0" y="0" width="512" height="44"/>
				<box topPadding="2" leftPadding="2" bottomPadding="2" rightPadding="2">
					<topPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" markup="styled"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TEXTO_PIE}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="512" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
