Jump to content
We've recently updated our Privacy Statement, available here ×


  • Posts

  • Joined

  • Last visited

ehssame's Achievements


Rookie (2/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges



  1. I am trying to print some static text in double quotes in a CSV export format report . When I try to put the text as "XYZ" it comes out as """XYZ""" but when I put it as XYZ it comes out correctly as XYZ. The delimiter I am using is , Any thoughts what I might be doing wrong ?
  2. Is it possible to include Multiple SQL's in the same report ? (Not a sub report) Thanks in advance
  3. Hello This is a newbie question. Any help would be greatly appreciated. I am trying to create a CSV report with the delimiter as : Following is an excerpt from my jrxml file " <title><band height="18" isSplitAllowed="true" > <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="127" height="18" key="textField-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Report Generated Date "]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" pattern="MM-dd-yyyy HH:mm:ss" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement ="127" y="0" width="654" height="18" key="textField-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression></textField> </band> </title> " The following results in an output like Report Generated Date :"02-08-2007 18:49:37"::: the desired output I want is Report Generated Date :02-08-2007 18:49:37 without the quotes and the extra :'s Please let me know what am I doing wrong. Thanks in advance
  4. Hello I am using iReports 1.3.0 with JasperReports 1.3.0 1. I have a SQL statement for getting report values and inside the SQL statement I have a scenario like this select a,b,c,CASE WHEN d="Y" e * 2 WHEN d="N" e * 4 ELSE -1 END, f,g from someTable where ......someConditions I can run the SQL in iReports and it gives the Output OK but when I run the same from the java code it errors out giving the exception "net.sf.jasperreports.engine.JRException: Unknown column name : CASEWHEND=YTHENE*2WHEND=NTHENEE*4ELSE-1END 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.next(JRFillDataset.java:727) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:983) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:750) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:363)" Any reasons why this could be happening ? Any alternate ways to do it so that it runs OK from the Java code 2. In the same report I want to show a sequence number , now this sequence number has to be taken from the Db ...how can I embed the 2nd SQL (or is there any other way to do it ) so that I can get the sequence number ? 3. I am using the CSV output and I have noticed that whenever I put in static text in quotes for eg:- "ABC" the output comes out with an extra pair of quotes ""ABC"" . Any thoughts why ? Thanks in advance
  5. Hi I am new to iReports. 1. How do I create customized templates for Reports ?( the xml files which are in the templates folder) 2. Can I specify more than one sql query in a report ? Thanks
  • Create New...