[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2211
  • Last Modified:

Format value to display dollar amount in SSRS 2005

My report displays the following value as a total:

1,706,027.00



The value is displayed in a text boxe with the value displayed as:

=formatnumber(sum(Fields!toproduce.Value*Fields!cost.Value))

I would like to display a dollar before the number so it appears like this:

$ 1,706,027.00
0
Sanjeet
Asked:
Sanjeet
  • 2
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
In your .rdl's design go to the textbox and do a Right Click:Text Box Properties.
Select Number on the left side, then Currency in Category, then 2 decimal places, then however you wish to display negative numbers.
0
 
SanjeetAuthor Commented:
I am using visual studio 2005 Version 8. When I right click on the text box displaying the property for the numeric value I do not see the the property for number.
I am on the rdl of the report.

Is it located anywhere else?
0
 
liijaCommented:
You can also hardcode it with expression:

="$ " & CStr(Format(sum(Fields!toproduce.Value*Fields!cost.Value), "###,###,###.##"))

Combine dollar with your fields first formatted (Format) and then converted to character (CStr)
0
 
SanjeetAuthor Commented:
When I use:

="$ " & CStr(Format(sum(Fields!productperpo.Value*Fields!cost.Value), "###,###,###.##"))

the decimals get removed eg:

$4,450

Also when I apply the same format to a different field:

=formatnumber(sum((cint(Fields!toproduce.Value)- Fields!productperpo.Value)*Fields!cost.Value))

it breaks.
0
 
liijaCommented:
You're right - if your data doesn't have decimals.
The same you also get easier with
=Format(sum(Fields!productperpo.Value*Fields!cost.Value), "C")
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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