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 |
|
SQLSoaker
Posting Yak Master
169 Posts |
 Posted - 2009-01-20 : 16:30:43
|
| Hello,How to put commas into the result sets of your report?Need this:100000 to be this: 100,000.Thank u in advance.Regards. |
|
|
SQLSoaker
Posting Yak Master
169 Posts |
Posted - 2009-01-20 : 17:26:36
|
| Maybe I am missing something.I have a stored procedure that I am using to generate the report out of SSRS.I attach a new data source and use the exec call:exec sp_mySPIn my sp, my select statements follow this format:cast(isnull(c.balance,0) as decimal(10,2)) as [Current]Now when I run the report the data is casted to a decimal with two places but there are no commas!I have seen other reports that contain commas but am not seeing (at least with the code) how it is being accomplished, is this because I am casting in my sp?Ugh. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-21 : 09:41:59
|
| this should done by selecting the appropriate display format in table cell properties inside report layout tab |
|
|
|
SQLSoaker
Posting Yak Master
169 Posts |
Posted - 2009-01-21 : 17:46:40
|
Thank you Tkizer, exactly what I was looking for. What don't you know? LOL.I've decided to take my project and use SSRS to export to excel. Much better way.Thanks for all the help thru out, much appreciated! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SQLSoaker
Posting Yak Master
169 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-22 : 09:31:14
|
| no problem... |
|
|
|
|
|
|
|
|
Put commas (,) in report