Formatting numbers contained in SSRS charts
Posted on 2010-09-02
I want my SSRS chart object to display the sum of one of my data fields in its title. The chart title text is defined as the following expression:
="Days Spent per Category ("
& CStr(Sum(Fields!days_spent.Value)) & " days total)"
Unfortunately this is displayed as:
"Days Spent per Category (66.500000 days total)"
"Days Spent per Category (66.5 days total)"
I am already using the SQL ROUND function in the dataset query to ensure days_spent is always rounded to one decimal place, so this is just a presentation issue. Can someone please advise how this number can always be made to present with just one decimal place in my chart legend?