August 23, 2011 at 8:30 am
Hello, I am very new to SSRS, so please bear with me.
I have a report that displays 5 different measures onto a Line Chart in 2005 SSRS. The problem is that 2 of the measures are %s with 2 decimal places, and show up on the Y axis of the chart as so. The other 3 measures are whole numbers and appear fine on the Y axis. My question is how would I go about showing the %s as rounded numbers just as the whole numbers are displayed?
Is there a type of iif expression that I can use in the scale properties for the percentage results?
Please let me know if you need more info.
Thanks for you help.
August 23, 2011 at 12:20 pm
One option would be to make the change to the data in the query. If you just multiply the two measures that are percentages by 100, then they will become numbers that are in the same range as the others.
If you would prefer to do it in the report you can select report properties --> data tab --> then select the measure and use the expression editor to multiply it by 100 in this location.
Either should work. Good luck, Steve
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply