Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marina1966
Starting Member
10 Posts |
 Posted - 2008-04-15 : 15:46:22
|
| currency format in sql 2005 reporting services. How to format amount do not display numbers after decimal point? e.g. if the value in the database 139000.82 what function to use (other than C or FormatCurrency)to display amount in the report such as $139,000?Thank you to all!MY |
|
|
asqldeveloper
Starting Member
17 Posts |
Posted - 2008-04-15 : 16:11:30
|
| Go into the properties and then choose format table and choose the format as C0. This will take away the decimal points.Hope this helps. |
 |
|
|
marina1966
Starting Member
10 Posts |
Posted - 2008-04-16 : 08:27:03
|
| Thank you very much! This format (C0) really works.MY |
|
|
|
tahseenm
Yak Posting Veteran
64 Posts |
Posted - 2009-06-12 : 10:52:52
|
| I am using Sql Sever Reporting Services and create a report and one of the field I am using to setup as a currency format. Let me know how to do it to setup on the properties. If I have sub-total showing now is 13900.2655 and I want to change in to currency format and display as $13900.26 with 2 decimal points. Let me know the easy way. Thanks and appreciated and a quick response.moetahsen |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-14 : 03:27:23
|
quote:
Originally posted by tahseenm
I am using Sql Sever Reporting Services and create a report and one of the field I am using to setup as a currency format. Let me know how to do it to setup on the properties. If I have sub-total showing now is 13900.2655 and I want to change in to currency format and display as $13900.26 with 2 decimal points. Let me know the easy way. Thanks and appreciated and a quick response.moetahsen
right click the textbox where you display currency field. click properties. go to format tab. click icon with ellipses(...) it will give you pop with data type for column. select currecy and it will show possible standard formats. select the one you want (with or without decimal places). click apply. |
|
|
|
bongoboyza
Starting Member
1 Post |
Posted - 2010-01-12 : 11:41:23
|
| Hi Guys I am still having a problem with this. However i need to format the field as £ UK pounds sterling. C and C0 seems to format as dollars and so does right clicking on the field and foramting this as a currency. The regional settings are set to UK. This seems really poor formating for a reporting program. Any help would be great. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-12 : 12:27:58
|
quote:
Originally posted by bongoboyza
Hi Guys I am still having a problem with this. However i need to format the field as £ UK pounds sterling. C and C0 seems to format as dollars and so does right clicking on the field and foramting this as a currency. The regional settings are set to UK. This seems really poor formating for a reporting program. Any help would be great.
what have you set as language properties under report properties? it should also be english uk |
|
|
|
|
|
|
format currency in SQL Server 2005 reporting Servi