Solved

Eliminate Currency Symbol

Posted on 2003-10-23
4
206 Views
Last Modified: 2009-11-04
how do i change the data displaying $10.00 to 10.00 without the $ sign

i tried using formula likes CStr({field}) and CDbl({field}) but got error "A string is required here"

the data type in MSSQL in MONEY

so, how? i do not want to display $ sign in my report

urgent! pls help....thank you.
0
Comment
Question by:zoelam
  • 2
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 9605562
Right-click and Format Field
On the number tab deselect 'Show Currency Symbol'

Pete

0
 

Expert Comment

by:w003rpb
ID: 9616794
You can also just select the format with just decimals or even no decimals and no currency sign.  Hope this helps!
Ryan
0
 

Author Comment

by:zoelam
ID: 9624415
sorry, i forgot to mention mine one is a formula field.

when i right click and Format Field, there is no Number tab.

my formula is as follow :

If IsNull({myTable.myField}) Then " - "
Else CStr({myTable.myField})

but the $ sign still show, how do i write a formula to hide it?
0
 
LVL 77

Accepted Solution

by:
peter57r earned 50 total points
ID: 9625396
'If IsNull({myTable.myField}) Then " - "
Else CStr({myTable.myField}) '

This assumes there is ALWAYS a currency symbol:

//start
stringvar MyAmount;

myamount:= cstr({myTable.myField})

if isnull({myTable.myField}) then
 "-"
else if len(myamount)= 0 then
 "-"
else
right(myamount,len(myamount)-1)
//end

Pete
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question