[iReport library to be used for chart]

I have used a line chart in my iReport but when I run the report from my java application it shows the following error at runtime-

java.Lang.NoClassDefFoundError:Lorg/jfree/chart/plot/PlotOrientation.......

I m sure it needs a library and I didnt add any library for chart.Can anybody pls tell me which library(s) to be used for chart.

[iReport 3 has problems]

I can run the following(attached also) line of code to run iReport  2.0.3/2.0.2/2.0.1/..  compiled files. But now with the newer versions from 2.0.4 - 3.0 , the same line of code doesn't work.

I used the same code before to run iReport but now it is not working.The report is showing well in iReport preview but from my java class file it is not working.

Plsssss help me out.

It gives the following error-

at net.sf.jasperreports.engine.JRPropertiesMap.readObject(JRPropertiesMap.java:176)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1849)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1667)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1323)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351)
    at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:88)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:232)
    at frmReport.runReport(frmReport.java:46)
    at frmReport.<init>(frmReport.java:23)
    at frmReport.main(frmReport.java:35)

 

Code:

import java.sql.*;import net.sf.jasperreports.view.JasperViewer;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import java.io.OutputStream;import java.util.*;class frmReport{	frmReport(HashMap  map,String report)	{   	runReport(map,report);	}public static void main(String[] args){HashMap  map=new HashMap();map.put("id","E002");frmReport rpt=new frmReport(map,"./Report/rptEmpPaymentId.jasper");}	public  void runReport(HashMap  map,String reportFile) {try{	           Connection jdbcConnection = connectDB();           JasperPrint jasperPrint = JasperFillManager.fillReport(reportFile, map, jdbcConnection);           JasperViewer.viewReport(jasperPrint,false);     }catch(Exception ex) {           //String connectMsg = "Could not create the report " + ex.getMessage() + " " + ex.getLocalizedMessage();           //System.out.println(connectMsg);           ex.printStackTrace();    }}		public  Connection connectDB() 	{        Connection jdbcConnection = null;        //----------------- URL WITHOUT DSN ----------------------------				String url = "jdbc:odbc:DRIVER={MicroSoft Access Driver (*.mdb)};" +          		"DBQ=./DBSRPS/SRPS.mdb";       try{        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");        jdbcConnection= DriverManager.getConnection(url, "", "");              }catch(ClassNotFoundException cnfe){                       System.out.println("Driver Not Found !!!");		}	 catch(SQLException sqle){System.out.println("DSN Not Found !!!");				}                 return jdbcConnection;    }	}///////////////////end clas

[Report run problem...no help yet..PLSSSSSSS HELP]

WHY DONT YOU HELP ME? I have posted the same problem twice before but nobody has answered yet.How come nobody knows the solution!!!!!!!!!!!!!!!!!!. PLSSSS HELP ME.

I cant run iReport from my class.I used the same code before to run iReport but now it is not working.The report is showing well in iReport preview but from my java class file it is not working.But I used the same code several times before.

Plsssss help me out.

It gives the following error-

java.lang.NullPointerException
    at net.sf.jasperreports.engine.JRPropertiesMap.readObject(JRPropertiesMap.java:176)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1849)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1667)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1323)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351)
    at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:88)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:232)
    at frmReport.runReport(frmReport.java:46)
    at frmReport.<init>(frmReport.java:23)
    at frmReport.main(frmReport.java:35)

Process completed.
 

Code:

