Format - currency not working

Hi,
I am using reporting services 2000. Setting the format to currency (C) is
not showing the formatted price.
Is this a known problem?What is your value expression for the textbox?
Make sure that the datatype expected for the field is a numeric value.
If the format property doesn't work, set the value of your textbox to
the following expression:
=Format(Fields!MyField.Value, "C")
or
=FormatCurrency(Fields!MyField.Value)
Regards,
Thiago Silva
Gaurav wrote:
> Hi,
> I am using reporting services 2000. Setting the format to currency (C) is
> not showing the formatted price.
> Is this a known problem?|||Thanks Thiago... I was using a Varchar. Changing to numeric did the trick!!
"tafs7" wrote:
> What is your value expression for the textbox?
> Make sure that the datatype expected for the field is a numeric value.
> If the format property doesn't work, set the value of your textbox to
> the following expression:
> =Format(Fields!MyField.Value, "C")
> or
> =FormatCurrency(Fields!MyField.Value)
> Regards,
> Thiago Silva
>
> Gaurav wrote:
> > Hi,
> >
> > I am using reporting services 2000. Setting the format to currency (C) is
> > not showing the formatted price.
> >
> > Is this a known problem?
>