Home » Developer & Programmer » Reports & Discoverer » different format mask (oracle report 6i)
different format mask [message #417852] Tue, 11 August 2009 18:02 Go to next message
stedav@hotmail.it
Messages: 2
Registered: August 2009
Junior Member
Most countries use a comma to separate thousands. Some countries do not.
How do I handle the different format mask in a report?
I have the format mask : NGNNNGNNNDNN and the value is 1000

but When the customer is the Italian the value must be 1.000,00 while when the customer is English
the value must be 1,000.00

How do I handle the different format mask in a report
Re: different format mask [message #417879 is a reply to message #417852] Wed, 12 August 2009 00:03 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
You can change the format mask dynamically by using SRW.SET_FORMAT_MASK('mask');

Just use this in trigger of the field.

Re: different format mask [message #417924 is a reply to message #417852] Wed, 12 August 2009 02:14 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you research use of the NLS_NUMERIC_CHARACTERS?
Re: different format mask [message #417989 is a reply to message #417879] Wed, 12 August 2009 06:40 Go to previous messageGo to next message
stedav@hotmail.it
Messages: 2
Registered: August 2009
Junior Member
Thanks, can you tell me how is it done?
Re: different format mask [message #417995 is a reply to message #417989] Wed, 12 August 2009 07:38 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I can tell that you, obviously, didn't research use of the NLS_NUMERIC_CHARACTERS parameter.
Previous Topic: Call report through button and updating print flag
Next Topic: Page break/empty page issue with main section height
Goto Forum:
  


Current Time: Wed Dec 07 02:47:40 CST 2016

Total time taken to generate the page: 0.08477 seconds