Data lables on Chart

Posted on 2015-01-19
Last Modified: 2015-01-19
I added data labels to my chart but it appears that it is showing labels per every category including the categories that i don't have anything for (ie they appear a zero) ... any way to hide the ones with zero?
Question by:vbnetcoder
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 18

Expert Comment

ID: 40558126
Depending on your query type, add a WHERE or HAVING clause to omit the empty categories.

Author Comment

ID: 40558264
Actually, this is what i needed to do:

=IIf(count(fields!Status.Value) = 0, false, true)
LVL 18

Accepted Solution

Simon earned 500 total points
ID: 40558475
Does your last comment mean you've resolved the problem successfully?

Author Comment

ID: 40558556

Author Closing Comment

ID: 40558557

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor ( Top Charts is a view in which you can set seve…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question