1

I have to add 'id' (String) for barcode in iReport.

The id is of 8 digits (this could vary), I want to add 4 leading 0's to it. So that the length of id becomes 12.

jrxml

<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="PadStringNumber" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="07c0dc81-9b58-48f9-8129-e0e08fe1cb98">
    <parameter name="id" class="java.lang.String">
        <defaultValueExpression><![CDATA["23423552"]]></defaultValueExpression>
    </parameter>
    <queryString>
        <![CDATA[]]>
    </queryString>
    <title>
        <band height="39" splitType="Stretch">
            <textField>
                <reportElement x="0" y="0" width="550" height="30" uuid="26317c0f-77c0-46cb-a4d8-1ee4fa1e7387"/>
                <textFieldExpression><![CDATA[String.format("%12d",$P{id})]]></textFieldExpression>
            </textField>
        </band>
    </title>
</jasperReport>

My current error is:

Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: String.format("%12d",$P{id})
    at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:291)
    at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:618)
    at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:586)
    at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:1020)
    at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:567)
    at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:551)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:281)
    at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:504)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:315)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:251)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:119)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:558)
    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String
    at PadStringNumber_1566475648252_841187.evaluate(PadStringNumber_1566475648252_841187:178)
    at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:277)
    ... 13 more
Improve this question
8
  • @PetterFriberg The ID is not fixed, length could vary, but I need a fix length of 12 to be displayed for the barcode. I have tried String.format("%12d", $F{myBarcode}), it throws this error : " Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException" Commented Aug 22, 2019 at 11:31
  • Ok, show a minimal version of the jrxml minimal reproducible example and the exact error you get (stacktrace) edit the question. Commented Aug 22, 2019 at 11:37
  • In my DB the id value is integer, I am converting to String in java class and further using the data. It shows this as another cause, "Caused by: java.util.IllegalFormatConversionException: d != java.lang.String" Commented Aug 22, 2019 at 11:45
  • Yeah you need to parse it to Integer (or pass it as Integer) or use a lib, if you edit, probably I can answer Commented Aug 22, 2019 at 11:46
  • Just make a small new jrxml with this problem and show stacktrace Commented Aug 22, 2019 at 11:49

1 Answer 1

Reset to default
0

The error is related to that you can not format a String with a number pattern %12d, to use this you need parse your String to a number first which naturally can not be done if it is not a number

As a general solution in jasper reports I would use org.apache.commons.lang3.StringUtils.leftPad, jasper reports already have this library as a dependence through commons-collections (no need to install). This method will work with any string even "HelloWorld" 

org.apache.commons.lang.StringUtils.leftPad($P{id}, 12, "0")

If you are sure id is always a number you could also parse the string first (it will throw error if it is not a number). I'm using Long since Integer has a max value of 2147483647.

String.format("%012d", Long.parseLong($P{id}))

Full jrxml example

<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="PadStringNumber" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="07c0dc81-9b58-48f9-8129-e0e08fe1cb98">
    <parameter name="id" class="java.lang.String">
        <defaultValueExpression><![CDATA["23423552"]]></defaultValueExpression>
    </parameter>
    <queryString>
        <![CDATA[]]>
    </queryString>
    <title>
        <band height="177" splitType="Stretch">
            <staticText>
                <reportElement x="0" y="10" width="550" height="30" uuid="b4a554e1-25c2-4bf9-a6f2-5d9b1a937384"/>
                <textElement verticalAlignment="Middle">
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[org.apache.commons.lang.StringUtils.leftPad]]></text>
            </staticText>
            <textField>
                <reportElement x="0" y="40" width="550" height="30" uuid="26317c0f-77c0-46cb-a4d8-1ee4fa1e7387"/>
                <textElement verticalAlignment="Middle"/>
                <textFieldExpression><![CDATA[org.apache.commons.lang.StringUtils.leftPad($P{id}, 12, "0")]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement x="0" y="100" width="550" height="30" uuid="64bbd86b-bcf4-41ea-892b-0511fcc9167b"/>
                <textElement verticalAlignment="Middle">
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[Long.parseLong()]]></text>
            </staticText>
            <textField>
                <reportElement x="2" y="130" width="550" height="30" uuid="384e670e-b682-4491-9937-64441bd73203"/>
                <textElement verticalAlignment="Middle"/>
                <textFieldExpression><![CDATA[String.format("%012d", Long.parseLong($P{id}))]]></textFieldExpression>
            </textField>
        </band>
    </title>
</jasperReport>

Result

output

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.