Hello everyone, i am new in jasperreports and i couldnt find a solution and i need help. currently i am using ireport 4.6 and netbeans 7.1.2 and jdk 1.7 . i am trying to create a report without parameter but i always have problem to run it. i am using the older version because some reports are created with older version and when i use the newer version its not sufficient. i mean when i change something on the report and compile it i see some other changes that i didnt change but when i use older version i dont see other changes that i didnt change. So my error message is net.sf.jasperreports.engine.JRException: Error executing SQL statement for . And this is my method when i clicked the button private void PrintAllProjectsActionPerformed(java.awt.event.ActionEvent evt) { try{ HashMap parameterMap = new HashMap(); JasperPrint jasperPrint = JasperFillManager.fillReport(ClassLoader.getSystemResourceAsStream("C:/Users/Sorabatur/Desktop/Projects.jasper"), parameterMap, con); JasperViewer.viewReport(jasperPrint, false); } catch(Exception ex) { String connectMsg = "Could not create the report " + ex.getMessage() + " " + ex.getLocalizedMessage(); JOptionPane.showMessageDialog (null,"ERROR -- TDCGUI.runReport: " + ex); JOptionPane.showMessageDialog (null, connectMsg); } } So i dont know what i am doing wrong. And this is my simple sql code without any parameter because i dont need parameter just data from database.SELECT TDCPROJECT."PROJNO" AS TDCPROJECT_PROJNO, TDCPROJECT."PROJNAME" AS TDCPROJECT_PROJNAME, TDCPROJECT."LOCATION" AS TDCPROJECT_LOCATION, TDCPROJECT."CREATIONDATE" AS TDCPROJECT_CREATIONDATE, TDCPROJECT."CREATOR" AS TDCPROJECT_CREATORFROM "TDCOWNER"."TDCPROJECT" TDCPROJECT Could you please help me or at least share your opinions. Thank you .
