Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

Turning off Point Labels in Report

I am in the process of creating a report and one of the graphs is a pie chart. Most of the totals are small, but there are a few that need highlighting. I can get the point labels to show as I like, but I cannot turn them off for the small values. Is this possible, and if so how.

Here is the code that I currently have for the Point Labels....

=IIF(Count(Fields!OUTAGE_ID__.Value)/Count(Fields!OUTAGE_ID__.Value, "Availability_vwReport_Events") > 0.05, FormatPercent(Count(Fields!OUTAGE_ID__.Value)/Count(Fields!OUTAGE_ID__.Value, "Availability_vwReport_Events"), 1) & "," & Fields!Cause_Code.Value, "")

That works and formats it properly, except the false puts in the series label. Attached is a the graph as it currently stands.

Thanks

Chris
graph.jpg
0
TWCMSN
Asked:
TWCMSN
  • 2
1 Solution
 
catherinelouiseCommented:
Hello Chris!

I'm not an Expert, but had a play around and recreated your problem, and found that by putting at least one space between the double quotes prevented the label from being displayed.

So try this instead

=IIF(Count(Fields!OUTAGE_ID__.Value)/Count(Fields!OUTAGE_ID__.Value, "Availability_vwReport_Events") > 0.05, FormatPercent(Count(Fields!OUTAGE_ID__.Value)/Count(Fields!OUTAGE_ID__.Value, "Availability_vwReport_Events"), 1) & "," & Fields!Cause_Code.Value, " ")

Regards, Catherine
0
 
TWCMSNAuthor Commented:
This works for having the labels blank, but this still leaves the lines. If those can be disabled, the problem is solved. I'll see what I can do, and if someone has any additional informatoin, that would be great.

Thanks,

Chris
0
 
catherinelouiseCommented:
Hey,thanks for accepting my solution - I guess you didn't have much choice though eh ;-)

I just wanted to say that I looked and looked and found other people with the same problem, there just doesn't seem to be an answer for it.  The only additional point I have is that if you don't position the label yourself and use auto-label, then the text generally appears without the line and then this solution works OK.  I guess that all depends on the amount of data on your pie-chart as to whether that really is a suitable solution or not.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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