Wednesday, March 30, 2011

Hot to add percentage values in Map Legend Text in SSRS2008

When you configure the map with your data set in SSRS 2008 by default the legend text of the map shows only integer value distribution. If you double click on the map, the map layer dialog box will appear in right hand side, right click on the polygon layer of the map and select polygon color rule.. Map color rule property window will appear, select legend tab in the right side. You will see the current legend item of your map.

Under Legend text you’ll see

#FROMVALUE{N0} - #TOVALUE{N0}

This means you can display integer values only.

If you want the legend text to be displayed in two decimal places change the Legend text as

#FROMVALUE{N2} - #TOVALUE{N2}

By changing the number you can increase/decrease decimal places.

What about percentages?

Similar to previously changed legend text, now change it as

#FROMVALUE{P2} - #TOVALUE{P2}


The number determines the decimal places.

Now you’ll see percentage format in your legend text……..

No comments:

Post a Comment