Jump to content
We've recently updated our Privacy Statement, available here ×

Code Required to Run the Jasper Reports


muttou

Recommended Posts

  • Replies 10
  • Created
  • Last Reply

Top Posters In This Topic

Thanks for ur reply.. i have downloded the Project files. but when i run samples files i get the follwing exception from the Compiler.. My Code is

 

code is /////////////////// JasperDesign jasperDesign = JRXmlLoader.load("D:/Nasir.jrxml");

JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

Map parameters = new HashMap();

parameters.put("", "Basic JasperReport");

parameters.put("", new Double(25000.00));

Connection jdbcConnection = connectDB(databaseName, userName, password);

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, jdbcConnection);

// JasperManager.printReportToPdfFile(jasperPrint, "BasicReport.pdf");

JasperViewer.viewReport(jasperPrint,true);

 

/////////////////////////////////////////

after compiling this code i Got the follwing Error Message which is below

 

Exception is ///////////////////

10 [main] ERROR digester.Digester - Digester.getParser:

 

org.xml.sax.SAXNotRecognizedException: http://apache.org/xml/features/validation/dynamic

 

at gnu.xml.aelfred2.JAXPFactory.setFeature(JAXPFactory.java:102)

 

at org.apache.commons.digester.parser.XercesParser.configureXerces(XercesParser.java:185)

 

at org.apache.commons.digester.parser.XercesParser.newSAXParser(XercesParser.java:138)

 

at org.apache.commons.digester.ParserFeatureSetterFactory.newSAXParser(ParserFeatureSetterFactory.java:71)

 

at org.apache.commons.digester.Digester.getParser(Digester.java:692)

 

at org.apache.commons.digester.Digester.getXMLReader(Digester.java:899)

 

at org.apache.commons.digester.Digester.parse(Digester.java:1647)

 

at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238)

 

at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225)

 

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213)

 

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167)

 

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151)

 

at awan.ReportDriver.runReport(ReportDriver.java:79)

 

at awan.ReportDriver.main(ReportDriver.java:133)

 

Could not create the report null

 

i m using the jdk1.6.0 on Windows XP service pack2.. any urgent help required. Thanks for this solution..

Link to comment
Share on other sites

Dear sir Thanks for ur reply........yah i m using all these files into my Classpath............but still problem is same...more my Jasper Report code is as below.......i m unable to run this Report even its running well in iReports1.3.0...........again aditional support will be highly appreciated.........my Report code is as belew...........

///////////////////////////////////////////////////

<?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="Nasir"

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 Advance order by CUID]]></queryString>

 

<field name="ID" class="java.lang.Integer"/>

<field name="Payment" class="java.lang.Double"/>

<field name="Sale" class="java.lang.Double"/>

<field name="Status" class="java.lang.String"/>

<field name="PDate" class="java.sql.Timestamp"/>

<field name="Description" class="java.lang.String"/>

<field name="CUID" class="java.lang.Integer"/>

<field name="TransactionNo" class="java.lang.String"/>

 

 

<group name="Customer" >

<groupExpression><![CDATA[$F{CUID}]]></groupExpression>

<groupHeader>

<band height="34" isSplitAllowed="true" >

<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="65"

y="0"

width="21"

height="15"

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" isBold="true"/>

</textElement>

<textFieldExpression class="java.lang.Integer"><![CDATA[$F{CUID}]]></textFieldExpression>

</textField>

<staticText>

<reportElement

x="2"

y="0"

width="63"

height="15"

key="staticText-3"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font isBold="true"/>

</textElement>

<text><![CDATA[Customer ID:]]></text>

</staticText>

<rectangle radius="2" >

<reportElement

x="0"

y="12"

width="535"

height="20"

backcolor="#6666FF"

key="rectangle-1"/>

<graphicElement stretchType="NoStretch" pen="Thin"/>

</rectangle>

<staticText>

<reportElement

x="0"

y="16"

width="535"

height="13"

forecolor="#FFFFFF"

key="staticText-4"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font size="9" isBold="true"/>

</textElement>

<text><![CDATA[ ID Payments Sales Status Date T-No Description]]></text>

</staticText>

</band>

</groupHeader>

<groupFooter>

<band height="0" isSplitAllowed="true" >

</band>

</groupFooter>

</group>

<background>

<band height="0" isSplitAllowed="true" >

</band>

</background>

<title>

<band height="0" isSplitAllowed="false" >

</band>

</title>

<pageHeader>

