How to display the query

[yael]

Hi,

How can I display the result of a query as a table in JasperViewe??

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jasperReport
PUBLIC "-//JasperReports//DTD Report Design//EN"
"http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport name="example1">
<reportFont name="Arial_Normal" isDefault="true" fontName="Arial" size="12" 
		isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" 
		pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false" />
	<reportFont name="Arial_Bold" isDefault="false" fontName="Arial" size="12" 
		isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" 
		pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false" />
	<reportFont name="Arial_Italic" isDefault="false" fontName="Arial" size="12" 
		isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false" 
		pdfFontName="Helvetica-Oblique" pdfEncoding="Cp1252" isPdfEmbedded="false" />
<parameter name="Title"/>	
<queryString language="sql">
<![CDATA[ SELECT first_name,last_name,contact_id FROM contacts
  ]]> 
  </queryString>
  <field name="first_name" class="java.lang.String" />
<field name="last_name" class="java.lang.String" /> 
<field name="contact_id" class="java.lang.Integer" /> 

<title>
		<band height="35">
			<textField isBlankWhenNull="true">
				 <reportElement mode="Transparent" x="0" y="0" width="520" height="30" forecolor="#FF3300" backcolor="#FFFFFF" key="staticText-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> 
  <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000" /> 
<textElement textAlignment="Center" verticalAlignment="Top" rotation="None" lineSpacing="Single">
  <font fontName="Arial" pdfFontName="Helvetica-Bold" size="24" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1252" isStrikeThrough="false" /> 
  </textElement>
				<textFieldExpression class="java.lang.String">
				$P{Title}
				</textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="30" width="520" height="1" />
				<graphicElement />
			</line>
		</band>
	</title>

<pageHeader>
		<band></band>
	</pageHeader>

<columnHeader>
    <band height="20">
      <staticText>
        <reportElement x="10" y="0" width="180" height="20"/>
        <textElement textAlignment="Center">
        <font fontName="Arial" isBold="true" isUnderline="true"/> 
        </textElement>
        <text><![CDATA[First Name]]></text>
      </staticText>
      <staticText>
        <reportElement x="90" y="0" width="180" height="20"/>
        <textElement textAlignment="Center">
       <font fontName="Arial" isBold="true" isUnderline="true"/> 
        </textElement>
        <text><![CDATA[Last Name]]></text>
      </staticText>
      <staticText>
        <reportElement x="180" y="0" width="180" height="20"/>
        <textElement textAlignment="Center">
      <font fontName="Arial" isBold="true" isUnderline="true"/> 
        </textElement>
        <text><![CDATA[iD]]></text>
      </staticText>
    </band>
  </columnHeader>
  

<detail>
<band height="20">
<textField>
<reportElement x="10" y="0" width="180" height="20" />
<textElement textAlignment="Center">
      <font fontName="Arial"/> 
</textElement>
<textFieldExpression class="java.lang.String">
<![CDATA[$F{first_name}]]>
</textFieldExpression>
</textField>
<textField>
<reportElement x="90" y="0" width="180" height="20" />
<textElement textAlignment="Center">
      <font fontName="Arial"/> 
</textElement>
<textFieldExpression class="java.lang.String">
<![CDATA[$F{last_name}]]>
</textFieldExpression>
</textField>
<textField>
<reportElement x="180" y="0" width="180" height="20" />
<textElement textAlignment="Center">
      <font fontName="Arial"/> 
</textElement>
<textFieldExpression class="java.lang.Integer">
<![CDATA[$F{contact_id}]]>
</textFieldExpression>
</textField>
</band>
</detail>

<pageFooter>
		<band height="40">
			<line>
				<reportElement x="0" y="10" width="515" height="1" />
				<graphicElement />
			</line>
			<textField>
				<reportElement x="200" y="20" width="80" height="15" />
				<textElement textAlignment="Right" />
				<textFieldExpression class="java.lang.String">
					<![CDATA["Page "]]>
				</textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement x="280" y="20" width="75" height="15" />
				<textElement />
				<textFieldExpression class="java.lang.String">
					<![CDATA[" of "]]>
				</textFieldExpression>
			</textField>
		</band>
	</pageFooter>

</jasperReport>