• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 20849
  • Last Modified:

How to convert a formatted number to string in SSRS 2005

I have a text box with the following expression:

=format(Fields!amount.Value,"C0" ) It returns $2,500

However

=str(format(Fields!amount.Value,"C0" )) returns 2500

I need to have the $2,500 returned as a string so i can append it onto a text string.  How do i do this?

0
BostonMA
Asked:
BostonMA
1 Solution
 
Auric1983Commented:
BostonMA,

Try this,

= "text  $" + Fields!amount.Value.ToString

You could also try

=format(Fields!Amount.Value,"C0").ToString

0
 
BostonMAAuthor Commented:
Thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now