Jasper Reports

[srija]

Hi

I worked out this program.

Could you tell me why is this error there---

PROGRAM

?xml version="1.0"?>
<!DOCTYPE jasperReport
PUBLIC "-//JasperReports//DTD Report Design//EN"
"http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">



<jasperReport name="BasicReport" >

<parameter name="Id" class="java.lang.Integer"/>
<parameter name="InitialValue" class="java.lang.Integer"/>
<parameter name="ReportTitle" class="java.lang.String"/>

<queryString><![CDATA[select * from flight_details where flight_flightid=$P{Id}]]></queryString>

<field name="flight_flightid" class="java.lang.Integer"/>
<field name="flight_airlines" class="java.lang.String"/>
<field name="flight_from" class="java.lang.String"/>
<field name="flight_to" class="java.lang.String"/>


<variable name="Sum_Of_Ids" class="java.lang.Integer" resetType="Report" incrementType="None" calculation="Sum">
<initialValueExpression><![CDATA[$P{InitialValue}]]></initialValueExpression>
<variableExpression><![CDATA[$F{flight_flightid}]]></variableExpression>
</variable>


<title>
<band height="150">
<textField>
<reportElement x="0" y="50" width="100" height="50" />
<textFieldExpression class="java.lang.String"><![CDATA[$P{ReportTitle}]]></textFieldExpression>
</textField>

<textField>
<reportElement x="100" y="50" width="100" height="50" />
<textFieldExpression class="java.lang.Integer"><![CDATA[$V{Sum_Of_Ids}]]></textFieldExpression>
</textField>
</band>
</title>

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

<columnHeader>
<band>
</band>
</columnHeader>

<detail>
<band height="400">
<textField>
<reportElement x="0" y="0" width="50" height="100"/>
<textFieldExpression class="java.lang.Integer"><![CDATA[$F{flight_flightid}]]></textFieldExpression>
</textField>

<textField>
<reportElement x="50" y="0" width="50" height="100"/>
<textFieldExpression class="java.lang.String"><![CDATA[$F{flight_airlines}]]></textFieldExpression>
</textField>

<textField>
<reportElement x="100" y="0" width="50" height="100"/>
<textFieldExpression class="java.lang.String"><![CDATA[$F{flight_from}]]></textFieldExpression>
</textField>

<textField>
<reportElement x="150" y="0" width="50" height="100"/>
<textFieldExpression class="java.lang.String"><![CDATA[$F{flight_to}]]></textFieldExpression>
</textField>


</band>
</detail>

<columnFooter>
<band>
</band>
</columnFooter>

<pageFooter>
<band>
</band>
</pageFooter>

<summary>
<band>
</band>
</summary>

</jasperReport>



package report3;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.HashMap;
import java.util.Map;

import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.view.JasperViewer;

public class Report3 {


public static void main(String arg[]) {


String reportSource = "D:/Wipro/WorkSpace/SOBay/Second2/src11/report3/s3.jrxml";
String reportDest = "D:/s3.html";


Map<String, Object> params = new HashMap();


JasperReport jasperReport = null;
try {
jasperReport = JasperCompileManager.compileReport(reportSource);
} catch (JRException e) {

e.printStackTrace();
}

JasperPrint jasperPrint = null;
Connection conn = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver");
} catch (ClassNotFoundException exception) {
exception.printStackTrace();
}
try {
conn = DriverManager
.getConnection("jdbc:sqlserver://10.200.14.171:1433;databaseName=user1;user=sa;pass word=wipro@123;");
} catch (Exception e) {
e.printStackTrace();
}

params.put("Id",1);
params.put("InitialValue",0);
params.put("ReportTitle", "REPORT");


try {
jasperPrint = JasperFillManager.fillReport(jasperReport, params,
conn);
} catch (JRException e) {

e.printStackTrace();
}

try {
JasperExportManager.exportReportToHtmlFile(jasperP rint, reportDest);
} catch (JRException e) {

e.printStackTrace();
}

JasperViewer.viewReport(jasperPrint);

}
}


ERROR
Jan 11, 2008 10:30:59 AM org.apache.commons.digester.Digester error
SEVERE: Parse Error at line 25 column 13: The content of element type "variable" must match "(variableExpression?,initialValueExpression?) ".
org.xml.sax.SAXParseException: The content of element type "variable" must match "(variableExpression?,initialValueExpression?) ".
at com.sun.org.apache.xerces.internal.util.ErrorHandl erWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandl erWrapper.error(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorRe porter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorRe porter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTD Validator.handleEndElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTD Validator.endElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl.scanEndElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl$FragmentContentDispatcher.dis patch(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Co nfiguration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Co nfiguration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLPars er.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.Abstrac tSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digeste r.java:1745)
at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXM L(JRXmlLoader.java:239)
at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXM L(JRXmlLoader.java:226)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:214)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:168)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:152)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:151)
at report3.Report3.main(Report3.java:31)
net.sf.jasperreports.engine.JRException: org.xml.sax.SAXParseException: The content of element type "variable" must match "(variableExpression?,initialValueExpression?) ".
at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXM L(JRXmlLoader.java:243)
at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXM L(JRXmlLoader.java:226)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:214)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:168)
at net.sf.jasperreports.engine.xml.JRXmlLoader.load(J RXmlLoader.java:152)
at net.sf.jasperreports.engine.JasperCompileManager.c ompileReport(JasperCompileManager.java:151)
at report3.Report3.main(Report3.java:31)
Caused by: org.xml.sax.SAXParseException: The content of element type "variable" must match "(variableExpression?,initialValueExpression?) ".
at com.sun.org.apache.xerces.internal.util.ErrorHandl erWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandl erWrapper.error(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorRe porter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorRe porter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTD Validator.handleEndElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTD Validator.endElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl.scanEndElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl$FragmentContentDispatcher.dis patch(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumen tFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Co nfiguration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Co nfiguration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLPars er.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.Abstrac tSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digeste r.java:1745)
at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXM L(JRXmlLoader.java:239)
... 6 more
Exception in thread "main" java.lang.NullPointerException
at net.sf.jasperreports.engine.fill.JRFiller.createFi ller(JRFiller.java:138)
at net.sf.jasperreports.engine.fill.JRFiller.fillRepo rt(JRFiller.java:57)
at net.sf.jasperreports.engine.JasperFillManager.fill Report(JasperFillManager.java:402)
at report3.Report3.main(Report3.java:57)

[dmores]

Please try to swap

<initialValueExpression><![CDATA[$P{InitialValue}]]></initialValueExpression>
<variableExpression><![CDATA[$F{flight_flightid}]]></variableExpression>

into

<variableExpression><![CDATA[$F{flight_flightid}]]></variableExpression>
<initialValueExpression><![CDATA[$P{InitialValue}]]></initialValueExpression>

[sharmasandeep]

Hii all...
I want a background image in my jasper report. How can i get it?
Kindly help me...
Thanks in advance.