Q:

how to customize the pattern of a field in iReport?

Hi StackOverflow experts,
   I've darag n' droped a field into the iReport. This field holds the java.lang.BigDecimal expression class data returned by Query of the Report. In the MSSQL DataBase table this field has been defined as money. I've defined the pattern of this field as  #,###0.00 separate the digits by comma from Right to Left order at each 3 digits(eg. 12,332,324.20).But I want the digits to be separated by comma in same order but at 3 digit interval for first time and at 2 digit interval for remaining digits(For eg.1,23,32,324.20). Please, suggest me.

A:

You can use any java expression as the value. For instance, you can use this as the value:
"Report between " + new SimpleDateFormat("dd.MM.yyyy").format($P{startDate}) + " and " + new SimpleDateFormat("dd.MM.yyyy").format($P{endDate})

but be careful of null pointer exceptions.
$P{xxx} is a parameter to the report.
$F{yyy} is the field/column in the report.

