Hai, now i solved this problem.....but now i'm getting a new error...i will paste my code below....here in my database there are some integer values, floating point values and dates..the error which i got at run time is... Exception in thread "main" net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: report32name_1321851599926_222017.java:177: inconvertible types found : java.lang.Float required: java.lang.String value = (java.lang.String)(((java.lang.Float)field_amountpaid.getValue())); //$JR_EXPR_ID=10$ ^ report32name_1321851599926_222017.java:182: inconvertible types found : java.sql.Date required: java.lang.String value = (java.lang.String)(((java.sql.Date)field_date.getValue())); //$JR_EXPR_ID=11$ ^ report32name_1321851599926_222017.java:255: inconvertible types found : java.lang.Float required: java.lang.String value = (java.lang.String)(((java.lang.Float)field_amountpaid.getOldValue())); //$JR_EXPR_ID=10$ ^ report32name_1321851599926_222017.java:260: inconvertible types found : java.sql.Date required: java.lang.String value = (java.lang.String)(((java.sql.Date)field_date.getOldValue())); //$JR_EXPR_ID=11$ ^ report32name_1321851599926_222017.java:333: inconvertible types found : java.lang.Float required: java.lang.String value = (java.lang.String)(((java.lang.Float)field_amountpaid.getValue())); //$JR_EXPR_ID=10$ ^ report32name_1321851599926_222017.java:338: inconvertible types found : java.sql.Date required: java.lang.String value = (java.lang.String)(((java.sql.Date)field_date.getValue())); //$JR_EXPR_ID=11$ ^ 6 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:191) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:148) at jasperdemo.JasperJDBCConnection.main(JasperJDBCConnection.java:19) Java Result: 1 amounpaid is the 'float value' and date is 'date value'....please do help... Nijin Code:package jasperdemo;import java.sql.Connection;import java.io.FileNotFoundException;import java.sql.DriverManager;import java.util.HashMap;import net.sf.jasperreports.engine.*;public class JasperJDBCConnection { public static void main(String[] args) throws FileNotFoundException, JRException { JasperReport jasperReport = null; String path = "/home/NetBeansProjects/JasperDemo/src/jasperdemo/report/"; JasperPrint jasperPrint = null; Connection conn = getConnection(); String templateName = path + "salary.jrxml"; String destinationFile = path + "salary.pdf"; jasperReport = JasperCompileManager.compileReport(templateName); HashMap parameters = new HashMap(); jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, conn); JasperPrintManager.printReport(jasperPrint, true); JasperExportManager.exportReportToPdfFile(jasperPrint, destinationFile); } public static Connection getConnection() { Connection conn = null; String url = "jdbc:mysql://localhost:3306/lifeguard"; String driver = "com.mysql.jdbc.Driver"; String userName = "root"; String password = "admin"; try { Class.forName(driver).newInstance(); conn = DriverManager.getConnection(url, userName, password); System.out.println("Connected to the database"); } catch (Exception e) { e.printStackTrace(); } return conn; }}