<band height="28" isSplitAllowed="true" >

<staticText>

<reportElement

x="98"

y="0"

width="297"

height="28"

key="staticText-2"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center">

<font size="18" isBold="true"/>

</textElement>

<text><![CDATA[Hello Nasir Sales Report]]></text>

</staticText>

<textField isStretchWithOverflow="false" pattern="MMMMM dd, yyyy" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="453"

y="7"

width="82"

height="12"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font size="8"/>

</textElement>

<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>

</textField>

</band>

</pageHeader>

<columnHeader>

<band height="0" isSplitAllowed="true" >

</band>

</columnHeader>

<detail>

<band height="11" isSplitAllowed="false" >

<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="0"

y="0"

width="34"

height="11"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Right">

<font size="8"/>

</textElement>

<textFieldExpression class="java.lang.Integer"><![CDATA[$F{ID}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" pattern="#,##0.0" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="34"

y="0"

width="55"

height="11"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Right">

<font size="8"/>

</textElement>

<textFieldExpression class="java.lang.Double"><![CDATA[$F{Payment}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" pattern="#,##0.0" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="89"

y="0"

width="39"

height="11"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Right">

<font size="8"/>

</textElement>

<textFieldExpression class="java.lang.Double"><![CDATA[$F{Sale}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="135"

y="0"

width="32"

height="11"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Left">

<font size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{Status}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" pattern="dd-MMM-yy" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="167"

y="0"

width="43"

height="11"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Left">

<font size="8"/>

</textElement>

<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{PDate}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="214"

y="0"

width="42"

height="11"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Center">

<font size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{TransactionNo}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="257"

y="0"

width="277"

height="11"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font size="8"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{Description}]]></textFieldExpression>

</textField>

<line direction="TopDown">

<reportElement

x="0"

y="10"

width="535"

height="0"

forecolor="#CCCCCC"

key="line-1"/>

<graphicElement stretchType="NoStretch" pen="Thin"/>

</line>

</band>

</detail>

<columnFooter>

<band height="0" isSplitAllowed="true" >

</band>

</columnFooter>

<pageFooter>

<band height="13" isSplitAllowed="true" >

<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="170"

y="0"

width="100"

height="13"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement textAlignment="Right">

<font size="8" isBold="true"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="270"

y="0"

width="100"

height="13"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font size="8" isBold="true"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER} + ""]]></textFieldExpression>

</textField>

</band>

</pageFooter>

<summary>

<band height="0" isSplitAllowed="true" >

</band>

</summary>

</jasperReport>

////////////////////////////////////////

thnaks for ur positive respone..................Nasir.

Sr. Application Developer (J2SE, J2EE) ANK soft, Ltd

[file name=Nasir.jrxml size=11495]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Nasir.jrxml[/file]

Link to comment
Share on other sites

download the file jasperreports-1.3.0.zip, you can get the file form jasperforge.org

 

then extract the files,

(commons-beanutils-1.7.jar, commons-collections-2.1.jar, commons-digester-1.7.jar, commons-logging-1.0.2.jar, jasperreports-1.3.0.jar)

 

compile program using these jar files by -classpath

and run the program using jar files by -classpath

 

i m using this code in my report application.

 

 

Code:

import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.engine.data.*;
import net.sf.jasperreports.engine.design.*;
import net.sf.jasperreports.engine.JasperExportManager.*;
import net.sf.jasperreports.engine.xml.*;
import net.sf.jasperreports.view.*;


try {
JasperDesign jasperDesign = JRXmlLoader.load("jrxml file path");

JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, new HashMap(hashtable), connection);

JasperViewer.viewReport(jasperPrint);
}
catch (Exception e){
e.printStackTrace();
}

 

 

if u hav used parameters in your iReport, then make a hashtable and put key pairs

(parameter name used in iReport, value)

 

if u don't hav the just write null instead of new HashMap(hashtable)

Post edited by: kk.shah, at: 2007/01/24 20:23

Link to comment
Share on other sites

first download the attachment,

then extract the files,

compile program using these jar files by -classpath

and run the program using jar files by -classpath

 

 

 

import net.sf.jasperreports.engine.*;

import net.sf.jasperreports.engine.data.*;

import net.sf.jasperreports.engine.design.*;

import net.sf.jasperreports.engine.JasperExportManager.*;

import net.sf.jasperreports.engine.xml.*;

import net.sf.jasperreports.view.*;

 

 

