Есть отчет который не формируется и выдает в клиенте следующее
Код:
java.lang.Exception: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{pay} at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:328)
at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:412)
at bitel.billing.server.reports.Report_Default.fillReportToStream(Report_Default.java:27)
at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:56)
at bitel.billing.server.Executer.doModule(Unknown Source)
at bitel.billing.server.Executer$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at bitel.billing.server.Executer.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{pay} at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:259)
at net.sf.jasperreports.engine.fill.JRCalculator.evaluateEstimated(JRCalculator.java:580)
at net.sf.jasperreports.engine.fill.JRCalculator.estimateVariables(JRCalculator.java:179)
at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:787)
at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1482)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:130)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:864)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:84)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToStream(JasperFillManager.java:582)
at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:324)
... 30 moreCaused by: java.lang.ClassCastException: java.lang.String cannot be cast to java.math.BigDecimal at kernel_ost_change_1333430593960_151937.evaluateEstimated(kernel_ost_change_1333430593960_151937:506)
at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:246)
... 41 more
Решил на винде поднять тестовый стенд сервера чтобы удобнее править было, отчет на нем сформировался и вывел результат. Подумал, на тестовом стенде билд последний, обновить нужно боевой сервер, обновил и перезапустил, результат тоже. В чем мб причина, неужели в яве?
С др. отчетами проблем нет, и клиент использовал один и тот же.
Конфигурация на которой формируется отчет:Клиент: вер. 5.2 сборка 959 от 01.04.2012 00:13:41
os: Windows 7; java: Java HotSpot(TM) Client VM, v.1.6.0_29
ВНИМАНИЕ: Необходимо обновить таймзоны
Сервер: вер. 5.2 сборка 1142 от 03.04.2012 01:10:16
os: Windows 7; java: Java HotSpot(TM) Client VM, v.1.6.0_29
ВНИМАНИЕ: Необходимо обновить таймзоны
reports вер. 5.2 сборка 172 от 30.03.2012 12:51:20
Конфигурация на которой не формируется отчет: Клиент: вер. 5.2 сборка 959 от 01.04.2012 00:13:41
os: Windows 7; java: Java HotSpot(TM) Client VM, v.1.6.0_29
ВНИМАНИЕ: Необходимо обновить таймзоны
Сервер: вер. 5.2 сборка 1142 от 03.04.2012 01:10:16
os: Linux; java: Java HotSpot(TM) 64-Bit Server VM, v.1.6.0_31
reports вер. 5.2 сборка 172 от 30.03.2012 12:51:20
Сам отчет:
Код:
<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="kernel_ost_change"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="595"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />
<style
name="Center"
isDefault="false"
hAlign="Center"
padding="0"
topPadding="1"
leftPadding="2"
bottomPadding="1"
rightPadding="1"
>
<box leftPadding="2" rightPadding="1" topPadding="1" bottomPadding="1"></box>
</style>
<style
name="border"
isDefault="false"
border="Thin"
borderColor="#000000"
>
<box> <pen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
<topPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.25" lineStyle="Solid" lineColor="#000000"/>
</box>
</style>
<style
name="Right"
isDefault="false"
hAlign="Right"
topPadding="1"
leftPadding="1"
bottomPadding="1"
rightPadding="1"
>
<box leftPadding="1" rightPadding="1" topPadding="1" bottomPadding="1"></box>
</style>
<parameter name="_filter" isForPrompting="false" class="bitel.billing.server.admin.reports.BGReportFilter"/>
<parameter name="_months" isForPrompting="false" class="java.util.Map"/>
<queryString language="bgbs"><![CDATA[import java.sql.*;
import java.util.*;
import java.util.regex.*;
import bitel.billing.common.*;
import bitel.billing.server.util.*;
import bitel.billing.server.contract.bean.*;
import ru.bitel.common.Utils;
createTmpTable( con, tableName, month )
{
con.createStatement().executeUpdate( "DROP TABLE IF EXISTS " + tableName );
query =
"CREATE TEMPORARY TABLE " + tableName + " ( UNIQUE(cid) ) " +
"SELECT cid, MAX(yy*12+(mm-1))%12 + 1 AS mm," +
"FLOOR(MAX(yy*12+(mm-1)) / 12) AS yy " +
"FROM contract_balance " +
"WHERE (yy< ?) OR (yy=? AND mm<=?) " +
"GROUP BY cid";
ps = con.prepareStatement( query );
ps.setInt( 1, month.get( Calendar.YEAR ) );
ps.setInt( 2, month.get( Calendar.YEAR ) );
ps.setInt( 3, month.get( Calendar.MONTH ) + 1 );
ps.executeUpdate();
}
public void fillReport( con, filter, result )
{
monthFrom = filter.getCalendarParam( "month_from" );
monthTo = TimeUtils.getEndMonth( filter.getCalendarParam( "month_to" ) );
status = filter.getIntParam( "status" );
limit = filter.getIntParam( "limit" );
gr = filter.getLongParam( "gr" );
tableFromName = "temp_balance_ost_rep_from";
tableToName = "temp_balance_ost_rep_to";
tableSumName = "temp_balance_ost_sums";
createTmpTable( con, tableFromName, monthFrom );
createTmpTable( con, tableToName, monthTo );
con.createStatement().executeUpdate( "DROP TABLE IF EXISTS " + tableSumName );
query = "CREATE TABLE " + tableSumName + " (UNIQUE(cid)) " +
"SELECT cid, SUM(summa2) AS summa2, SUM(summa3) AS summa3, SUM(summa4) AS summa4 FROM contract_balance " +
"INNER JOIN contract ON contract_balance.cid=contract.id ";
if ( gr > 0 )
{
query += " AND contract.gr&" + gr + ">0 ";
}
query += "WHERE (yy*12 + mm)>=? AND (yy*12 + mm)<=? " +
"GROUP BY cid" ;
ps = con.prepareStatement( query );
ps.setInt( 1, monthFrom.get( Calendar.YEAR) * 12 + monthFrom.get( Calendar.MONTH ) + 1 );
ps.setInt( 2, monthTo.get( Calendar.YEAR) * 12 + monthTo.get( Calendar.MONTH ) + 1 );
ps.executeUpdate();
query = "SELECT contract.title, IF(vhm.yy=? AND vhm.mm=?, vh.summa1, (vh.summa1 + vh.summa2 - vh.summa3 - vh.summa4)), sum.summa2, sum.summa3, sum.summa4, (ish.summa1 + ish.summa2 - ish.summa3 - ish.summa4) " +
"FROM contract " +
"LEFT JOIN " + tableFromName + " AS vhm ON contract.id=vhm.cid " +
"LEFT JOIN contract_balance AS vh ON contract.id=vh.cid AND vhm.yy=vh.yy AND vhm.mm=vh.mm " +
"LEFT JOIN " + tableToName + " AS ishm ON contract.id=ishm.cid " +
"LEFT JOIN contract_balance AS ish ON contract.id=ish.cid AND ishm.yy=ish.yy AND ishm.mm=ish.mm " +
"LEFT JOIN " + tableSumName + " AS sum ON contract.id=sum.cid " +
"WHERE contract.scid=0 AND contract.date1<=? AND (contract.date2 IS NULL OR contract.date2>=?) AND (ish.summa1 + ish.summa2 - ish.summa3 - ish.summa4)>0 ";
if( gr > 0 )
{
query += " AND contract.gr&" + gr + ">0 ";
}
query += "ORDER BY contract.id";
res = new ArrayList( 1000 );
ps = con.prepareStatement( query );
ps.setInt( 1, monthFrom.get( Calendar.YEAR ) );
ps.setInt( 2, monthFrom.get( Calendar.MONTH ) + 1 );
ps.setDate( 3, TimeUtils.convertCalendarToSqlDate( monthTo ) );
ps.setDate( 4, TimeUtils.convertCalendarToSqlDate( monthFrom ) );
rs = ps.executeQuery();
while ( rs.next() )
{
Map map = new HashMap( 6 );
map.put( "title", rs.getString( 1 ) );
map.put( "in_rest", Utils.maskNull( rs.getBigDecimal( 2 ) ) );
map.put( "pay", Utils.maskNull( rs.getBigDecimal( 3 ) ) );
map.put( "account", Utils.maskNull( rs.getBigDecimal( 4 ) ) );
map.put( "charge", Utils.maskNull( rs.getBigDecimal( 5 ) ) );
myyyy= Utils.maskNull(rs.getBigDecimal( 6 ));
map.put( "out_rest", myyyy );
res.add( map );
}
result.setDataSource( res );
result.setParams( new HashMap( 1 ) );
con.createStatement().executeUpdate( "DROP TABLE IF EXISTS " + tableFromName );
con.createStatement().executeUpdate( "DROP TABLE IF EXISTS " + tableToName );
con.createStatement().executeUpdate( "DROP TABLE IF EXISTS " + tableSumName );
}]]></queryString>
<field name="title" class="java.lang.String"/>
<field name="in_rest" class="java.math.BigDecimal"/>
<field name="pay" class="java.math.BigDecimal"/>
<field name="charge" class="java.math.BigDecimal"/>
<field name="account" class="java.math.BigDecimal"/>
<field name="out_rest" class="java.math.BigDecimal"/>
<variable name="pay_sum" class="java.math.BigDecimal" resetType="Report" calculation="Sum">
<variableExpression><![CDATA[$F{pay}]]></variableExpression>
</variable>
<variable name="charge_sum" class="java.math.BigDecimal" resetType="Report" calculation="Sum">
<variableExpression><![CDATA[$F{charge}]]></variableExpression>
</variable>
<variable name="account_sum" class="java.math.BigDecimal" resetType="Report" calculation="Sum">
<variableExpression><![CDATA[$F{account}]]></variableExpression>
</variable>
<variable name="in_sum" class="java.math.BigDecimal" resetType="Report" calculation="Sum">
<variableExpression><![CDATA[$F{in_rest}]]></variableExpression>
</variable>
<variable name="out_sum" class="java.math.BigDecimal" resetType="Report" calculation="Sum">
<variableExpression><![CDATA[$F{out_rest}]]></variableExpression>
</variable>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="70" isSplitAllowed="true" >
<staticText>
<reportElement
mode="Opaque"
x="0"
y="0"
width="535"
height="20"
forecolor="#000000"
backcolor="#FFFFFF"
key="element-1"/>
<box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Bottom" rotation="None" lineSpacing="Single">
<font fontName="Arial" pdfFontName="conf/arial.ttf" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded ="true" pdfEncoding ="Cp1251" isStrikeThrough="false" />
</textElement>
<text><![CDATA[Отчет по остаткам (положительные)]]></text>
</staticText>
<rectangle radius="0" >
<reportElement
mode="Opaque"
x="0"
y="29"
width="535"
height="40"
forecolor="#000000"
backcolor="#E1E1E1"
key="element-3"/>
<graphicElement stretchType="NoStretch" fill="Solid" >
<pen lineWidth="0.25" lineStyle="Solid"/>
</graphicElement>
</rectangle>
<staticText>
<reportElement
style="Center"
x="41"
y="29"
width="109"
height="40"
key="staticText-15"/>
<box leftPadding="3" rightPadding="3" topPadding="2" bottomPadding="2"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font fontName="SansSerif" pdfFontName="conf/arial.ttf" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<text><![CDATA[N договора]]></text>
</staticText>
<staticText>
<reportElement
style="Center"
x="150"
y="29"
width="72"
height="40"
key="staticText-16"/>
<box leftPadding="3" rightPadding="3" topPadding="2" bottomPadding="2"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<text><![CDATA[Вх. остаток]]></text>
</staticText>
<staticText>
<reportElement
style="Center"
x="222"
y="29"
width="75"
height="40"
key="staticText-17"/>
<box leftPadding="3" rightPadding="3" topPadding="2" bottomPadding="2"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<text><![CDATA[Приход]]></text>
</staticText>
<staticText>
<reportElement
style="Center"
x="0"
y="29"
width="41"
height="40"
key="staticText-25"/>
<box leftPadding="3" rightPadding="3" topPadding="2" bottomPadding="2"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font fontName="SansSerif" pdfFontName="conf/arial.ttf" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<text><![CDATA[N п/п]]></text>
</staticText>
<staticText>
<reportElement
style="Center"
x="297"
y="29"
width="72"
height="40"
key="staticText-26"/>
<box leftPadding="3" rightPadding="3" topPadding="2" bottomPadding="2"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<text><![CDATA[Расход]]></text>
</staticText>
<staticText>
<reportElement
style="Center"
x="448"
y="29"
width="87"
height="40"
key="staticText-27"/>
<box leftPadding="3" rightPadding="3" topPadding="2" bottomPadding="2"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<text><![CDATA[Исх. остаток]]></text>
</staticText>
<staticText>
<reportElement
style="Center"
x="369"
y="29"
width="79"
height="40"
key="staticText-28"/>
<box leftPadding="3" rightPadding="3" topPadding="2" bottomPadding="2"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<text><![CDATA[Наработка]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="0" isSplitAllowed="true" >
<line direction="TopDown">
<reportElement
x="0"
y="-1"
width="534"
height="0"
key="line-6">
<printWhenExpression><![CDATA[Boolean.valueOf( $V{PAGE_NUMBER}.intValue()!=1 )]]></printWhenExpression>
</reportElement>
<graphicElement stretchType="NoStretch">
<pen lineWidth="0.25" lineStyle="Solid"/>
</graphicElement>
</line>
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="15" isSplitAllowed="true" >
<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="150"
y="0"
width="72"
height="14"
key="textField-14"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{in_rest}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="222"
y="0"
width="75"
height="14"
key="textField-15"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{pay}]]></textFieldExpression>
</textField>
<line direction="TopDown">
<reportElement
x="0"
y="14"
width="534"
height="0"
key="line-5"
positionType="FixRelativeToBottom"/>
<graphicElement stretchType="NoStretch">
<pen lineWidth="0.25" lineStyle="Solid"/>
</graphicElement>
</line>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="0"
width="41"
height="14"
key="textField-20"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="297"
y="0"
width="72"
height="14"
key="textField-22"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{charge}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="448"
y="0"
width="87"
height="14"
key="textField-23"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{out_rest}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="369"
y="0"
width="79"
height="14"
key="textField-24"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{account}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="41"
y="0"
width="109"
height="14"
key="textField-25"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{title}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="0" isSplitAllowed="true" >
</band>
</pageFooter>
<summary>
<band height="14" isSplitAllowed="true" >
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="0"
y="0"
width="41"
height="14"
key="textField-26"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="41"
y="0"
width="109"
height="14"
key="textField-27"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Итого"]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="150"
y="0"
width="72"
height="14"
key="textField-28"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{in_sum}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="222"
y="0"
width="75"
height="14"
key="textField-29"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{pay_sum}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="297"
y="0"
width="72"
height="14"
key="textField-30"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{charge_sum}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="369"
y="0"
width="79"
height="14"
key="textField-31"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{account_sum}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="448"
y="0"
width="87"
height="14"
key="textField-32"
stretchType="RelativeToTallestObject"/>
<box leftPadding="3" rightPadding="3" topPadding="1" bottomPadding="1"> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.0" lineColor="#000000"/>
<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Left">
<font pdfFontName="conf/arial.ttf" size="9" isPdfEmbedded ="true" pdfEncoding ="Cp1251"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{out_sum}]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>