APEX

Hi again,

Apex 3.2.0
Oracle XE

I was wondering if you could help.

I have a combo box on a form region that selects a language. The idea of this is to change the number and date formats when displaying data in reports and on forms.

On my reports and forms my format strings are set to a page item e.g. :P10_CURRENCY_FORMAT which contains the oracle currency format I need, e.g. FML999G999G999G999G990D00.

I can then set the NLS_CURRENCY value by either altering the session or via the apex.util:

ALTER SESSION SET NLS_CURRENCY='£';
or
APEX_UTIL.SET_SESSION_STATE('FSP_LANGUAGE_PREFERENCE','en-gb');

and the correct currency symbol appears in front of the number in the report.

This all works fine until I get to filtering interactive reports.

The problem is when I want to filter interactive reports all the currency settings are set back to the APEX defaults set in APPLICATION/GLOBALIZATION.

I then created a BEFORE HEADER process to alter the session, however when filtering interactive reports, the page isn't refreshed so this takes no effect.

So I have ended up with £ symbols in my report columns and when I filter it, they all change to $ symbols, the next page reverts back to £ until I filter again.

Am I going about it all the wrong way, or does anybody have any ideas?

Thanks,

Blackstone.