• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 99
  • Last Modified:

Data lables on Chart

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?
0
vbnetcoder
Asked:
vbnetcoder
  • 3
  • 2
1 Solution
 
SimonCommented:
Depending on your query type, add a WHERE or HAVING clause to omit the empty categories.
0
 
vbnetcoderAuthor Commented:
Actually, this is what i needed to do:

=IIf(count(fields!Status.Value) = 0, false, true)
0
 
SimonCommented:
Does your last comment mean you've resolved the problem successfully?
0
 
vbnetcoderAuthor Commented:
yes
0
 
vbnetcoderAuthor Commented:
ty
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now