OraFAQ Forum: Reports & Discoverer » different format mask

Home » Developer & Programmer » Reports & Discoverer » different format mask (oracle report 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

different format mask [message #417852]

Tue, 11 August 2009 18:02

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

Report message to a moderator

Re: different format mask [message #417879 is a reply to message #417852]

Wed, 12 August 2009 00:03

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.

Report message to a moderator

Re: different format mask [message #417924 is a reply to message #417852]

Wed, 12 August 2009 02:14

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you research use of the NLS_NUMERIC_CHARACTERS?

Report message to a moderator

Re: different format mask [message #417989 is a reply to message #417879]

Wed, 12 August 2009 06:40

stedav@hotmail.it
Messages: 2
Registered: August 2009

Junior Member

Thanks, can you tell me how is it done?

Report message to a moderator

Re: different format mask [message #417995 is a reply to message #417989]

Wed, 12 August 2009 07:38

Littlefoot
Messages: 21807
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.

Report message to a moderator

Previous Topic:	Call report through button and updating print flag
Next Topic:	Page break/empty page issue with main section height

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 09:39:17 CDT 2024