Jump to content

caprihan

Members
  • Posts

    2
  • Joined

  • Last visited

 Content Type 

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Everything posted by caprihan

  1. 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
  2. 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}
×
×
  • Create New...