0 or arm.peso>0)
group by arm.codigoarma))) a
left join tarmregistroarmas ra on ra.cregistro = a.cregistro
inner join tcustpersondetail pd on pd.personcode = ra.personcode and to_char(pd.dateto,'yyyy-MM-dd')='2999-12-31'
inner join tarmtipoarmaexplosivo tae on a.ctipoarmaexplosivo = tae.ctipoarmaexplosivo
where ra.fechasolicitud between to_date( $P{fechainicial} ,'dd/MM/yyyy') and to_date( $P{fechafinal} ,'dd/MM/yyyy')
$P!{filtro}]]>
<band height="104" splitType="Stretch">
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
<staticText>
<reportElement style="title1" x="280" y="0" width="580" height="20" forecolor="#000000" uuid="a5555ed3-8bce-44fd-afbb-28084239a1a1"/>
<textElement textAlignment="Center"/>
<text><![CDATA[COMANDO CONJUNTO DE LAS FUERZAS ARMADAS]]></text>
</staticText>
<staticText>
<reportElement key="" style="title1" x="280" y="20" width="580" height="20" forecolor="#000000" uuid="98c268e9-4cb8-4184-9c02-537b79b6957c"/>
<textElement textAlignment="Center"/>
<text><![CDATA[DEPARTAMENTO DE CONTROL DE ARMAS]]></text>
</staticText>
<image>
<reportElement x="170" y="0" width="110" height="80" uuid="5c1c706c-0485-4d8f-be4c-9ad18ad76225">
<property name="local_mesure_unitwidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<imageExpression><![CDATA[$P{pathLogoIzquierda}]]></imageExpression>
</image>
<image>
<reportElement x="860" y="0" width="90" height="80" uuid="560083e4-2ae5-4b08-9886-6b1c828f2fe1">
<property name="local_mesure_unitwidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.width" value="px"/>
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<imageExpression><![CDATA[$P{pathLogoDerecha}]]></imageExpression>
</image>
<textField>
<reportElement style="title2" x="280" y="40" width="580" height="15" uuid="ea5cd989-52eb-4392-9940-c68a2a603e7a">
<property name="local_mesure_unity" value="pixel"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box topPadding="2"/>
<textElement textAlignment="Center" verticalAlignment="Top"/>
<textFieldExpression><![CDATA[$P{centroControl}]]></textFieldExpression>
</textField>
<textField>
<reportElement style="title2" x="170" y="80" width="780" height="24" uuid="e4232f8e-30f1-4024-92e4-9e55f09dea20">
<property name="local_mesure_unity" value="pixel"/>
<property name="com.jaspersoft.studio.unit.y" value="px"/>
<property name="local_mesure_unitheight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.height" value="px"/>
</reportElement>
<box topPadding="2"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$P{titulo}]]></textFieldExpression>
</textField>
<staticText>
<reportElement key="" style="title1" x="280" y="55" width="580" height="25" forecolor="#000000" uuid="49f68429-8b74-4f6f-bb2f-b588aeb62315"/>
<textElement textAlignment="Center"/>
<text><![CDATA[]]></text>
</staticText>
</band>