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 |
|
Dance Doll
Yak Posting Veteran
54 Posts |
 Posted - 2008-01-29 : 11:04:20
|
| Hi All,I have a integer field in Reporting Services. I know how to make number like 10000 to 10,000 in RS 2000 but don not know in SSRS.Please help me out.Thanks! |
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-01-29 : 11:16:53
|
| If you are talking about displaying value in a text box or in a cell in a table, then you can select property and select format tab. there you can choose representation of the result in any way you like. (for 123,456.00 the code is N)(If I understood your question right) |
 |
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2008-01-29 : 11:21:25
|
| You understood perfectly! I got it but I don't want the decimal number like .00 for integers. How do I elimite that?Thanks! |
|
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-01-29 : 11:42:05
|
| Just have a look at standard Microsoft formatting codes, they apply throughout. I used something like that 0,,.0 or you can try substituting each number with # to represent a format but its not flexible... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-29 : 12:58:38
|
| use something like "###,##0" inside format inputbox for the textbox/cell |
|
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2008-01-29 : 14:34:36
|
| Serge & visakh16, thanks for replying my message.I found a way to do that: in the Format tab, just type "N0", I got what I want.... |
|
|
|
|
|
|
Add Commas to Integer Numbers