33 lines
1.7 KiB
XML
Executable File
33 lines
1.7 KiB
XML
Executable File
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!-- Created with Jaspersoft Studio version 5.6.1.final using JasperReports Library version 5.6.1 -->
|
|
<!-- 2014-11-17T16:15:04 -->
|
|
<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="firmaGeneralReport" pageWidth="308" pageHeight="115" columnWidth="308" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="c7090c29-86ef-481a-9a47-13914ed129f0">
|
|
<parameter name="codResponsable" class="java.lang.String"/>
|
|
<queryString language="SQL">
|
|
<![CDATA[select pd.personcode as RESPONSABLE,
|
|
pd.sign as FIRMA
|
|
from tcustpersondetail pd
|
|
where pd.personcode = $P{codResponsable} and
|
|
pd.dateto=(select max(person2.dateto) from tcustpersondetail person2 where person2.personcode= $P{codResponsable})]]>
|
|
</queryString>
|
|
<field name="FIRMA" class="java.io.InputStream">
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<detail>
|
|
<band height="115" splitType="Stretch">
|
|
<image>
|
|
<reportElement x="-1" y="0" width="308" height="115" uuid="03829340-a107-4085-a10d-60e9332bbf7e">
|
|
<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[$F{FIRMA}]]></imageExpression>
|
|
</image>
|
|
</band>
|
|
</detail>
|
|
</jasperReport>
|