<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad  -->
<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="PlanillaPago" pageWidth="612" pageHeight="792" columnWidth="539" leftMargin="38" rightMargin="35" topMargin="20" bottomMargin="10" uuid="6eb66b6b-9a20-4723-a05c-9f52ec31a413">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="mysql orodiint_bsn"/>
	<property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="656"/>
	<property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="330"/>
	<property name="com.jaspersoft.studio.unit.leftMargin" value="cm"/>
	<parameter name="P1" class="java.lang.Integer">
		<parameterDescription><![CDATA[Id de titulo]]></parameterDescription>
	</parameter>
	<queryString language="SQL">
		<![CDATA[SELECT
(@row := @row + 1) as nro, 
	d_p.id_derecho_Propietario,
	LPAD( d_p.id_derecho_Propietario, 4, 000 ) AS id_derecho_Propietario2,
	d_p.nro_Partido,
	d_p.nro_Folio,
	g.nombre AS gestion,
	e.nombre AS Empresa,
	e.nit,
	e.matricula_Comercio,
	e.capital_Autorizado,
	e.capital_Pagado,
	e.lugar_Constitucion,
	e.fecha_Constitucion,
	e.duracion,
	e.domicilio,
	g.presidente,
	g.director_Secretario,
	g.sindico,
	g.numero_Acciones,
	g.valor_Nominal,
	d_p.nro_Titulo,
	d_p.nro_Acciones,
	d_p.fecha_Emision,
CASE
		MONTH ( d_p.fecha_Emision ) 
		WHEN 1 THEN
		'Enero' 
		WHEN 2 THEN
		'Febrero' 
		WHEN 3 THEN
		'Marzo' 
		WHEN 4 THEN
		'Abril' 
		WHEN 5 THEN
		'Mayo' 
		WHEN 6 THEN
		'Junio' 
		WHEN 7 THEN
		'Julio' 
		WHEN 8 THEN
		'Agosto' 
		WHEN 9 THEN
		'Septiembre' 
		WHEN 10 THEN
		'Octubre' 
		WHEN 11 THEN
		'Noviembre' 
		WHEN 12 THEN
		'Diciembre' 
	END mes,
	CONCAT(
		'Sacaba ',
		DAY ( d_p.fecha_Emision ),
		' de ',
	CASE
			MONTH ( d_p.fecha_Emision ) 
			WHEN 1 THEN
			'Enero' 
			WHEN 2 THEN
			'Febrero' 
			WHEN 3 THEN
			'Marzo' 
			WHEN 4 THEN
			'Abril' 
			WHEN 5 THEN
			'Mayo' 
			WHEN 6 THEN
			'Junio' 
			WHEN 7 THEN
			'Julio' 
			WHEN 8 THEN
			'Agosto' 
			WHEN 9 THEN
			'Septiembre' 
			WHEN 10 THEN
			'Octubre' 
			WHEN 11 THEN
			'Noviembre' 
			WHEN 12 THEN
			'Diciembre' 
		END,
		' del ',
		YEAR ( d_p.fecha_Emision ) 
	) AS lf,
	
	CONCAT(
		'Sacaba ',
		DAY ( d_p.fecha_Inscripcion),
		' de ',
	CASE
			MONTH ( d_p.fecha_Inscripcion ) 
			WHEN 1 THEN
			'Enero' 
			WHEN 2 THEN
			'Febrero' 
			WHEN 3 THEN
			'Marzo' 
			WHEN 4 THEN
			'Abril' 
			WHEN 5 THEN
			'Mayo' 
			WHEN 6 THEN
			'Junio' 
			WHEN 7 THEN
			'Julio' 
			WHEN 8 THEN
			'Agosto' 
			WHEN 9 THEN
			'Septiembre' 
			WHEN 10 THEN
			'Octubre' 
			WHEN 11 THEN
			'Noviembre' 
			WHEN 12 THEN
			'Diciembre' 
		END,
		' del ',
		YEAR ( d_p.fecha_Inscripcion ) 
	) AS fi,
	
	
		CONCAT(UCASE(LEFT(lower (c_a.nombre), 1)), SUBSTRING(lower (c_a.nombre), 2)) AS clase_accion ,
	
		CONCAT(UCASE(LEFT(lower (s_a.nombre), 1)), SUBSTRING(lower (s_a.nombre), 2))  AS serie_acciones,
		
		CONCAT(UCASE(LEFT(lower (e_p.nombre), 1)), SUBSTRING(lower (e_p.nombre), 2))  AS estado_pago,
	
CONCAT(UCASE(LEFT(lower (t_a.nombre), 1)), SUBSTRING(lower (t_a.nombre), 2))  AS tipo_acciones,
CONCAT(UCASE(LEFT(lower (gr.nombre), 1)), SUBSTRING(lower (gr.nombre), 2))  AS gravamen,
	
	

	d_p.fecha_Inscripcion,
	lower( d_p.nro_Acciones_Literal ) AS nro_Acciones_literal,
	
CONCAT (
		s.ci,
		' ',
		com.alias ) AS CI,
	
	
	CONCAT(
		s.apellido_Paterno,
		' ',
		s.apellido_Materno,
		' ',
		s.apellido_Casada,
		' ',
		rtrim( s.nombres )
	) AS accionistas ,
		p_a.alias AS Nacionalidad,
		d_p.total_bs_literal,
			d_p.total_bs 
		
FROM
	socio AS s
	INNER JOIN derecho_propietario AS d_p ON s.id_dp = d_p.id_derecho_Propietario
	INNER JOIN gestion AS g ON d_p.gestion = g.id_Gestion
	INNER JOIN empresa AS e ON g.id_Empresa = e.id_Empresa
	INNER JOIN aux AS com ON s.ci_procedencia = com.id_aux
	INNER JOIN aux AS s_a ON d_p.serie_Acciones = s_a.id_aux
	INNER JOIN aux AS e_p ON d_p.estado_Pago = e_p.id_aux
	INNER JOIN aux AS t_a ON d_p.tipo_Acciones = t_a.id_aux
	INNER JOIN aux AS gr ON d_p.gravamen = gr.id_aux
	INNER JOIN aux AS c_a ON d_p.clase_Acciones = c_a.id_aux 
	INNER JOIN aux AS p_a ON s.pais_Nacimiento = p_a.id_aux   ,  (SELECT @row := 0) r

		
	where d_p.gestion  = 1  and s.tipo_accionista=29  and d_p.nro_Acciones>0
	ORDER BY 	s.apellido_Paterno asc]]>
	</queryString>
	<field name="nro" class="java.lang.Double">
		<property name="com.jaspersoft.studio.field.name" value="nro"/>
		<property name="com.jaspersoft.studio.field.label" value="nro"/>
	</field>
	<field name="id_derecho_Propietario" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="id_derecho_Propietario"/>
		<property name="com.jaspersoft.studio.field.label" value="id_derecho_Propietario"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="id_derecho_Propietario2" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="id_derecho_Propietario2"/>
		<property name="com.jaspersoft.studio.field.label" value="id_derecho_Propietario2"/>
	</field>
	<field name="nro_Partido" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="nro_Partido"/>
		<property name="com.jaspersoft.studio.field.label" value="nro_Partido"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="nro_Folio" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="nro_Folio"/>
		<property name="com.jaspersoft.studio.field.label" value="nro_Folio"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="gestion" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nombre"/>
		<property name="com.jaspersoft.studio.field.label" value="gestion"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="gestion"/>
	</field>
	<field name="Empresa" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nombre"/>
		<property name="com.jaspersoft.studio.field.label" value="Empresa"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="empresa"/>
	</field>
	<field name="nit" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nit"/>
		<property name="com.jaspersoft.studio.field.label" value="nit"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="empresa"/>
	</field>
	<field name="matricula_Comercio" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="matricula_Comercio"/>
		<property name="com.jaspersoft.studio.field.label" value="matricula_Comercio"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="empresa"/>
	</field>
	<field name="capital_Autorizado" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="capital_Autorizado"/>
		<property name="com.jaspersoft.studio.field.label" value="capital_Autorizado"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="empresa"/>
	</field>
	<field name="capital_Pagado" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="capital_Pagado"/>
		<property name="com.jaspersoft.studio.field.label" value="capital_Pagado"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="empresa"/>
	</field>
	<field name="lugar_Constitucion" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="lugar_Constitucion"/>
		<property name="com.jaspersoft.studio.field.label" value="lugar_Constitucion"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="empresa"/>
	</field>
	<field name="fecha_Constitucion" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.name" value="fecha_Constitucion"/>
		<property name="com.jaspersoft.studio.field.label" value="fecha_Constitucion"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="empresa"/>
	</field>
	<field name="duracion" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="duracion"/>
		<property name="com.jaspersoft.studio.field.label" value="duracion"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="empresa"/>
	</field>
	<field name="domicilio" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="domicilio"/>
		<property name="com.jaspersoft.studio.field.label" value="domicilio"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="empresa"/>
	</field>
	<field name="presidente" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="presidente"/>
		<property name="com.jaspersoft.studio.field.label" value="presidente"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="gestion"/>
	</field>
	<field name="director_Secretario" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="director_Secretario"/>
		<property name="com.jaspersoft.studio.field.label" value="director_Secretario"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="gestion"/>
	</field>
	<field name="sindico" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="sindico"/>
		<property name="com.jaspersoft.studio.field.label" value="sindico"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="gestion"/>
	</field>
	<field name="numero_Acciones" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="numero_Acciones"/>
		<property name="com.jaspersoft.studio.field.label" value="numero_Acciones"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="gestion"/>
	</field>
	<field name="valor_Nominal" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="valor_Nominal"/>
		<property name="com.jaspersoft.studio.field.label" value="valor_Nominal"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="gestion"/>
	</field>
	<field name="nro_Titulo" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="nro_Titulo"/>
		<property name="com.jaspersoft.studio.field.label" value="nro_Titulo"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="nro_Acciones" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="nro_Acciones"/>
		<property name="com.jaspersoft.studio.field.label" value="nro_Acciones"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="fecha_Emision" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.name" value="fecha_Emision"/>
		<property name="com.jaspersoft.studio.field.label" value="fecha_Emision"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="mes" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="mes"/>
		<property name="com.jaspersoft.studio.field.label" value="mes"/>
	</field>
	<field name="lf" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="lf"/>
		<property name="com.jaspersoft.studio.field.label" value="lf"/>
	</field>
	<field name="fi" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="fi"/>
		<property name="com.jaspersoft.studio.field.label" value="fi"/>
	</field>
	<field name="clase_accion" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="clase_accion"/>
		<property name="com.jaspersoft.studio.field.label" value="clase_accion"/>
	</field>
	<field name="serie_acciones" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="serie_acciones"/>
		<property name="com.jaspersoft.studio.field.label" value="serie_acciones"/>
	</field>
	<field name="estado_pago" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="estado_pago"/>
		<property name="com.jaspersoft.studio.field.label" value="estado_pago"/>
	</field>
	<field name="tipo_acciones" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="tipo_acciones"/>
		<property name="com.jaspersoft.studio.field.label" value="tipo_acciones"/>
	</field>
	<field name="gravamen" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="gravamen"/>
		<property name="com.jaspersoft.studio.field.label" value="gravamen"/>
	</field>
	<field name="fecha_Inscripcion" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.name" value="fecha_Inscripcion"/>
		<property name="com.jaspersoft.studio.field.label" value="fecha_Inscripcion"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="nro_Acciones_literal" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="nro_Acciones_literal"/>
		<property name="com.jaspersoft.studio.field.label" value="nro_Acciones_literal"/>
	</field>
	<field name="CI" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="CI"/>
		<property name="com.jaspersoft.studio.field.label" value="CI"/>
	</field>
	<field name="accionistas" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="accionistas"/>
		<property name="com.jaspersoft.studio.field.label" value="accionistas"/>
	</field>
	<field name="Nacionalidad" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="alias"/>
		<property name="com.jaspersoft.studio.field.label" value="Nacionalidad"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="aux"/>
	</field>
	<field name="total_bs_literal" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="total_bs_literal"/>
		<property name="com.jaspersoft.studio.field.label" value="total_bs_literal"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<field name="total_bs" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="total_bs"/>
		<property name="com.jaspersoft.studio.field.label" value="total_bs"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="derecho_propietario"/>
	</field>
	<title>
		<band height="76">
			<staticText>
				<reportElement x="0" y="20" width="200" height="10" uuid="50b676c1-377d-43b8-8884-6e0584ac6e90">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="6"/>
				</textElement>
				<text><![CDATA[TELF. 4703288-4703398]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="30" width="200" height="10" uuid="d22aeb0c-ec4e-437f-8082-1602635423ef">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="6"/>
				</textElement>
				<text><![CDATA[SACABA - COCHABAMBA - BOLIVIA]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="0" width="200" height="10" uuid="8c7850e1-e71e-4d50-b90e-93d190e605b8">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="6"/>
				</textElement>
				<text><![CDATA[E°S°  TRANS ROSA DE LIMA S.A.]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="10" width="200" height="10" uuid="5619d2e6-6b47-4b3c-ae6d-378c9415d1cb">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="6"/>
				</textElement>
				<text><![CDATA[AV. BARRIENTOS S/N  KM 16 ZONA VILLA OBRA OBRAJES]]></text>
			</staticText>
			<staticText>
				<reportElement x="4" y="43" width="535" height="30" uuid="105c44d9-1a91-4423-8361-4b4cd990eaf1"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="16"/>
				</textElement>
				<text><![CDATA[PLANILLA DE PAGO DE DIVIDENDOS GESTIÓN 2022]]></text>
			</staticText>
		</band>
	</title>
	<columnHeader>
		<band height="31">
			<staticText>
				<reportElement x="269" y="1" width="49" height="28" uuid="9ed247c7-eeeb-4e4e-accd-fdd5dd6d7aa0">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c7499de7-485d-4365-bf6a-9c6c5c5214a4"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<text><![CDATA[N° ACCIONES]]></text>
			</staticText>
			<staticText>
				<reportElement x="1" y="1" width="36" height="28" uuid="9deb5142-ee93-48a7-873e-db661708a3b4">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b2c5078b-7bd2-42d7-a124-1127ee04128a"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<text><![CDATA[N° ]]></text>
			</staticText>
			<staticText>
				<reportElement x="37" y="1" width="172" height="28" uuid="397f96f5-b84a-4243-a6d8-f25840b17a72">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="08f265ef-5eb2-4855-a16a-373970afd96e"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<text><![CDATA[NOMBRE DEL ACCIONISTA]]></text>
			</staticText>
			<staticText>
				<reportElement x="209" y="1" width="60" height="28" uuid="d98b83ad-9359-4e5d-81a5-d52315429e3b">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="49363da5-a8be-4d4b-87a3-19c7516231f3"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<text><![CDATA[CI]]></text>
			</staticText>
			<staticText>
				<reportElement x="318" y="1" width="82" height="28" uuid="b9a04efc-b8b7-4869-9fa9-3d0c2210c5f7">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3c716b83-edab-4a37-b8c7-c23a7c4c9332"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<text><![CDATA[TOTAL DIVIDENDO A PAGAR]]></text>
			</staticText>
			<staticText>
				<reportElement x="400" y="1" width="73" height="28" uuid="10b09eb0-94ff-4f33-84de-5c130ad04c29">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3c716b83-edab-4a37-b8c7-c23a7c4c9332"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<text><![CDATA[FIRMA]]></text>
			</staticText>
			<staticText>
				<reportElement x="473" y="1" width="66" height="28" uuid="58e46faa-5bbe-45b4-9717-ebfef788b86e">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3c716b83-edab-4a37-b8c7-c23a7c4c9332"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<text><![CDATA[FECHA DE PAGO]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="40">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField>
				<reportElement x="269" y="0" width="49" height="40" uuid="85963264-3777-41fd-9f9f-84fb564f236d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c7499de7-485d-4365-bf6a-9c6c5c5214a4"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<pen lineStyle="Dotted"/>
					<topPen lineWidth="1.0" lineStyle="Dotted"/>
					<leftPen lineWidth="1.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="1.0" lineStyle="Dotted"/>
					<rightPen lineWidth="1.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nro_Acciones}]]></textFieldExpression>
			</textField>
			<textField pattern="#,###.###;(#,###.###-)">
				<reportElement x="1" y="0" width="36" height="40" uuid="1d77a84a-ea0f-43be-a4bd-e5b2c7222b81">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b2c5078b-7bd2-42d7-a124-1127ee04128a"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
				</reportElement>
				<box>
					<pen lineStyle="Dotted"/>
					<topPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/>
					<bottomPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/>
					<rightPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nro}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="38" y="0" width="171" height="40" uuid="48e24c3d-c2fa-42a7-bdc2-db1ac247d5fa">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="08f265ef-5eb2-4855-a16a-373970afd96e"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<box>
					<pen lineWidth="1.0" lineStyle="Dotted"/>
					<topPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/>
					<leftPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/>
					<bottomPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/>
					<rightPen lineWidth="1.0" lineStyle="Dotted" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[" "+$F{accionistas}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="209" y="0" width="60" height="40" uuid="236ff41f-4147-4779-b2b7-ecad4de51add">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="49363da5-a8be-4d4b-87a3-19c7516231f3"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<box>
					<pen lineWidth="1.0" lineStyle="Dotted"/>
					<topPen lineWidth="1.0" lineStyle="Dotted"/>
					<leftPen lineWidth="1.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="1.0" lineStyle="Dotted"/>
					<rightPen lineWidth="1.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CI}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00#;(#,##0.00#-)">
				<reportElement x="339" y="0" width="61" height="40" uuid="ea65f69d-9c8a-494d-89a4-5a773520b65f">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3c716b83-edab-4a37-b8c7-c23a7c4c9332"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="1.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="1.0" lineStyle="Dotted"/>
					<rightPen lineWidth="1.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{total_bs}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="318" y="0" width="21" height="40" uuid="23005bd1-9a55-4dae-957c-61ba7d2f4360">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3c716b83-edab-4a37-b8c7-c23a7c4c9332"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="1.0" lineStyle="Dotted"/>
					<leftPen lineWidth="1.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="1.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<text><![CDATA[Bs.]]></text>
			</staticText>
			<staticText>
				<reportElement x="400" y="0" width="73" height="40" uuid="a55de0a2-e63e-4d2f-b308-d8ed93dd6694">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3c716b83-edab-4a37-b8c7-c23a7c4c9332"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<pen lineWidth="1.0" lineStyle="Dotted"/>
					<topPen lineWidth="1.0" lineStyle="Dotted"/>
					<leftPen lineWidth="1.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="1.0" lineStyle="Dotted"/>
					<rightPen lineWidth="1.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement x="473" y="0" width="66" height="40" uuid="c7b3af75-9efd-4cc8-b107-dd5424a60a46">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3c716b83-edab-4a37-b8c7-c23a7c4c9332"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<pen lineStyle="Dotted"/>
					<topPen lineWidth="1.0" lineStyle="Dotted"/>
					<leftPen lineWidth="1.0" lineStyle="Dotted"/>
					<bottomPen lineWidth="1.0" lineStyle="Dotted"/>
					<rightPen lineWidth="1.0" lineStyle="Dotted"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
				<text><![CDATA[]]></text>
			</staticText>
		</band>
	</detail>
	<pageFooter>
		<band height="21">
			<textField>
				<reportElement x="395" y="1" width="75" height="15" uuid="281dd033-41a9-47ce-9ba5-a8be4b491cc5">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA["Pagina " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement x="470" y="1" width="69" height="15" uuid="d85da5b9-8f80-444e-a550-d7c0e4892943">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
				</reportElement>
				<textElement textAlignment="Left">
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[" de  " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>
