BiTel

import java.sql.*;
import java.util.*;

public void fillReport( con, filter, result )
{
  PreparedStatement ps = con.prepareStatement( result.sql( "SELECT t3.title as col1," +
  " SUM(t1.summa) as col2 FROM contract_account AS t1,  contract AS t2, service AS t3"+
  " WHERE t1.cid=t2.id AND t1.sid=t3.id AND t2.gr&$(gr)>0 AND t1.yy=$yy(month) AND"+
  " t1.mm=$mm(month) GROUP BY t1.sid ORDER BY t3.mid, t3.title", filter ) );

  ResultSet rs = ps.executeQuery();
  result.setDataSource( rs );
}