rccos
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by 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
Simple & Silly issue: net.sf.jasperreports.engine.JRException: Unknown column name
in Products
Posted
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