import java.sql.*;import net.sf.jasperreports.view.JasperViewer;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import java.io.OutputStream;import java.util.*;class frmReport{	frmReport(HashMap  map,String report)	{   	runReport(map,report);	}public static void main(String[] args){HashMap  map=new HashMap();map.put("id","E002");frmReport rpt=new frmReport(map,"./Report/rptEmpPaymentId.jasper");}	public  void runReport(HashMap  map,String reportFile) {try{	           Connection jdbcConnection = connectDB();           JasperPrint jasperPrint = JasperFillManager.fillReport(reportFile, map, jdbcConnection);           JasperViewer.viewReport(jasperPrint,false);     }catch(Exception ex) {           //String connectMsg = "Could not create the report " + ex.getMessage() + " " + ex.getLocalizedMessage();           //System.out.println(connectMsg);           ex.printStackTrace();    }}		public  Connection connectDB() 	{        Connection jdbcConnection = null;        //----------------- URL WITHOUT DSN ----------------------------				String url = "jdbc:odbc:DRIVER={MicroSoft Access Driver (*.mdb)};" +          		"DBQ=./DBSRPS/SRPS.mdb";       try{        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");        jdbcConnection= DriverManager.getConnection(url, "", "");              }catch(ClassNotFoundException cnfe){                       System.out.println("Driver Not Found !!!");		}	 catch(SQLException sqle){System.out.println("DSN Not Found !!!");				}                 return jdbcConnection;    }	}///////////////////end clas

[A weird Report run problem Plssssss help]

I cant run iReport from my class.I used the same code before to run iReport but now it is not working.The report is showing well in iReport preview but from my java class file it is not working.But I used the same code several times before.

Plsssss help me out.

It gives the following error-

java.lang.NullPointerException
    at net.sf.jasperreports.engine.JRPropertiesMap.readObject(JRPropertiesMap.java:176)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1849)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1667)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1323)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351)
    at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:88)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:232)
    at frmReport.runReport(frmReport.java:46)
    at frmReport.<init>(frmReport.java:23)
    at frmReport.main(frmReport.java:35)

Process completed.
 

Code:

Post Edited by tanvirtonu1 at 04/22/2009 21:07

[Customized Input control]

Brother I think SQL code should be SQL code : "A.nameP in ($P!{Products}) "

! should follow $P

Post Edited by tanvirtonu1 at 04/21/2009 21:22

[Cant open report frm java class]

I cant run iReport from my class.I used the same code before to run iReport but now it is not working.

Plsssss help me out.

It gives the following error-

java.lang.NullPointerException
    at net.sf.jasperreports.engine.JRPropertiesMap.readObject(JRPropertiesMap.java:176)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1849)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.readArray(ObjectInputStream.java:1667)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1323)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1947)
    at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1871)
    at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
    at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
    at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351)
    at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:88)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:232)
    at frmReport.runReport(frmReport.java:46)
    at frmReport.<init>(frmReport.java:23)
    at frmReport.main(frmReport.java:35)

Process completed.

 

Code:

import java.sql.*;import net.sf.jasperreports.view.JasperViewer;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import java.io.OutputStream;import java.util.*;class frmReport{	frmReport(HashMap  map,String report)	{   	runReport(map,report);	}public static void main(String[] args){HashMap  map=new HashMap();map.put("id","E002");frmReport rpt=new frmReport(map,"./Report/rptEmpPaymentId.jasper");}	public  void runReport(HashMap  map,String reportFile) {try{	           Connection jdbcConnection = connectDB();           JasperPrint jasperPrint = JasperFillManager.fillReport(reportFile, map, jdbcConnection);           JasperViewer.viewReport(jasperPrint,false);     }catch(Exception ex) {           //String connectMsg = "Could not create the report " + ex.getMessage() + " " + ex.getLocalizedMessage();           //System.out.println(connectMsg);           ex.printStackTrace();    }}		public  Connection connectDB() 	{        Connection jdbcConnection = null;        //----------------- URL WITHOUT DSN ----------------------------				String url = "jdbc:odbc:DRIVER={MicroSoft Access Driver (*.mdb)};" +          		"DBQ=./DBSRPS/SRPS.mdb";       try{        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");        jdbcConnection= DriverManager.getConnection(url, "", "");              }catch(ClassNotFoundException cnfe){                       System.out.println("Driver Not Found !!!");		}	 catch(SQLException sqle){System.out.println("DSN Not Found !!!");				}                 return jdbcConnection;    }									}///////////////////end clas

[Relative path issue]

I have a folder named "Report" which contains a report that is using an image which is in another folder named
"images" that is outside "Report" folder.

1.Now,what relative path should I use in image expression editor of the report
for that image.At the moment,I m using "./myImage.jpg" in expression editor but I have to put the image in "Report" folder.

2.What If I want to put the image just outside the Report folder but not inside any folder,what should my relative path
be then?

[Return value is not returning value- Pls help]

This is what I did to get return value from sub report-

1.Add a varible (e.g. - val), and setting calculation Type- System

2.In sub report properties of master report, in Return Values Box, add sub report variable ( e.g- subval) and destination variable as created above- val .

3.Add variable ( subVal ) in sub report design properties and set a string (e.g. "Return this Value") in variable expression.

4.Add a textfield ( setting $V{val} as expression) in main report to show the content of return variable from subreport.

NB. All variables are of type- String

Yet, I cant see the string( "Return this Value")  which is returned from sub report through" subVal " into the variable- " val "

Is there anything missing in my process? PLS help

One more thing when should I use "System" as calculation Type.

 

[iReport running from application]

I cant run compiled iReport from the following java code.Can any body tell me how to do it.I used the same code in earlier versions nad it worked but in the latest version it is not working.And which class (jar file) of iReport to add in my class path?

Code:

import java.sql.*;import javax.sql.*;import net.sf.jasperreports.view.JasperViewer;import net.sf.jasperreports.engine.xml.JRXmlLoader;import net.sf.jasperreports.engine.JasperCompileManager;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperPrint;import net.sf.jasperreports.engine.design.JasperDesign;import net.sf.jasperreports.engine.JasperReport;import java.io.OutputStream;import java.util.*;import tools.diit.*;import javax.swing.*;import java.awt.*;// details of class is not mentionedpublic static void runReport(String databaseName, String userName, String password,String reportFile) {    try{	           //JasperDesign jasperDesign = JRXmlLoader.load(reportFile);           //JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);           Connection jdbcConnection = connectDB();// it returns a jdbcConnection           JasperPrint jasperPrint = JasperFillManager.fillReport(reportFile, null, jdbcConnection);           JasperViewer.viewReport(jasperPrint,false);     }catch(Exception ex) {           String connectMsg = "Could not create the report " + ex.getMessage() + " " + ex.getLocalizedMessage();           System.out.println(connectMsg);     }}

[Initial value expression Vs value expression]

I found that in terms of variable if I set the following-

[ Initial value expression ="Some data"  , Reset Type=Report  ]  , I get the value in Report

and if I set the following-

[  Value expression ="Some data"   ,   Reset Type=None   ]  I also get the value in Report

Why is it so, what is reset type and how is it related to Initial value expression and valueexpression

And what is the actual difference between "Initial value expression" and "value expression"?

PLS somebody help me, I m new.

[Add Parameter and compile button]

I m used to iReport 2.5, I m new in v.3. I cant understand where the compile button is,though I think when I preview the data, compilation is done.But how to add parameter and initialize it as we did in the previous iReport versions.Can I make a parameterized query in this version as I did in the previous versions?

[SQL Builder limitation]

One of my SQL is working well in MSAccess but the same SQL is not working in ireport sql builder.
I m using odbc connection for MSAccess DB.One more thing that I saw is there is no SQL for multiple
tables;I mean SQL like- tableA.col1=tableB.col1 AND tableC.col1=tableD.col1 and so on.Can anybody tell me
what the problem is with my SQL, the error says- too few parameters but it is running well in
MSAccess query design.And is there anyway I can have multiple table SQL option as mentioned above.

 

Code:

SELECT DISTINCT     SalesInvoice.`ID` AS SalesInvoice_ID,     Unit.`ID` AS Unit_ID,     Unit.`UniteSize` AS Unit_UniteSize,     Unit.`LocationID` AS Unit_LocationID,     Customer.`ID` AS Customer_ID,     Customer.`Name` AS Customer_Name,     SalesInvoice.`TotalAmount` AS SalesInvoice_TotalAmount,     SalesInvoice.`Commission` AS SalesInvoice_Commission,     SalesInvoice.`Paid` AS SalesInvoice_Paid,     SalesInvoice.`Due` AS SalesInvoice_DueFROM     `SalesInvoice` SalesInvoice,     `Unit` Unit,     `Customer` CustomerWHERE     SalesInvoice.ID = UniteSalse.SalesInvoiceID AND UniteSalse.ID = Unit.ID AND SalesInvoice.CustomerID = Customer.ID AND SalesInvoice.ID = '1'