try {

JasperDesign jasperDesign = JRXmlLoader.load("jrxml file path);

 

JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

 

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, new JRTableModelDataSource(dtm));

 

JasperViewer.viewReport(jasperPrint);

}

catch (Exception e){

e.printStackTrace();

}

 

 

i m using this code in my report application.

Link to comment
Share on other sites

first download the attachment,

then extract the files,

compile program using these jar files by -classpath

and run the program using jar files by -classpath

 

i m using this code in my report application.

 

 

Code:

import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.engine.data.*;
import net.sf.jasperreports.engine.design.*;
import net.sf.jasperreports.engine.JasperExportManager.*;
import net.sf.jasperreports.engine.xml.*;
import net.sf.jasperreports.view.*;


try {
JasperDesign jasperDesign = JRXmlLoader.load("jrxml file path);

JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, new JRTableModelDataSource(dtm));

JasperViewer.viewReport(jasperPrint);
}
catch (Exception e){
e.printStackTrace();
}
Link to comment
Share on other sites

dear thanks for ur code sample i copy paste the same sample code into my project i m using the Borland Jbuilder2005 and installed all the jars but i m getting this exception after running ur code samplee plz help me out this...........

/////////////////////////////////

0 [main] ERROR digester.Digester - Digester.getParser:

org.xml.sax.SAXNotRecognizedException: http://apache.org/xml/features/validation/dynamic

at gnu.xml.aelfred2.JAXPFactory.setFeature(JAXPFactory.java:102)

at org.apache.commons.digester.parser.XercesParser.configureXerces(XercesParser.java:185)

at org.apache.commons.digester.parser.XercesParser.newSAXParser(XercesParser.java:138)

at org.apache.commons.digester.ParserFeatureSetterFactory.newSAXParser(ParserFeatureSetterFactory.java:71)

at org.apache.commons.digester.Digester.getParser(Digester.java:692)

at org.apache.commons.digester.Digester.getXMLReader(Digester.java:899)

at org.apache.commons.digester.Digester.parse(Digester.java:1647)

at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238)

at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225)

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213)

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167)

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151)

at awan.ReportDriver.runReport(ReportDriver.java:87)

at awan.ReportDriver.main(ReportDriver.java:136)

Could not create the report null

///////////////////////////////////////////////

again thanks for solving my problem..................

hope for the positive response from u/.

Link to comment
Share on other sites

parameters.put("", "Basic JasperReport");

parameters.put("", new Double(25000.00));

 

here in first argument you have to write parameter name, that you are using in jasper report (D:/Nasir.jrxml)

 

or simply write null instead of passing "parameters" in JasperPrint

 

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, jdbcConnection);

 

it would work

Link to comment
Share on other sites

Dear sir thanks for ur guide.........Sir i hav done all the efforts in this code but still there is exception... which is

/////////////////////////////////////////////

10 [main] ERROR digester.Digester - Digester.getParser:

 

org.xml.sax.SAXNotRecognizedException: http://apache.org/xml/features/validation/dynamic

 

at gnu.xml.aelfred2.JAXPFactory.setFeature(JAXPFactory.java:102)

 

at org.apache.commons.digester.parser.XercesParser.configureXerces(XercesParser.java:185)

 

at org.apache.commons.digester.parser.XercesParser.newSAXParser(XercesParser.java:138)

 

at org.apache.commons.digester.ParserFeatureSetterFactory.newSAXParser(ParserFeatureSetterFactory.java:71)

 

at org.apache.commons.digester.Digester.getParser(Digester.java:692)

 

at org.apache.commons.digester.Digester.getXMLReader(Digester.java:899)

 

at org.apache.commons.digester.Digester.parse(Digester.java:1647)

 

at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238)

 

at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225)

 

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213)

 

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167)

 

at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151)

 

at awan.ReportDriver.runReport(ReportDriver.java:86)

 

at awan.ReportDriver.main(ReportDriver.java:112)

 

Could not create the report null

 

////////////////////////////////////////////////

i dont know y i m getting this exception..sir plz i think problem is in this statement..

JasperDesign jasperDesign = JRXmlLoader.load("D:/Nasir.jrxml");

/////////////////////////////////

also i hav studied the JRXmlLoader.load() class and its methods.....but still no solution..

i need the solution on urgent basis.. more can u run the same code correctly on ur machine.........

sir my OS is WinXP and JDK version is 1.6.0.......now plz help me out this.......thanks thanks................Nasir

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...