[CSV format]

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 ?

[Report Output]

Anyone?

 

Thanks

[Using case statement and sequence value]

Anyone ?

 

Thanks

[Multiple SQL]

Is it possible to include Multiple SQL's in the same report ? (Not a sub report)

 

Thanks in advance

[Report Output]

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

[Using case statement and sequence value]

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

[iReport queries]

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