Home » Developer & Programmer » Reports & Discoverer » Format Mask to currency (oracle 10g reports)
Format Mask to currency [message #360467] Fri, 21 November 2008 02:16 Go to next message
DRASTANT
Messages: 21
Registered: July 2007
Location: KENYA
Junior Member
Hi all
i am trying to put *** as my fillers. i.e total size for my character field is 15 if the ammount is coming to 6 digits it should put remaning fields as ********. Can i do this using format mask.

pls assist
thanks
drastant
Re: Format Mask to currency [message #360489 is a reply to message #360467] Fri, 21 November 2008 02:53 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

Copy this and use in Format mask property
-***************
Re: Format Mask to currency [message #360506 is a reply to message #360489] Fri, 21 November 2008 03:53 Go to previous messageGo to next message
DRASTANT
Messages: 21
Registered: July 2007
Location: KENYA
Junior Member
thanks a lot
this worked
can you explain mw -**** what does it suggest in technical terms

Re: Format Mask to currency [message #360523 is a reply to message #360467] Fri, 21 November 2008 04:40 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Prints one digit, unless it is a leading zero 
to the left of the decimal 
point, 
in which case an 
asterisk (*) is printed. 
Trailing zeros to the right of the 
decimal point are printed.


Open the oracle report and go to format mask property , Press F1
and Click the Number Format Mask. You will get all formats there.

[Updated on: Fri, 21 November 2008 04:41]

Report message to a moderator

Re: Format Mask to currency [message #379646 is a reply to message #360467] Wed, 07 January 2009 07:50 Go to previous messageGo to next message
DRASTANT
Messages: 21
Registered: July 2007
Location: KENYA
Junior Member
Thanks for your assistance but after long trouble shooting i have found out my ammount field is charcter format it does not have option of format mask

please help urgently

thanks
drastant
Re: Format Mask to currency [message #379689 is a reply to message #379646] Wed, 07 January 2009 12:03 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why do you store numbers into character columns?

Remedy might be simple (if I understood the problem, that is): use the LPAD function:
SQL> WITH TEST AS
  2    (SELECT '12345' amount FROM dual UNION
  3     SELECT '12,345' FROM dual UNION
  4     SELECT '12,345.67' FROM dual
  5    )
  6  SELECT amount, LPAD(amount, 12, '*') result
  7  FROM TEST;

AMOUNT    RESULT
--------- ------------------------------
12,345    ******12,345
12,345.67 ***12,345.67
12345     *******12345

SQL>


[EDIT]
DRASTANT
please help urgently

What do you mean by saying that? It took you almost 2 months to reply to previous message! Therefore, it doesn't seem to be that urgent. Besides, lack of planing on your side certainly doesn't imply urgency on my side.

[Updated on: Wed, 07 January 2009 12:06]

Report message to a moderator

Re: Format Mask to currency [message #379818 is a reply to message #360467] Thu, 08 January 2009 00:53 Go to previous messageGo to next message
DRASTANT
Messages: 21
Registered: July 2007
Location: KENYA
Junior Member
littlefoot
I am really sorry for that comment as this was out of our agenda for some time.

Now the pervois format mask property which i applied on number field as you suggested _*********** when i exceute the report it only prints the leading two digits and rest as '*' for e.g if i print 12,678.87 then it prints only **********12

kinldy asssist.

thanks
drastant
Re: Format Mask to currency [message #379833 is a reply to message #379818] Thu, 08 January 2009 01:34 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
DRASTANT
... as you suggested _***********

No, I did not suggest that. Re-read my previous (and only so far) message in this topic - I have suggested you to use the LPAD function.
Re: Format Mask to currency [message #380367 is a reply to message #379818] Sun, 11 January 2009 07:08 Go to previous message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Drashtant,
Which One you are trying the Format mask or the LPAD?
LF Suggested to Use a LPAD Simply Check man...


select LPAD(sal, 15 ,'*') from emp

I thought u allready got your Idea.

Javed
Previous Topic: Water Mark on Reports(Urgent!)
Next Topic: DISCOVERER 10G report function not diplaying the data.
Goto Forum:
  


Current Time: Sat Dec 10 06:46:38 CST 2016

Total time taken to generate the page: 0.07561 seconds