formatting a string to a currency format in jasper report

by

The correct expression is:

new java.text.DecimalFormat("$ #,##0.00").format(Double.valueOf($P{strParam}))

The working sample for java.lang.Integer and java.lang.String:

<?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="format_as_current" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
    <parameter name="intParam" class="java.lang.Integer">
        <defaultValueExpression><![CDATA[12345678]]></defaultValueExpression>
    </parameter>
    <parameter name="strParam" class="java.lang.String">
        <defaultValueExpression><![CDATA["12345678.95"]]></defaultValueExpression>
    </parameter>
    <title>
        <band height="79" splitType="Stretch">
            <textField>
                <reportElement x="137" y="18" width="291" height="20"/>
                <textElement/>
                <textFieldExpression><![CDATA[new java.text.DecimalFormat("$ #,##0.00").format($P{intParam})]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="137" y="48" width="291" height="20"/>
                <textElement/>
                <textFieldExpression><![CDATA[new java.text.DecimalFormat("$ #,##0.00").format(Double.valueOf($P{strParam} != null && $P{strParam}.length() > 0 ? Double.valueOf($P{strParam}) : 0))]]></textFieldExpression>
            </textField>
        </band>
    </title>
</jasperReport>

The result will be (preview in iReport):

The result in *iReport*

Note:
You should also add check for null.

You can also use pattern property of textField for formatting data.

The sample:

<?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="format_as_current" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
    <parameter name="intParam" class="java.lang.Integer">
        <defaultValueExpression><![CDATA[12345678]]></defaultValueExpression>
    </parameter>
    <parameter name="strParam" class="java.lang.String">
        <defaultValueExpression><![CDATA["12345678.95"]]></defaultValueExpression>
    </parameter>
    <title>
        <band height="148" splitType="Stretch">
            <textField pattern="$ #,##0.00">
                <reportElement x="218" y="99" width="100" height="20"/>
                <textElement/>
                <textFieldExpression><![CDATA[$P{intParam}]]></textFieldExpression>
            </textField>
            <textField pattern="$ #,##0.00">
                <reportElement x="218" y="119" width="100" height="20"/>
                <textElement/>
                <textFieldExpression><![CDATA[$P{strParam} != null && $P{strParam}.length() > 0 ? Double.valueOf($P{strParam}) : 0]]></textFieldExpression>
            </textField>
        </band>
    </title>
</jasperReport>

The result will be the same.

More Related Contents:

  1. Change date format in a Java string
  2. How to format a Java string with leading zero?
  3. How to convert current date into string in java?
  4. Sprintf equivalent in Java
  5. Print out elements from an Array with a Comma between the elements
  6. Generate fixed length Strings filled with whitespaces
  7. How can I remove punctuation from input text in Java?
  8. How to use String.format() in Java? [duplicate]
  9. Java printf using variable field size?
  10. java , inserting between duplicate chars in String [closed]
  11. Reading String for list of Integers separated by spaces [duplicate]
  12. How do I compare strings in Java?
  13. String.equals versus == [duplicate]
  14. How do I count the number of occurrences of a char in a String?
  15. How to unescape a Java string literal in Java?
  16. Converting A String To Hexadecimal In Java
  17. Java String replace not working [duplicate]
  18. What’s the best way to build a string of delimited items in Java?
  19. How to split a string between letters and digits (or between digits and letters)?
  20. How can non-ASCII characters be removed from a string?
  21. Fastest way to iterate over all the chars in a String
  22. Java String.indexOf and empty Strings
  23. Java: Split string when an uppercase letter is found
  24. How to get data from each dynamically created EditText in Android?
  25. Garbage collection behaviour for String.intern()
  26. XOR operation with two strings in java
  27. Why does String.hashCode() in Java have many conflicts? [closed]
  28. Validating IPv4 string in Java
  29. Use string in switch case in java
  30. Can we access or query the Java String intern (constant) pool?

Leave a Comment