July 24, 2009 at 10:24 am
i am trying to convert crystal reports to SSRs
i have few fields with number format so i am trying to find out the equivalent in SSRs
===================
Decimal: 1
Rounding: 1
Negatives: (123)
Thousands separator
leading zero
=======================
decimals: 1.000
rounding: 0.001
Negatives: (123)
thousands separator
leading zerio
======================
Decimals: 1.00
Rouding: 0.01
Negatives: (123)
Thousands Separator
Leading zero
===
can someone plesae suggest how to do the same in SSRS?
July 24, 2009 at 2:50 pm
Set the Format property to D0 for no decimal places, D1 for 1 decimal place, D2 for 2 decimal places, etc. For rounding, you'll want to use an Expression instead of just dropping the field on the report itself, and use the vb function Round(). i.e. =Round(12.453,2) which will result in 12.45
Hope that helps!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply