Set Locale with a data set

hallj05

<p>Hey,</p><p> </p><p>I'm using BIRT 4.2.2.</p><p> </p><p>I'm trying to set the locale variable that BIRT uses for formatting of dates/currency fields. I've currently got it where I can set the locale to be the value from a report parameter. Is it possible to set the locale to match a result from a data set or to change the report parameter based off the result of the data set?</p><p> </p><p>To change the locale to match the value of the report parameter I am using the following script in the onPrepare:</p><p>reportContext.getDesignHandle().setStringProperty("locale", params["rpLocale"].value);</p><p> </p><p>I want the locale to match the value that is returned from a data set. This data set will only be returning one record with one column, which will contain the value that I want to set to the locale parameter that BIRT uses.</p><p> </p><p>Is there anyway to get BIRT to do this?</p><p> </p><p>Thanks for any help!</p>

micajblock

<p>Funny you asked this. I just posted this example in the Devshare. Hope it helps.</p><p> </p><p><a data-ipb='nomediaparse' href='http://developer.actuate.com/community/devshare/_/designing-birt-reports/new-advanced-localization-technique-r1646'>http://developer.actuate.com/community/devshare/_/designing-birt-reports/new-advanced-localization-technique-r1646</a></p&gt;

hallj05

<p>Thanks mblock, that works perfectly.</p>

SteveStratega

I have the same need but the link above no longer works. Can anyone share an updated link or details of the solution? I need to be able to change the locale per dataset row via the value in a column (row["reportLocale"]).