Caros Colegas,
Sou uma pessoa que sempre tenho o PortalJava como referência, principalmente agora que estou fazendo um projeto final e este forum ja me ajudou muito, porém em minhas buscas, não consegui uma solução, que peço a ajuda de todos.
Bom, tenho uma aplicação que roda com o JDesktopPane, onde cada classe abro em um JInternalFrame atravez do menu, ate o momento tudo bem.
Porem chegou na parte impressão e é onde tá pegando, pois fiz várias pesquisas e nao consigo fazer funcionar.
Começei a tentar usar o JasperReport, instalei no NetBens, coloquei no CLASSPATH e esta tudo OK, reconhecendo os metodos e tudo mais, porem quando baixei o IReport para gerar o jrxml. O iReport não esta no CLASSPATH, creio que nao seja necessario.
1 - Não sei porque o próprio IReport não exibe o report, onde seria o primeiro problema, ele gera, faz a conexão com banco dando ok, porem quando apero na seta para executar, aparece na janela do console de saida informando que executou, mas nao aparece nada, mesmo gerando o arquivo .jasper.
2 - Sem exibir o relaatorio no IReport, mas criando o JRXML e o jasper, tentei implementar na minha aplição, porem não estou conseguindo fazer a integração.
PS: A aplicação e local, usando o NetBens, com banco ACCESS.
A principio existe um JInternalFrame que exibe um JTable - ResultSet com os campos de uma tabela do Banco de Dados, que esta Ok, e logo acima um botão imprimir, que seria a ideia de apresentar o JRXML.
Então peço a ajuda dos colegas para ajudar a mostar este relatorio, onde eu compilo esta classe e fica ok, porem quando executo a ação de clicar no botão imprimir, aparece o seguinte erro.
[color=“red”][erro]
Exception in thread “AWT-EventQueue-0” java.lang.NullPointerException
at java.io.File.<init>(File.java:222)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:152)
at sfpt.ClsRelContaExibe.gerar(ClsRelContaExibe.java:180)
at sfpt.ClsRelContaExibe.jbimprimeActionPerformed(ClsRelContaExibe.java:167)
at sfpt.ClsRelContaExibe.access$000(ClsRelContaExibe.java:41)
at sfpt.ClsRelContaExibe$1.actionPerformed(ClsRelContaExibe.java:82)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
[/erro][/color]
JInternalFrame que exibe a Tabela, junto com o botão imprimir.
package sfpt;
import java.awt.Graphics;
import java.awt.Graphics2D;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.print.PageFormat;
import java.awt.print.Printable;
import java.awt.print.PrinterException;
import java.awt.print.PrinterJob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JSeparator;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableColumnModel;
import javax.swing.table.TableModel;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRResultSetDataSource;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.view.JasperViewer;
import temp.JasperReportExemple;
public class ClsRelContaExibe extends JPanel implements ActionListener {
public ClsRelContaExibe() {
//conexao do banco
try {
url = "jdbc:odbc:sfp";
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
connection = DriverManager.getConnection( url );
} catch ( ClassNotFoundException cnfex ) {
// processa ClassNotFoundExceptions aqui
JOptionPane.showMessageDialog(
null, "A conexão falhou!\n" + cnfex.toString(), "Aviso",
JOptionPane.WARNING_MESSAGE );
} catch ( SQLException sqlex ) {
// processa SQLExceptions aqui
JOptionPane.showMessageDialog(
null, "A conexão falhou!\n", "Aviso",
JOptionPane.WARNING_MESSAGE );
} catch ( Exception ex ) {
// processa Exceptions remanescentes aqui
JOptionPane.showMessageDialog(
null, ex.toString(), "Aviso",
JOptionPane.WARNING_MESSAGE );
}
initComponents();
}
private void initComponents() {
jSeparator1 = new JSeparator();
jsprelcontaexibe = new JScrollPane();
jtrelcontaexibe = new JTable();
jbimprime = new JButton();
jbimprime.setText("Imprimir");
jbimprime.setMaximumSize(new java.awt.Dimension(74, 23));
jbimprime.setMinimumSize(new java.awt.Dimension(74, 23));
jbimprime.setPreferredSize(new java.awt.Dimension(74, 23));
jbimprime.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
jbimprimeActionPerformed(evt);
}
});
jtrelcontaexibe = new JTable(linhaCorrente, nomeColunas);
JScrollPane jsprelcontaexibe = new JScrollPane(jtrelcontaexibe);
jtrelcontaexibe.setVisible(true);
try {
Statement statement = connection.createStatement();
String query = "SELECT * FROM tabconta";
ResultSet rs = statement.executeQuery( query );
ResultSetMetaData metaData = rs.getMetaData();
// nome das colunhas
String[] colunas = new String[ metaData.getColumnCount() ];
for ( int i = 0; i < colunas.length; i++ ) {
colunas[ i ] = metaData.getColumnName( i + 1 );
}
// cria um modelo
DefaultTableModel modelo = new DefaultTableModel( colunas, 0 );
// preenche o modelo
while ( rs.next() ) {
// uma linha
String[] linha = new String[ colunas.length ];
// adiciona valores na linha
for ( int i = 0; i < colunas.length; i++ ) {
linha[ i ] = rs.getString( i + 1 );
}
// adiciona a linha
modelo.addRow( linha );
}
// seta o modelo na tabela
jtrelcontaexibe.setModel( modelo );
} catch ( SQLException exc ) {
JOptionPane.showMessageDialog(
null, exc, "Aviso",
JOptionPane.PLAIN_MESSAGE );
//System.out.println( exc );
}
// Criacao do Layout
GroupLayout layout = new GroupLayout(this);
setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jSeparator1, javax.swing.GroupLayout.DEFAULT_SIZE, 448, Short.MAX_VALUE)
.addComponent(jsprelcontaexibe, javax.swing.GroupLayout.DEFAULT_SIZE, 448, Short.MAX_VALUE)))
.addGroup(layout.createSequentialGroup()
.addGap(172, 172, 172)
.addComponent(jbimprime, javax.swing.GroupLayout.PREFERRED_SIZE, 123, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jbimprime, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(15, 15, 15)
.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jsprelcontaexibe, javax.swing.GroupLayout.DEFAULT_SIZE, 448, Short.MAX_VALUE)
.addContainerGap())
);
}
private void jbimprimeActionPerformed(ActionEvent evt)
{
JOptionPane.showMessageDialog(null, "Imprimindo");
try {
gerar();
} catch (JRException ex) {
ex.printStackTrace();
} catch (SQLException ex) {
ex.printStackTrace();
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
}
public void gerar() throws JRException , SQLException, ClassNotFoundException {
//gerando o jasper design
JasperDesign desenho = JRXmlLoader.load( layout );
//compila o relatório
JasperReport relatorio = JasperCompileManager.compileReport( desenho );
//estabelece conexão
Statement statement = connection.createStatement();
String query = "SELECT * FROM tabconta";
ResultSet rs = statement.executeQuery( query );
//implementação da interface JRDataSource para DataSource ResultSet
JRResultSetDataSource jrRS = new JRResultSetDataSource( rs );
//executa o relatório
Map parametros = new HashMap();
parametros.put("nota", new Double(10));
JasperPrint impressao = JasperFillManager.fillReport( relatorio , parametros, jrRS );
//exibe o resultado
JasperViewer viewer = new JasperViewer( impressao , true );
viewer.setVisible(true);
try {
new JasperReportExemple().gerar( "iRCadConta.jrxml" );
} catch (Exception e) {
e.printStackTrace();
}
}
public void actionPerformed(ActionEvent e) {
}
// Declaração de variáveis
private JSeparator jSeparator1;
private JButton jbimprime;
private JScrollPane jsprelcontaexibe;
private JTable jtrelcontaexibe;
// Fim da declaração de variáveis
private TableColumnModel nomeColunas;
private TableModel linhaCorrente;
private Connection connection;
private String url;
private String layout;
}
Abaixo o JRXML
<?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="iRCadConta"
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.*" />
<queryString><![CDATA[SELECT * FROM tabconta]]></queryString>
<field name="codcontaconta" class="java.lang.Integer"/>
<field name="codbanco" class="java.lang.String"/>
<field name="databerturaconta" class="java.sql.Timestamp"/>
<field name="nomebanco" class="java.lang.String"/>
<field name="descriconta" class="java.lang.String"/>
<field name="agconta" class="java.lang.String"/>
<field name="contaconta" class="java.lang.String"/>
<field name="teleconta" class="java.lang.String"/>
<field name="faxconta" class="java.lang.String"/>
<field name="gerconta" class="java.lang.String"/>
<field name="limiteconta" class="java.lang.Integer"/>
<field name="venceconta" class="java.sql.Timestamp"/>
<field name="emailconta" class="java.lang.String"/>
<field name="homepageconta" class="java.lang.String"/>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="50" isSplitAllowed="true" >
<staticText>
<reportElement
x="0"
y="5"
width="534"
height="40"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Center">
<font size="30"/>
</textElement>
<text><![CDATA[Relatórios das Contas Cadastradas]]></text>
</staticText>
<line direction="TopDown">
<reportElement
x="0"
y="48"
width="534"
height="0"
key="line"/>
<graphicElement stretchType="NoStretch"/>
</line>
<line direction="TopDown">
<reportElement
x="0"
y="3"
width="534"
height="0"
key="line"/>
<graphicElement stretchType="NoStretch"/>
</line>
</band>
</title>
<pageHeader>
<band height="10" isSplitAllowed="true" >
<line direction="BottomUp">
<reportElement
x="0"
y="9"
width="535"
height="0"
key="line"/>
<graphicElement stretchType="NoStretch"/>
</line>
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="278" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="2"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$F{codcontaconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="2"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Codigo do Cadastro:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="21"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{codbanco}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="21"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Codigo do Banco:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="40"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{databerturaconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="40"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Data da Abertura:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="59"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{nomebanco}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="59"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Nome do Banco:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="78"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{descriconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="78"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Descricao da Conta:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="97"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{agconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="97"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Agencia da Conta:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="116"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{contaconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="116"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Numero da Conta:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="135"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{teleconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="135"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Telefone da Agencia:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="154"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{faxconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="154"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Fax da Agencia:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="173"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{gerconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="173"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Gerente da Conta:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="192"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$F{limiteconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="192"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Limite da Conta:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="211"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{venceconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="211"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Vencimento da Conta:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="230"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{emailconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="230"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[E-mail da Agencia:]]></text>
</staticText>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="144"
y="249"
width="381"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{homepageconta}]]></textFieldExpression>
</textField>
<staticText>
<reportElement
x="0"
y="249"
width="131"
height="17"
forecolor="#000000"
backcolor="#FFFFFF"
key="staticText"
positionType="Float"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="12"/>
</textElement>
<text><![CDATA[Página da Agencia:]]></text>
</staticText>
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="27" isSplitAllowed="true" >
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="325"
y="4"
width="170"
height="19"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement textAlignment="Right">
<font size="10"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="499"
y="4"
width="36"
height="19"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="10"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<line direction="TopDown">
<reportElement
x="0"
y="3"
width="535"
height="0"
key="line"/>
<graphicElement stretchType="NoStretch"/>
</line>
<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >
<reportElement
x="1"
y="6"
width="209"
height="19"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<textElement>
<font size="10"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band height="0" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>