How to trim the value in jrxml code

**Deepa** · 12-01-2008, 11:19 AM

Hi,
I wish to generate the pdf file from jrxml.Here i would like to trim the Field value .Here i use the query in java.But i would like to trim the value in jrxml.
Plz help anyone ,how to trim the field.

**Eranga** · 12-01-2008, 12:31 PM

Can you explain more clearly. What's the field are you talking about?

**Deepa** · 12-02-2008, 10:28 AM

Hi,
In the below eg,How to trim the TOTALAMOUNT(Field) Value...

<?xml version="1.0"?>
<jasperReport
name="SimpleReport"
columnCount="1"
printOrder="Horizontal"
orientation="Portrait"
pageWidth="800"
pageHeight="842"
columnWidth="535"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">

<field name="TOTALCNT" class="java.lang.String"/>
<field name="TOTALAMOUNT" class="java.lang.String"/>
<title>
<band height="50" isSplitAllowed="true">
<staticText>

<reportElement
mode="Transparent"
x="200"
y="6"
width="345"
height="39"
forecolor="#0000CC"
backcolor="#FFFFFF"
key="staticText-1"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false" />

<box
topBorder="None"
topBorderColor="#000000"
leftBorder="None"
leftBorderColor="#000000"
rightBorder="None"
rightBorderColor="#000000"
bottomBorder="None"
bottomBorderColor="#000000" />

<textElement
textAlignment="Center"
verticalAlignment="Top"
rotation="None"
lineSpacing="Single">


</textElement>

<text><![CDATA[REPORT]]></text>
</staticText>
</band>
</title>

<pageHeader>
<band height="18">

<staticText>
<reportElement
mode="Transparent"
x="0"
y="0"
width="50"
height="18"
forecolor="#0000CC"
backcolor="#FFFFFF"
key="staticText-2"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false" />

<box
topBorder="None"
topBorderColor="#000000"
leftBorder="None"
leftBorderColor="#000000"
rightBorder="None"
rightBorderColor="#000000"
bottomBorder="None"
bottomBorderColor="#000000" />

<textElement
textAlignment="Left"
verticalAlignment="Top"
rotation="None"
lineSpacing="Single">

</textElement>

<text><![CDATA[TOTALCNT]]></text>
</staticText>

<staticText>
<reportElement
mode="Transparent"
x="70"
y="0"
width="100"
height="18"
forecolor="#0000CC"
backcolor="#FFFFFF"
key="staticText-2"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false" />

<box
topBorder="None"
topBorderColor="#000000"
leftBorder="None"
leftBorderColor="#000000"
rightBorder="None"
rightBorderColor="#000000"
bottomBorder="None"
bottomBorderColor="#000000" />

<textElement
textAlignment="Left"
verticalAlignment="Top"
rotation="None"
lineSpacing="Single">

</textElement>

<text><![CDATA[TOTALAMOUNT]]></text>
</staticText>
</band>
</pageHeader>

<detail>
<band height="20">

<textField
isStretchWithOverflow="false"
pattern=""
isBlankWhenNull="false"
evaluationTime="Now"
hyperlinkType="None"
hyperlinkTarget="Self"
bookmarkLevel="0">

<reportElement
mode="Transparent"
x="0"
y="0"
width="50"
height="18"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false" />

<box
topBorder="None"
topBorderColor="#000000"
leftBorder="None"
leftBorderColor="#000000"
rightBorder="None"
rightBorderColor="#000000"
bottomBorder="None"
bottomBorderColor="#000000" />

<textElement
textAlignment="Left"
verticalAlignment="Top"
rotation="None"
lineSpacing="Single">

</textElement>

<textFieldExpression class="java.lang.String">
<![CDATA[$F{TOTALCNT}]]>
</textFieldExpression>
</textField>

<textField
isStretchWithOverflow="false"
pattern=""
isBlankWhenNull="false"
evaluationTime="Now"
hyperlinkType="None"
hyperlinkTarget="Self"
bookmarkLevel="0">

