Jasper Reports

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • srija
    New Member
    • Jan 2008
    • 4
    #1

    Jasper Reports

    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.s ourceforge.net/dtds/jasperreport.dt d">



    <jasperReport name="BasicRepo rt" >

    <parameter name="Id" class="java.lan g.Integer"/>
    <parameter name="InitialVa lue" class="java.lan g.Integer"/>
    <parameter name="ReportTit le" class="java.lan g.String"/>

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

    <field name="flight_fl ightid" class="java.lan g.Integer"/>
    <field name="flight_ai rlines" class="java.lan g.String"/>
    <field name="flight_fr om" class="java.lan g.String"/>
    <field name="flight_to " class="java.lan g.String"/>


    <variable name="Sum_Of_Id s" class="java.lan g.Integer" resetType="Repo rt" incrementType=" None" calculation="Su m">
    <initialValueEx pression><![CDATA[$P{InitialValue }]]></initialValueExp ression>
    <variableExpres sion><![CDATA[$F{flight_fligh tid}]]></variableExpress ion>
    </variable>


    <title>
    <band height="150">
    <textField>
    <reportElemen t x="0" y="50" width="100" height="50" />
    <textFieldExpre ssion class="java.lan g.String"><![CDATA[$P{ReportTitle}]]></textFieldExpres sion>
    </textField>

    <textField>
    <reportElemen t x="100" y="50" width="100" height="50" />
    <textFieldExpre ssion class="java.lan g.Integer"><![CDATA[$V{Sum_Of_Ids}]]></textFieldExpres sion>
    </textField>
    </band>
    </title>

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

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

    <detail>
    <band height="400">
    <textField>
    <reportElemen t x="0" y="0" width="50" height="100"/>
    <textFieldExpre ssion class="java.lan g.Integer"><![CDATA[$F{flight_fligh tid}]]></textFieldExpres sion>
    </textField>

    <textField>
    <reportElemen t x="50" y="0" width="50" height="100"/>
    <textFieldExpre ssion class="java.lan g.String"><![CDATA[$F{flight_airli nes}]]></textFieldExpres sion>
    </textField>

    <textField>
    <reportElemen t x="100" y="0" width="50" height="100"/>
    <textFieldExpre ssion class="java.lan g.String"><![CDATA[$F{flight_from}]]></textFieldExpres sion>
    </textField>

    <textField>
    <reportElemen t x="150" y="0" width="50" height="100"/>
    <textFieldExpre ssion class="java.lan g.String"><![CDATA[$F{flight_to}]]></textFieldExpres sion>
    </textField>


    </band>
    </detail>

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

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

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

    </jasperReport>



    package report3;

    import java.sql.Connec tion;
    import java.sql.Driver Manager;
    import java.util.HashM ap;
    import java.util.Map;

    import net.sf.jasperre ports.engine.JR Exception;
    import net.sf.jasperre ports.engine.Ja sperCompileMana ger;
    import net.sf.jasperre ports.engine.Ja sperExportManag er;
    import net.sf.jasperre ports.engine.Ja sperFillManager ;
    import net.sf.jasperre ports.engine.Ja sperPrint;
    import net.sf.jasperre ports.engine.Ja sperReport;
    import net.sf.jasperre ports.view.Jasp erViewer;

    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 = JasperCompileMa nager.compileRe port(reportSour ce);
    } catch (JRException e) {

    e.printStackTra ce();
    }

    JasperPrint jasperPrint = null;
    Connection conn = null;
    try {
    Class.forName(" com.microsoft.s qlserver.jdbc.S QLServerDriver" );
    } catch (ClassNotFoundE xception exception) {
    exception.print StackTrace();
    }
    try {
    conn = DriverManager
    .getConnection( "jdbc:sqlserver ://10.200.14.171:1 433;databaseNam e=user1;user=sa ;password=wipro @123;");
    } catch (Exception e) {
    e.printStackTra ce();
    }

    params.put("Id" ,1);
    params.put("Ini tialValue",0);
    params.put("Rep ortTitle", "REPORT");


    try {
    jasperPrint = JasperFillManag er.fillReport(j asperReport, params,
    conn);
    } catch (JRException e) {

    e.printStackTra ce();
    }

    try {
    JasperExportMan ager.exportRepo rtToHtmlFile(ja sperPrint, reportDest);
    } catch (JRException e) {

    e.printStackTra ce();
    }

    JasperViewer.vi ewReport(jasper Print);

    }
    }


    ERROR
    Jan 11, 2008 10:30:59 AM org.apache.comm ons.digester.Di gester error
    SEVERE: Parse Error at line 25 column 13: The content of element type "variable" must match "(variableExpre ssion?,initialV alueExpression? )".
    org.xml.sax.SAX ParseException: The content of element type "variable" must match "(variableExpre ssion?,initialV alueExpression? )".
    at com.sun.org.apa che.xerces.inte rnal.util.Error HandlerWrapper. createSAXParseE xception(Unknow n Source)
    at com.sun.org.apa che.xerces.inte rnal.util.Error HandlerWrapper. error(Unknown Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.XMLEr rorReporter.rep ortError(Unknow n Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.XMLEr rorReporter.rep ortError(Unknow n Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.dtd.X MLDTDValidator. handleEndElemen t(Unknown Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.dtd.X MLDTDValidator. endElement(Unkn own Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.XMLDo cumentFragmentS cannerImpl.scan EndElement(Unkn own Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.XMLDo cumentFragmentS cannerImpl$Frag mentContentDisp atcher.dispatch (Unknown Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.XMLDo cumentFragmentS cannerImpl.scan Document(Unknow n Source)
    at com.sun.org.apa che.xerces.inte rnal.parsers.XM L11Configuratio n.parse(Unknown Source)
    at com.sun.org.apa che.xerces.inte rnal.parsers.XM L11Configuratio n.parse(Unknown Source)
    at com.sun.org.apa che.xerces.inte rnal.parsers.XM LParser.parse(U nknown Source)
    at com.sun.org.apa che.xerces.inte rnal.parsers.Ab stractSAXParser .parse(Unknown Source)
    at org.apache.comm ons.digester.Di gester.parse(Di gester.java:174 5)
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oadXML(JRXmlLoa der.java:239)
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oadXML(JRXmlLoa der.java:226)
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oad(JRXmlLoader .java:214)
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oad(JRXmlLoader .java:168)
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oad(JRXmlLoader .java:152)
    at net.sf.jasperre ports.engine.Ja sperCompileMana ger.compileRepo rt(JasperCompil eManager.java:1 51)
    at report3.Report3 .main(Report3.j ava:31)
    net.sf.jasperre ports.engine.JR Exception: org.xml.sax.SAX ParseException: The content of element type "variable" must match "(variableExpre ssion?,initialV alueExpression? )".
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oadXML(JRXmlLoa der.java:243)
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oadXML(JRXmlLoa der.java:226)
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oad(JRXmlLoader .java:214)
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oad(JRXmlLoader .java:168)
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oad(JRXmlLoader .java:152)
    at net.sf.jasperre ports.engine.Ja sperCompileMana ger.compileRepo rt(JasperCompil eManager.java:1 51)
    at report3.Report3 .main(Report3.j ava:31)
    Caused by: org.xml.sax.SAX ParseException: The content of element type "variable" must match "(variableExpre ssion?,initialV alueExpression? )".
    at com.sun.org.apa che.xerces.inte rnal.util.Error HandlerWrapper. createSAXParseE xception(Unknow n Source)
    at com.sun.org.apa che.xerces.inte rnal.util.Error HandlerWrapper. error(Unknown Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.XMLEr rorReporter.rep ortError(Unknow n Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.XMLEr rorReporter.rep ortError(Unknow n Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.dtd.X MLDTDValidator. handleEndElemen t(Unknown Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.dtd.X MLDTDValidator. endElement(Unkn own Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.XMLDo cumentFragmentS cannerImpl.scan EndElement(Unkn own Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.XMLDo cumentFragmentS cannerImpl$Frag mentContentDisp atcher.dispatch (Unknown Source)
    at com.sun.org.apa che.xerces.inte rnal.impl.XMLDo cumentFragmentS cannerImpl.scan Document(Unknow n Source)
    at com.sun.org.apa che.xerces.inte rnal.parsers.XM L11Configuratio n.parse(Unknown Source)
    at com.sun.org.apa che.xerces.inte rnal.parsers.XM L11Configuratio n.parse(Unknown Source)
    at com.sun.org.apa che.xerces.inte rnal.parsers.XM LParser.parse(U nknown Source)
    at com.sun.org.apa che.xerces.inte rnal.parsers.Ab stractSAXParser .parse(Unknown Source)
    at org.apache.comm ons.digester.Di gester.parse(Di gester.java:174 5)
    at net.sf.jasperre ports.engine.xm l.JRXmlLoader.l oadXML(JRXmlLoa der.java:239)
    ... 6 more
    Exception in thread "main" java.lang.NullP ointerException
    at net.sf.jasperre ports.engine.fi ll.JRFiller.cre ateFiller(JRFil ler.java:138)
    at net.sf.jasperre ports.engine.fi ll.JRFiller.fil lReport(JRFille r.java:57)
    at net.sf.jasperre ports.engine.Ja sperFillManager .fillReport(Jas perFillManager. java:402)
    at report3.Report3 .main(Report3.j ava:57)
    Tags: None
    • dmores
      New Member
      • Aug 2008
      • 1
      #2
      Please try to swap

      <initialValueEx pression><![CDATA[$P{InitialValue }]]></initialValueExp ression>
      <variableExpres sion><![CDATA[$F{flight_fligh tid}]]></variableExpress ion>

      into

      <variableExpres sion><![CDATA[$F{flight_fligh tid}]]></variableExpress ion>
      <initialValueEx pression><![CDATA[$P{InitialValue }]]></initialValueExp ression>

        Comment

        • sharmasandeep
          New Member
          • Aug 2008
          • 1
          #3
          Hii all...
          I want a background image in my jasper report. How can i get it?
          Kindly help me...
          Thanks in advance.

            Comment

            Previous template Next
            Working...