CODEWITHSUNDEEP
jasper-reportsireport
Bruce Riggs
Bruce Riggs

Reputation: 13

Format a variable in iReport in a string with multiple fields

I have a text field that has the following expression:

$F{casNo} + " Total " + $P{chosenUom} + ": " + $V{total_COUNT}

casNo is a string, chosenUom is a string. total_COUNT is a sum variable of doubles. The total_COUNT variable displays, but it's got 8 - 10 decimal places (1.34324255234), all I need is something along the lines of 1.34.

Here's what I tried already:

$F{casNo} + " Total " + $P{chosenUom} + ": " + new DecimalFormat("0.00").format($V{total_COUNT}).toString()

Any help would be appreciated

For now I'm just doing basic math, but I'm hoping for a real solution, not a workaround

((int)($V{total_COUNT}*100.0))/100.0

Upvotes: 1

Views: 11729

Answers (2)

Arthur Buehrer
Arthur Buehrer

Reputation: 21

You can format the in lline numbers by using: 

new DecimalFormat("###0.00").format(YOUR NUMBER)

Upvotes: 2

Ivan Vrtarić
Ivan Vrtarić

Reputation: 385

You might split the text field into two, one containing everything but the $V{total_COUNT}, and the second containing only $V{total_COUNT}, but with the Pattern property set to something like "#0.00".

You'd have to get a bit creative with layout, though, to prevent unwanted word-wrapping and spacing; for example, first text field could be wide and right-aligned, while text field containing the count could be left-aligned and wide enough to accommodate the formatted number.

Upvotes: 0

Related Questions