Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
How to hide datapoint label in PieChart if value is 0

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

  • Monday, March 21, 2011 7:00 PM
     
     
    Sign In to Vote
    0
    How to hide datapoint label in PieChart if value is 0.
    Thank you.
     

All Replies

  • Wednesday, March 23, 2011 3:02 PM
    Moderator
     
     Answered
    Sign In to Vote
    1

    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.