May 20, 2014 at 7:40 am
Hello,
I am developing an ssrs report where I have a field which gets data as 1.00 - 2.00
I selected the format in text box property as currency ->use 1000 separator ->decimal places as 2
But I need to get as $1.00 - $2.00
But its not giving dollar symbol when I generate report
if I have one value like 2.00 at that time I am able to get as $2.00
How can I write the expression for this?
Any help?
May 20, 2014 at 8:28 am
Are you displaying the string "1.00 - 2.00"? If so, you'll have to roll your own formatting. Something like (untested):
=FormatCurrency(Fields!val1.Value,0) + " - " + FormatCurrency(Fields!val2.Value,0)
May 20, 2014 at 8:46 am
Thank you for the reply
But the entire value in the field is as like 1.00-2.00
Its not separate from the database itself its retrieving as like 1.00-2.00
May 20, 2014 at 1:25 pm
Since the data is coming in as a string then you could do something like this:
="$" & Replace(Fields!amount.value, "-", "-$")
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply