jasper report with netbeans 5.0
please help
net.sf.jasperreports.engine.JRException: Could not load object from location : Purchase_Supp_Add.jasper
try {
Statement stmt;
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/Salesreport";
Connection con =DriverManager.getConnection(url,"root", "root");
stmt = con.createStatement();
// JasperReport subreport = null;
// ResultSet rs = stmt.executeQuery("select *from suppdetails_tbl where cpy_name= '"+Supplier_po.getSelectedItem()+"'");
// String reportSource = "D:\\Sales Report Tool March 20\\report\\Jasp report\\purchase.jrxml";
String reportDest = "D:\\Sales Report Tool March 20\\report\\Jasp report\\purchase.pdf";
String reportSource ="D:\\Sales Report Tool March 20\\report\\Jasp report\\purchase.jrxml";
String reportSource1 ="D:\\Sales Report Tool March 20\\report\\Jasp report\\Purchase_Supp_Add.jasper";
JasperReport jasperReport =JasperCompileManager.compileReport(reportSource);
// JasperReport jasperReport1 =JasperCompileManager.compileReport(reportSource1) ;
Map parameter = new HashMap();
//parameter for master report
Object a=Po_comb.getSelectedItem();
parameter.put("Ponum", a);
//parameter for subreport
parameter.put("sub", "reportSource1");
JasperPrint print = JasperFillManager.fillReport(jasperReport, parameter, con);
System.out.println("Crossed 6");
JasperExportManager.exportReportToPdfFile(print, reportDest);
System.out.println("Crossed 7");
JasperViewer.viewReport(print,false);
System.out.println("Crossed 8");
} catch (JRException e)
{
e.printStackTrace();
}
// Exception handling for the Class.forName method.
catch (ClassNotFoundException ex)
{
ex.printStackTrace();
}
// Exception handling for the DriverManager.getConnection method.
catch (SQLException ex)
{
ex.printStackTrace();
}
my mail id is :shri.nithya@gmail.com
geetha
|