230201
[[code]]
<?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="invalid" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="pH" class="java.lang.String">
<defaultValueExpression><![CDATA["h2"]]></defaultValueExpression>
</parameter>
<parameter name="pType" class="java.lang.String">
<defaultValueExpression><![CDATA["m"]]></defaultValueExpression>
</parameter>
<parameter name="pServ" class="java.lang.String">
<defaultValueExpression><![CDATA["2"]]></defaultValueExpression>
</parameter>
<parameter name="pStamp" class="java.lang.String">
<defaultValueExpression><![CDATA["200910081500"]]></defaultValueExpression>
</parameter>
<queryString language="SQL">
<![CDATA[select
h.tstamp,
s.code, s.name, s.type, s.unit, s.nserv,
format (h.a_val,4) a_val,h.a_stat,h.a_count
from
airs.svodcode s
left outer join airs.$P!{pH} h ON (s.code=h.code)
where
s.type=$P{pType} and s.nserv=$P{pServ} and h.tstamp=$P{pStamp}
and h.a_stat='1';]]>
</queryString>
<field name="tstamp" class="java.lang.String"/>
<field name="code" class="java.lang.String"/>
<field name="name" class="java.lang.String"/>
<field name="type" class="java.lang.String"/>
<field name="unit" class="java.lang.String"/>
<field name="nserv" class="java.lang.Integer"/>
<field name="a_val" class="java.lang.String"/>
<field name="a_stat" class="java.lang.String"/>
<field name="a_count" class="java.lang.Integer"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="66" splitType="Stretch">
<staticText>
<reportElement x="158" y="19" width="242" height="22"/>
<textElement>
<font size="14" pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<text><![CDATA[Журнал недостоверных значений]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="35" splitType="Stretch">
<textField>
<reportElement x="442" y="0" width="100" height="20"/>
<textElement/>
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="383" y="0" width="58" height="20"/>
<textElement>
<font pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<text><![CDATA[Страница:]]></text>
</staticText>
<textField pattern="dd/MM/yyyy HH.mm.ss">
<reportElement x="40" y="0" width="100" height="20"/>
<textElement/>
<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="52" splitType="Stretch">
<staticText>
<reportElement x="40" y="0" width="61" height="20"/>
<textElement>
<font pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<text><![CDATA[Код]]></text>
</staticText>
<staticText>
<reportElement x="138" y="0" width="61" height="20"/>
<textElement>
<font pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<text><![CDATA[Имя]]></text>
</staticText>
<staticText>
<reportElement x="322" y="0" width="61" height="20"/>
<textElement>
<font pdfFontName="arial.ttf" pdfEncoding="Cp1251" isPdfEmbedded="false"/>
</textElement>
<text><![CDATA[Ед. Изм.]]></text>
</staticText>
<staticText>
<reportElement x="424" y="0" width="61" height="20"/>
<textElement>
<font isStrikeThrough="false" pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<text><![CDATA[Значение]]></text>
</staticText>
<staticText>
<reportElement x="230" y="0" width="61" height="20"/>
<textElement>
<font pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<text><![CDATA[Счетчик]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="125" splitType="Stretch">
<textField>
<reportElement x="40" y="0" width="61" height="20"/>
<textElement>
<font pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{code}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="138" y="0" width="61" height="20"/>
<textElement>
<font pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{name}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="322" y="0" width="61" height="20"/>
<textElement>
<font pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{unit}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="424" y="0" width="61" height="20"/>
<textElement>
<font pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{a_val}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="230" y="0" width="61" height="20"/>
<textElement>
<font pdfFontName="arial.ttf" pdfEncoding="Cp1251"/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$F{a_count}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="45" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>
[[/code]]
Назад