JasperReports Locale Formatting Patterns

SO22141769.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="SO22141769" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5dec3fda-cd33-4882-bba3-15f2a3bd0869">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<queryString>
		<![CDATA[select CAST('now' as timestamp) as ts, CAST('127647853.233' as double precision) as num from rdb$database]]>
	</queryString>
	<field name="TS" class="java.sql.Timestamp"/>
	<field name="NUM" class="java.lang.Double"/>
	<variable name="LocaleDate" class="java.lang.String">
		<variableExpression><![CDATA[new SimpleDateFormat().toLocalizedPattern()]]></variableExpression>
	</variable>
	<variable name="LocaleNumber" class="java.lang.String">
		<variableExpression><![CDATA[new DecimalFormat().toPattern()]]></variableExpression>
	</variable>
	<variable name="LocaleCurrency" class="java.lang.String">
		<variableExpression><![CDATA[((DecimalFormat)(new DecimalFormat().getCurrencyInstance())).toPattern()]]></variableExpression>
	</variable>
	<detail>
		<band height="125" splitType="Stretch">
			<textField>
				<reportElement uuid="a4a63d19-bc65-44ec-bf18-99bf203a7385" x="0" y="0" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{TS}]]></textFieldExpression>
				<patternExpression><![CDATA[$V{LocaleDate}]]></patternExpression>
			</textField>
			<textField>
				<reportElement uuid="b152f3b0-d689-4998-aff6-30a19327ae58" x="100" y="0" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{NUM}]]></textFieldExpression>
				<patternExpression><![CDATA[$V{LocaleNumber}]]></patternExpression>
			</textField>
			<textField>
				<reportElement uuid="860deb84-649a-41f7-a3be-29317783fd48" x="100" y="20" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{NUM}]]></textFieldExpression>
				<patternExpression><![CDATA[$V{LocaleCurrency}]]></patternExpression>
			</textField>
		</band>
	</detail>
</jasperReport>