<?xml version="1.0" encoding="UTF-8"?>
<report title="Отчет по остаткам IP-телефонии">
   <month name="month_from" title="Дата"/>
</report>

<?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"
   />
   <style
      name="border"
      isDefault="false"
      border="Thin"
      borderColor="#000000"
   />
   <style
      name="Right"
      isDefault="false"
      hAlign="Right"
      topPadding="1"
      leftPadding="1"
      bottomPadding="1"
      rightPadding="1"
   />

   <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 java.sql.*;
import bitel.billing.server.util.*;
import bitel.billing.server.contract.bean.*;
import bitel.billing.common.*;
import java.math.BigDecimal;
import java.text.DecimalFormat;

public void fillReport( con, filter, result )
{   
   monthFrom = filter.getCalendarParam( "month_from" );   
      
   query = "SELECT contract.title,contract.comment FROM contract LIMIT 0, 30";
   
   
   res = new ArrayList( 1000 );

   ps = con.prepareStatement( query );


   rs = ps.executeQuery();
   while ( rs.next() )
   {
      Map  map = new HashMap( 2 );
      map.put( "title", rs.getString( 1 ) );
      map.put( "comment", rs.getString( 2 )  );
      
      res.add( map );
   }

   result.setDataSource( res );
   result.setParams( new HashMap( 1 ) );


}]]></queryString>

   <field name="title" class="java.lang.String"/>
   <field name="comment" class="java.lang.String"/>

  <detail>
    <band height="20">
      <textField>
        <reportElement x="0" y="0" width="50" height="20" />
        <textFieldExpression class="java.lang.String">
          <![CDATA[$F{title}]]>
        </textFieldExpression>
      </textField>
      <textField>
        <reportElement x="51" y="0" width="200" height="20" />
        <textFieldExpression class="java.lang.String">
          <![CDATA[$F{comment}]]>
        </textFieldExpression>
      </textField>
         </band>
  </detail>

</jasperReport>

04-22/13:15:57 DEBUG [http-8080-1] server - [bitel.billing.server.reports.action.ActionReport] Generate report with id=kernel_ost_change
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - java.lang.NullPointerException
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.common.TimeUtils.getEndMonth(TimeUtils.java:777)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.common.TimeUtils.getEndMonth(TimeUtils.java:767)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at java.lang.reflect.Method.invoke(Method.java:616)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.Reflect.invokeMethod(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.Reflect.invokeStaticMethod(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.Name.invokeMethod(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.BSHMethodInvocation.eval(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.BSHPrimaryExpression.eval(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.BSHPrimaryExpression.eval(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.BSHAssignment.eval(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.BSHBlock.evalBlock(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.BSHBlock.eval(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.BshMethod.invokeImpl(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.BshMethod.invoke(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.BshMethod.invoke(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.This.invokeMethod(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bsh.This.invokeMethod(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.admin.reports.BGReportTemplate.processQuery(BGReportTemplate.java:426)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.admin.reports.BGReportTemplate.processReport(BGReportTemplate.java:396)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:308)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:379)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.reports.Report_Default.fillReportToStream(Report_Default.java:30)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:45)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.Executer.doModule(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.Executer.doPost(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at java.lang.Thread.run(Thread.java:636)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream - java.lang.NullPointerException
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:309)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.admin.reports.BGReportTemplate.fillReportToStream(BGReportTemplate.java:379)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.reports.Report_Default.fillReportToStream(Report_Default.java:30)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.reports.action.ActionReport.doAction(ActionReport.java:45)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.Executer.doModule(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.Executer.doPost(Unknown Source)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at bitel.billing.server.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:37)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
04-22/13:15:57 ERROR [http-8080-1] LoggingPrintStream -    at java.lang.Thread.run(Thread.java:636)
04-22/13:15:57 DEBUG [http-8080-1] server - executing bitel.billing.server.reports.action.ActionReport; time => 21 ms.