<?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="maestro_subreport1" language="groovy" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="2b7db815-8fb9-48bb-8a58-c4b68c326382">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="titulov3"/>
	<parameter name="id_pd" class="java.lang.Integer">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
	pago_dp.id_Pago,
	pago_dp.fecha_Pago,
	pago_dp.derecho_Propietario as id_pd,
	pago_dp.total_bs,
	gestion.nombre,
	gestion.utilidad_gestion
FROM
	pago_dp
	INNER JOIN
	gestion
	ON
		pago_dp.id_gestion = gestion.id_Gestion

where pago_dp.derecho_Propietario = $P{id_pd}]]>
	</queryString>
	<field name="id_Pago" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="fecha_Pago" class="java.sql.Timestamp">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="id_pd" class="java.lang.Integer"/>
	<field name="total_bs" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="nombre" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="utilidad_gestion" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<background>
		<band splitType="Stretch"/>
	</background>
	<columnHeader>
		<band height="26" splitType="Stretch">
			<staticText>
				<reportElement x="12" y="1" width="60" height="18" uuid="a8ddfd2b-75be-4777-a37a-698dfd05c2b8">
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[id_Pago]]></text>
			</staticText>
			<staticText>
				<reportElement x="76" y="1" width="87" height="18" uuid="8de2b3f8-4a1f-4f64-a933-05456fb97304">
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Fecha_Pago]]></text>
			</staticText>
			<staticText>
				<reportElement x="174" y="1" width="49" height="18" uuid="20f8f903-7287-4a48-9d88-c8f7ae91f888">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a093d1a1-d151-4269-87ea-f0d7f9af9b16"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Gestion Pagada]]></text>
			</staticText>
			<staticText>
				<reportElement x="318" y="1" width="60" height="18" uuid="afc17e7b-0d39-47b9-b897-b9a82622607e">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0a86c2ae-cc20-4fe8-9a93-99574af07175"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Total Bs]]></text>
			</staticText>
			<staticText>
				<reportElement x="228" y="1" width="90" height="18" uuid="b25c4e06-82fe-4035-958a-8ae60f665883">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1a403526-5def-4f38-87d9-c459eeb551ca"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Utilidad Gestion]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="23" splitType="Stretch">
			<textField>
				<reportElement x="12" y="1" width="60" height="18" uuid="29b5955a-00fb-4d91-8bb9-0aabf61f8260">
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{id_Pago}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="76" y="1" width="87" height="18" uuid="cee4170f-4086-408a-9c0c-776b368f48e8">
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{fecha_Pago}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="174" y="1" width="49" height="18" uuid="893b659f-8537-469d-ab85-7f24cf50f04a">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a093d1a1-d151-4269-87ea-f0d7f9af9b16"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{nombre}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="318" y="0" width="60" height="18" uuid="c91cbbf4-7353-444f-ae6a-e16411bc67f8">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0a86c2ae-cc20-4fe8-9a93-99574af07175"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{total_bs}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="248" y="1" width="40" height="18" uuid="4c4853ec-d64e-40ca-bdcc-fe56c3ac8354">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1a403526-5def-4f38-87d9-c459eeb551ca"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{utilidad_gestion}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
