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 |
|
a_k93
Starting Member
2 Posts |
 Posted - 2006-02-08 : 09:14:17
|
| Hi there,Is it possible to have a custom format for the numeric value for eg. If I get numeric value say 1500000.64. Now I want it to be displayed in 1,50,00,00.64. Is it possible. I tried it by selecting the custom Radio button and entered #,##,##.00, but not of use, as it displayed 1,500,000.64 in this fashion in RDL.I am using MS Reporting Service 2000.Thanx in advance.a_k93 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-02-08 : 09:29:20
|
| Welcome to SQLTeami have not used MS reporting, but i know if you are using a frontend like ASP, or .net it is possible with the formatnumber or formatcurrency fucntionAfrika |
 |
|
|
a_k93
Starting Member
2 Posts |
Posted - 2006-02-08 : 09:45:03
|
| Thanks afrika,Do you know any such function to be used in the expression window.a_k93 |
|
|
|
jhermiz
3564 Posts |
Posted - 2006-02-08 : 09:59:03
|
Right click the field and go to the properties selection. Under format you have your available options:DefaultNumberDateTimePercentageCurrencyetc...
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
|
|
|
|
|
Formatting column of Numeric value