Re: NLS parameters in Oracle Reports

joet11_at_comcast.net wrote:
> Hi Frank;
>
> Thanks for the reply. I'm using 10g. The Reports builder in 10 g is
> 9.0.4.33. The DB is 9i. My understanding was that if I set the NLS
> properties, the number, date, and currency fields will be displayed in
> a mask that is appropriate for that language, providing I haven't set
> an explicit mask for the field. However, I've seen several threads
> (many on Oracles discussion board) indicating that other people are
> also unable to get the Alter Session commands to have any impact on
> reports. One poster said that the alter statement will work for Forms
> but not reports.
>
> My goal would be to write one report which would handle multiple
> languages. The non-data text fields (titles, col headings, etc), I
> would retrieve from resource files based on the language. However,
> getting the dates, numbers and currencies (the data) to format with
> language dependent masks is the other piece to the puzzle. The Oracle
> documentation seems to indicate that setting the NLS parameters will
> cause the numbers, dates, and currencies to display in the format based
> on the NLS parameters.
>
> So, for example, in France, the thousand seperator is a space and the
> decimal point is a comma. I am hoping that by simply setting the NLS
> parameters (not in the environment but at runtime in the before report
> trigger) the numbers will be displayed that way.
>
> Have you successfully used an alter stmt on a report trigger?
>
> I've read that an alternative is to pass the language/territory in on
> the URL statement to the reports server. However, at this point I
> don't have a full fledged report server. I am simply using the reports
> developer installed locally on my machine.
>
> Thanks for your help!
> Joe T
>

No, sorry, I was just thinking along with you. What about using the system parameters CURRENCY, DECIMAL and THOUSANDS?
Can be specified when the report is called, iirc

-- 
Regards,
Frank van Bortel