sql server 2005 reporting services display as money

How can I format a field as money in sql server 2005 reporting services?
Who is Participating?
chrismcConnect With a Mentor Commented:
The simplest way is, in the format code set it to "c" or "c2". This is the default for currency but it is your local currency.
You can also specify a custom format like €#,0.00

You could use an expression in the format property like;
=Fields!CurrencySymbol.Value + "#,0.00"

You can write a routine to do all this too, but this is probably enough to get you going.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.