none
How to hide datapoint label in PieChart if value is 0

Answers

  • Hi SSRSRpt,

    Based on your recent posts, I assume you are using Reporting Services 2005. If not, please let me konw.

    In order to hide point lable if value is 0 in Reporting Services 2005, please refer to the steps below:

    1. Right click the chart and select Properties, then select the Data tab in the Chart Properties window.
    2. Double click [Value] in Values list.
    3. In the Value tab, if the original Value property is =Sum(Fields!fieldname.Value), please modify it to
      =IIf(Sum(Fields!fieldname.Value)=0,Nothing,Sum(Fields!fieldname.Value))

    Thanks,
    Tony Chain

     


    Tony Chain [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Wednesday, March 23, 2011 3:02 PM
    Moderator