sreyu_2k

Hi anagha where do i use this case statement? In the query itself?

I have a field called del_flg in my DB. If the field value is 'N', I want 'User Created' to be displayed. else 'User Deleted' to be displayed in the report. Plz tell me hw to achieve this in iReport.Urgent! Thanks!

Hi, Have connected my report to a SQL DB. I have sued a CASE statement in the Query. The query works perfectly fine when I run it manually in the DB.However when I clcik on Build in the iReport, I am getting the error: Error filling print... net.sf.jasperreports.engine.JRException:Unknown column name:CASE WHEN ....................... I have connected to a SQL 2000 DB. Plz help as I have been held up with this issue for the past one week. Thanks! Code:Error filling print... net.sf.jasperreports.engine.JRException: Unknown column name : CASEWHENBAMT.DEL_FLG='N'THEN'UserCreated'ELSE'UserDeleted'END     at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:357)     at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:113)     at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:788)     at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:752)     at net.sf.jasperreports.engine.fill.JR