BiTel

<?xml version="1.0" encoding="UTF-8"?>
<report title="тест" type="java">
    <period name1="period1" default1="first_day_of_month" name2="period2" default2="last_day_of_month"/>
    <fields>
..........
    </fields>
    <contractGroups name="gr" title="Группы договоров"/>
</report>

SELECT c.id,c.title,c.comment,c.date1, bal.summa2, cpar.val " +
                        " FROM contract c" +
                        " LEFT JOIN contract_parameter_type_1 AS cpar ON c.id = cpar.cid " +
                        " LEFT JOIN contract_balance AS bal ON c.id = bal.cid " +
                        " WHERE cpar.pid=9 AND bal.yy=2012 AND bal.mm = 1 AND gr&(1<<5)>0 AND c.date1 BETWEEN '" + date1 + "' AND '" + date2 + "'";

SELECT c.id,c.title,c.comment,c.date1, bal.summa2, cpar.val " +
                        " FROM contract c" +
                        " LEFT JOIN contract_parameter_type_1 AS cpar ON c.id = cpar.cid " +
                        " LEFT JOIN contract_balance AS bal ON c.id = bal.cid " +
                        " WHERE cpar.pid=9 AND bal.yy=2012 AND bal.mm = 1 AND gr&$(gr)>0 AND c.date1 BETWEEN '" + date1 + "' AND '" + date2 + "'";

java.lang.RuntimeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION bgbilling.$ does not exist   at bitel.billing.server.reports.BGCSVReport.getResult(BGCSVReport.java:144)
   at bitel.billing.server.reports.BGCSVReport.fillReportToStream(BGCSVReport.java:44)
   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.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)

<contractGroups name="contractGroups" title="Группы договоров"/>

contractGroups = filter.getStringParam( "contractGroups" );

01-12/09:06:19  INFO ["http-bio-/0.0.0.0-8080"-exec-2] LoggingPrintStream - contractGroups = 256
01-12/09:07:06  INFO ["http-bio-/0.0.0.0-8080"-exec-5] LoggingPrintStream - contractGroups = 8590262528

" WHERE cpar.pid=9 AND bal.yy=2012 AND bal.mm = 1 AND gr&$(" + contractGroups + ")>0 AND c.date1 BETWEEN '" + date1 + "' AND '" + date2 + "'";