Formatting Numerics to zero decimal precision

Question

Post reply

Formatting Numerics to zero decimal precision

dcatley

SSC Enthusiast

Points: 166
More actions
July 25, 2008 at 7:53 am

#210439

I come from a SAS background, and have tried to jump into the BI tool set in SQL Server 2005.
Creating my first matrix report was no problem, but it for some reason defaults to 4 decimal precision for numerics. How to I control that, and format the numeric fields to 0 decimal precision?
In advance, THANKS for any assist!!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Alasdair Thomson Hall of Fame Points: 3630 More actions · Answer 1

Have you tried something like Convert(Int (#,0), FieldName) As ColumnName...

Have you got any code for us to look at?

Alasdair Thomson Hall of Fame Points: 3630 More actions · Answer 2

Also are you creating a report for use in SQL reports, have you used the .net BI Tookkit to design your reports? If so you can format the values in the report to 0 decimal places, without playing around with your code...

😀

dcatley SSC Enthusiast Points: 166 More actions · Answer 3

thanks for taking the time to respond, I actual just found the needed syntax in an ACCESS book.

It was as simple as $###,###,###. in the properties for the field(s).

I just couldn't find it in the SQL Server 2005 reporting Services book that I have.

Chuck Rivel SSCrazy Points: 2991 More actions · Answer 4

for future reference, if you go to BOL and filter to just the SQL Server Reporting Services Help, type in "Format Property" to look for and you will come to a list of format shortcuts for number and date fields.