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]] |
Назад |