November 9, 2012 at 8:37 am
Hi,
I am adding up a column (using a list to display the records), the records are bringing the data across from a int field within a table. I am using formatcurrency to display the records in the list as GBP...However I would like to create a total field ....at the moment I can easily calculate the total using SUM however how I can I format it to GBP as well?
I hope that make sense, this is currently the content of my text box:
=sum(Fields!selling_price.value)
I am using SSRS/ BID 2005
November 9, 2012 at 10:29 am
There's 2 ways to do it.
Leave the Formula the way you have it as
=sum(Fields!selling_price.value)
and then in the properties of the Textbox change the number format (Right Click on Textbox, TextBox Properties, Number) that you want, Including localization. I find this to be the best way.
Or you can apply the format to the expression
=FormatCurrency(sum(Fields!selling_price.value)....
November 9, 2012 at 10:46 am
Ray M (11/9/2012)
There's 2 ways to do it.Leave the Formula the way you have it as
=sum(Fields!selling_price.value)
and then in the properties of the Textbox change the number format (Right Click on Textbox, TextBox Properties, Number) that you want, Including localization. I find this to be the best way.
Or you can apply the format to the expression
=FormatCurrency(sum(Fields!selling_price.value)....
I thought I tried the second way and I recieved an error - I will try them both on monday
thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply