Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 29, 2013 08:08 AM by micnie2020
Member
306 Points
523 Posts
Jan 29, 2013 06:50 AM|LINK
Hi all,
I had set
expression as Format(Fields!UnitPrice.Value,"C")
It's show $1,000,000.00
But i need it to show in £ 1,000,000.00
Please advise?
Thank you.
Regards,
Micheale
Jan 29, 2013 08:08 AM|LINK
Solved!
Answer:
Format(Fields!UnitPrice.Value,"'£'#,0;('£'#,0)")
micnie2020
Member
306 Points
523 Posts
SSRS Expression Format show GBP instead of Dollar sign
Jan 29, 2013 06:50 AM|LINK
Hi all,
I had set
expression as Format(Fields!UnitPrice.Value,"C")
It's show $1,000,000.00
But i need it to show in £ 1,000,000.00
Please advise?
Thank you.
Regards,
Micheale
micnie2020
Member
306 Points
523 Posts
Re: SSRS Expression Format show GBP instead of Dollar sign
Jan 29, 2013 08:08 AM|LINK
Solved!
Answer:
Format(Fields!UnitPrice.Value,"'£'#,0;('£'#,0)")