oraclereports - Setting session based NLS_NUMERIC_CHARACTERS in Oracle Reports -

i'm trying create report can switch between english , (canadian) french number formatting (1,234.56 vs 1 234,56) having troubles.

before have tried i'd in past have converted french number character, , made appropriate string modifications there, isn't best solution , i'm trying find better going forward.

the first thing tried doing adding following line before report trigger in oracle report itself:

srw.do_sql ('alter session set nls_numeric_characters = '', ''');  

i have number fields set format mask "(nnngnnngnn0d00)" assume g's , d use session's nls_numeric_characters setting don't seem to.

to see if setting changing created following query in report , displayed it's output:

select value nls_session_parameters parameter = 'nls_numeric_characters'; 

sure enough output changed '.,' ', ' using alter session command.

after researching more online read change needs made in oracle report server configuration per documentation - http://docs.oracle.com/cd/b14099_19/bi.1012/b14048/pbr_conf.htm#i1013352

i contacted team responsible our oracle application server , had them try inserting configurations need set english , french number formatting , added in following:

<environment id="en">     <envvariable name="nls_lang" value="american_america.we8iso8859p1"/>  </environment>  <environment id="fr">     <envvariable name="nls_lang" value="french_canada.we8iso8859p1"/>     <envvabiable name="nls_numeric_characters" value="', '"/>  </environment> 

the report server restarted , entered in url request report, along envid=fr parameter, still no luck. report runs number formatting still using ,'s , .'s grouping , decimal separation.

does know we're missing or else try?