rccos

Further thourough checking of the my application logs shows some possible reasons. My applicaiton is having some jasper related exception and my new query is not reflecting there. Could it be due to the following...?? Caused by: java.lang.NoSuchFieldException: AXIS_LABEL_FONT_SIZE Caused by: java.lang.NoSuchFieldException: AXIS_LABEL_FONT_SIZE java.lang.NoSuchFieldException: AXIS_TICK_LABEL_FONT_SIZE etc... Detailed log in the attachments. Is it possible because of the above following exceptions , my new query is not deployed into my application? Any clue or ideas highly appreciated. Thanks rccos

Hi All, I am facing since 3 days one silly issue with Jasper Report. I have created 2 months back one jasper report and being used succesfully in the application. The query gets executed in ireports as well as in Java code. =========Existing query, Begin SELECT QA_SHIPS_EVALUATION."SHIPS_MGMT_COMMENTS" AS QA_SHIPS_EVALUATION_SHIPS_MGMT_COMMENTS, (select QA_CLIENTS.CLIENT_FIRSTNAME from QA_CLIENTS where QA_CLIENTS.CLIENT_ID_PK=CLIENT_ID_FK) as FirstName, (select QA_CLIENTS.CLIENT_LASTNAME from QA_CLIENTS where QA_CLIENTS.CLIENT_ID_PK=CLIENT_ID_FK) as LastName,MONTH_ENTERED FROM QA_SHIPS_EVALUATION where SHIPLODGE_ID_FK=$P{shipLodge_id} and MONTH_ENTERED=$P{month} ================End Now I have a requirement which is a simple modification to get Ship name as well. =====================My new query Begin SELECT QA_SHIPS_EVALUATION."SHIPS_MGMT_COMMENTS" AS QA_SHIPS_EVALUATION_SHIPS_MGMT_COMMENTS, (select QA_CLIENTS.CLIENT_FIRSTNAME from QA_CLIENTS where QA_CLIENTS.CLIENT_ID_PK=CLIENT_ID_FK) as FirstName, (select QA_CLIENTS.CLIENT_LASTNAME from QA_CLIENTS where QA_CLIENTS.CLIENT_ID_PK=CLIENT_ID_FK) as LastName,MONTH_ENTERED, (select QA_SHIP_LODGE_DETAILS.NAME from QA_SHIP_LODGE_DETAILS where QA_SHIP_LODGE_DETAILS.SHIP_LODGE_ID_PK=SHIPLODGE_ID_FK) as EupName FROM QA_SHIPS_EVALUATION where SHIPLODGE_ID_FK=$P{shipLodge_id} and MONTH_ENTERED=$P{month} ==============End The above query works in ireport upon preview and in sql server editor (my database is on sql server 2008). Once I use it in the my application the following error occurs. net.sf.jasperreports.engine.JRException: Unknown column name : EupName at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:355) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:112) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:823) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:787) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1478) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:125) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:942) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:841) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417) at servlet.ReportServlet.generatePDFReport(ReportServlet.java:2208) at servlet.ReportServlet.doGet(ReportServlet.java:159) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)....................................................................................I am kind of lost here in understanding why the above error since 3 days. Any ideas where I am making blunder, please?I really really appreciate the help. I use Ireports 3.7.6. Thanks rccos