<?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="consumo" pageWidth="160" pageHeight="160" columnWidth="115" leftMargin="10" 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.report.description" value=""/>
	<property name="com.jaspersoft.studio.unit." value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
	<parameter name="P1" class="java.lang.Integer">
		<parameterDescription><![CDATA[placa]]></parameterDescription>
	</parameter>
	<queryString language="SQL">
		<![CDATA[SELECT
	p.id, 

	p.placa, 

	v.VOLUMEN_TOTAL
	
	
	
	
FROM
	pro_participante AS p
	INNER JOIN
	placas_total AS v
	ON 
		p.placa = v.PLACA
		
		where p.id = $P{P1}]]>
	</queryString>
	<field name="id" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="id"/>
		<property name="com.jaspersoft.studio.field.label" value="id"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pro_participante"/>
	</field>
	<field name="placa" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="placa"/>
		<property name="com.jaspersoft.studio.field.label" value="placa"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="pro_participante"/>
	</field>
	<field name="VOLUMEN_TOTAL" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="VOLUMEN_TOTAL"/>
		<property name="com.jaspersoft.studio.field.label" value="VOLUMEN_TOTAL"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="placas_total"/>
	</field>
	<pageHeader>
		<band height="110" splitType="Stretch">
			<property name="com.jaspersoft.studio.unit.height" value="px"/>
			<textField pattern="#,000.###;(#,000.###-)">
				<reportElement x="2" y="34" width="128" height="15" forecolor="#F52C16" uuid="c9ea00d2-927f-413d-9ae6-aea85d4d4839">
					<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="9" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA["PLACA N°: " + $F{placa}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="2" y="0" width="128" height="10" uuid="8c7850e1-e71e-4d50-b90e-93d190e605b8">
					<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="7"/>
				</textElement>
				<text><![CDATA[E°S°  TRANS ROSA DE LIMA S.A.]]></text>
			</staticText>
			<staticText>
				<reportElement x="2" y="10" width="128" height="20" uuid="5619d2e6-6b47-4b3c-ae6d-378c9415d1cb">
					<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="7"/>
				</textElement>
				<text><![CDATA[AV. BARRIENTOS S/N  KM 16 ZONA VILLA OBRA OBRAJES]]></text>
			</staticText>
			<textField pattern="#,000.###;(#,000.###-)">
				<reportElement x="2" y="74" width="128" height="15" forecolor="#F52C16" uuid="2c9d3cd4-5e42-48b6-b041-e10fbbb99984">
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Tahoma" size="9" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{VOLUMEN_TOTAL} + " M3"]]></textFieldExpression>
			</textField>
			<textField pattern="d/M/yyyy h:mm a">
				<reportElement x="50" y="97" width="80" height="10" uuid="ea5992ce-e2e5-418d-85b8-ed4e12c29561">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement verticalAlignment="Middle">
					<font fontName="Tahoma" size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="6" y="97" width="44" height="10" uuid="a8d5cf98-69e3-4738-91ed-5de8a2097b87"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font fontName="Tahoma" size="7"/>
				</textElement>
				<text><![CDATA[Impreso el :    ]]></text>
			</staticText>
			<staticText>
				<reportElement x="2" y="59" width="128" height="15" forecolor="#F2211D" uuid="fb277302-c36c-4e61-a2ea-66290ee37479">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font fontName="Tahoma" size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[VOLUMEN ACUMULADO:]]></text>
			</staticText>
		</band>
	</pageHeader>
</jasperReport>