<reportElement
mode="Transparent"
x="70"
y="0"
width="100"
height="18"
forecolor="#000000"
backcolor="#FFFFFF"
key="textField"
stretchType="NoStretch"
positionType="FixRelativeToTop"
isPrintRepeatedValues="true"
isRemoveLineWhenBlank="false"
isPrintInFirstWholeBand="false"
isPrintWhenDetailOverflows="false" />

<box
topBorder="None"
topBorderColor="#000000"
leftBorder="None"
leftBorderColor="#000000"
rightBorder="None"
rightBorderColor="#000000"
bottomBorder="None"
bottomBorderColor="#000000" />

<textElement
textAlignment="Left"
verticalAlignment="Top"
rotation="None"
lineSpacing="Single">

</textElement>

<textFieldExpression class="java.lang.String">
<![CDATA[$F{TOTALAMOUNT}]]>
</textFieldExpression>
</textField>
</band>
</detail>

<columnFooter>
<band height="9" isSplitAllowed="true" />
</columnFooter>

<pageFooter>
<band height="40" isSplitAllowed="true">
<line direction="TopDown">
<reportElement x="0" y="10" width="800" height="1" positionType="FixRelativeToTop" stretchType="NoStretch" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />
<graphicElement />
</line>
<textField isStretchWithOverflow="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" bookmarkLevel="0">
<reportElement x="200" y="20" width="80" height="15" positionType="FixRelativeToTop" stretchType="NoStretch" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />
<textElement textAlignment="Right" />
<textFieldExpression class="java.lang.String">
<![CDATA[ "Page " + String.valueOf($V{PAGE_NUMBER}) + " of"]]>
</textFieldExpression>
</textField>
<textField evaluationTime="Report" isStretchWithOverflow="false" hyperlinkType="None" hyperlinkTarget="Self" bookmarkLevel="0">
<reportElement x="280" y="20" width="75" height="15" positionType="FixRelativeToTop" stretchType="NoStretch" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />
<textElement />
<textFieldExpression class="java.lang.String">
<![CDATA[ " " + String.valueOf($V{PAGE_NUMBER})
]]>
</textFieldExpression>
</textField>
</band>
</pageFooter>

</jasperReport>

**gustio** · 12-02-2008, 12:58 PM

I am not sure what do you mean. But, I used trim function at database query (SQL iReport). I think you can Cast number value to String value, then used trim function. Hope help

**Eranga** · 12-03-2008, 06:58 AM

First of all try to explain your question more clearly. You have post a large code here, I don't think anyone knows what you need to have there.

**Deepa** · 12-03-2008, 10:57 AM

Hi Ergana,
How to trim the String value .This string is get it from query and used in jrxml.How to trim the string value by using jrxml code.

**Eranga** · 12-03-2008, 01:11 PM

I don't know what jrxml code do. What trim done on String in Java is, remove all starting and ending spaces.

**CJSLMAN** · 12-03-2008, 01:24 PM

Deepa... to you, what does trim mean?

CJSL

**Deepa** · 12-04-2008, 05:49 AM

I want to remove the spaces.I mean,
For an eg:

String amt=" 12,000.00";
System.out.println("amt:"+amt.trim())

Output:
amt:12,000.

This is done by java code.But what i'm required means,i get the amt value from database and after that i will trim that amt value by using jrxml code.

**Eranga** · 12-04-2008, 06:01 AM

Do you want to remove spaces at the start of string or decimal values, as your output says.

**Deepa** · 12-04-2008, 06:17 AM

To remove spaces at the start of string value.But this is done by jrxml code.

**Eranga** · 12-04-2008, 07:11 AM

Since String API able to do this easily, I don't know why are you suing another API?

**rasikow** · 01-03-2009, 08:27 AM

Hi all,

i want to give condition in my jrxml file.

For example, i am fetching one fields "currentStatus", Integer data type

if current status equal to 9, it should display "Submitted"
if 10, "placed"
if 11, blah blah.....etc...

How to do that?

Thanks in advance.

- Gnaniyar Zubair