tanvirtonu1

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.

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

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

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

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

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

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?

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.

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); }}

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.

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?

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'