caprihan

Hi, I'm using JasperStudio 6.5.1 on a Mac (Sierra) and am running into a very strange issue off late. Whenever I try to compile my jrxml, I get the error: Unable to create the binary file, check the compilation errors I have no idea what's going on...there is nothing reported in the Problems View or the Error Log View. I've even tried to create a new project, add a blank jrxml with just a text box in it...Preview works perfectly but when I try to compile to .jasper, I get the above message. Any help would be greatly appreciated. Regds, Gaurav

Hi, I need to use a Parameter in the Select part of my SQL as showin in the code window Unfortunately when I run the report AND provide values for the parameter, I get an exception such as Error filling print... Unknown column name : if(tvcr.MEMBER_STAY_FROMDATE BETWEEN DATE_SUB(null, INTERVAL '4' DAY) AND null, DATE_FORMAT(tvcr.MEMBER_STAY_FROMDATE, '%m/%d'), CONCAT('< ', DATE_FORMAT(DATE_SUB(null, INTERVAL '4' DAY), '%m/%d'))) net.sf.jasperreports.engine.JRException: Unknown column name : if(tvcr.MEMBER_STAY_FROMDATE BETWEEN DATE_SUB(null, INTERVAL '4' DAY) AND null, DATE_FORMAT(tvcr.MEMBER_STAY_FROMDATE, '%m/%d'), CONCAT('< ', DATE_FORMAT(DATE_SUB(null, INTERVAL '4' DAY), '%m/%d'))) at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:355) .... Can anyone please provide me a workaround if it exists? Thanks in advance, Gaurav Code:select ci.INSTANCE_SUFFIX,if(tvcr.MEMBER_STAY_FROMDATE BETWEEN DATE_SUB($P{To_Date}, INTERVAL '4' DAY) AND $P{To_Date},DATE_FORMAT(tvcr.MEMBER_STAY_FROMDATE, '%m/%d'),CONCAT('< ', DATE_FORMAT(DATE_SUB($P{To_Date}, INTERVAL '4' DAY), '%m/%d'))), IFNULL(tvcr.MEMBER_CHILDREN_COUNT,'0') + 1from sms_activities.tvc_record tvcr, sms.community_instance ciwhere event_id = $P{Event_ID}and ci.instance_id = tvcr.member_region_idand tvcr.member_stay_fromdate >= $P{From_Date}and tvcr.member_stay_fromdate <= $P{To_Date}