SQLTeam.com | Weblogs | Forums

How do I format a decimal in an SSRS chart?

sql2008r2

#1

The sql in thedataset produces numbers like 42.422825070100. Without modifying the sql query, is there a way to format a bar chart such that the number will be 41.42?

If I click on the numeric label, the properties window has an option to format. What should I put there


#2

What data type is that value from source?


#3

I figured it out through trial and error. The solution is to click on the actual number in the design and then in the properties window there is a setting for "Format". There, just type
#.###
for three digits after the decimal