Solved

Not able to edit data labels for pie chart in SSRS

Posted on 2014-03-28
3
819 Views
Last Modified: 2014-03-31
I have a report that works fine and has 3 charts in it.  I am trying to get the labels to show the percent without any decimals but every time I try to access the labels of one of the two charts, VS crashes.  I turned off the labels but now trying to turn them back on crashes VS.

This is the error I get:
Description:
  Stopped working

Problem signature:
  Problem Event Name:      CLR20r3
  Problem Signature 01:      devenv.exe
  Problem Signature 02:      9.0.30729.1
  Problem Signature 03:      488f2b50
  Problem Signature 04:      mscorlib
  Problem Signature 05:      2.0.0.0
  Problem Signature 06:      5265d021
  Problem Signature 07:      15df
  Problem Signature 08:      21
  Problem Signature 09:      System.ArgumentOutOfRange
  OS Version:      6.1.7601.2.1.0.272.7
  Locale ID:      1033

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt

It doesn't crash if I click the other pie chart only the second one I recently added.  
Pie Charts
Any help is greatly appreciated!!!
0
Comment
Question by:HSI_guelph
[X]
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
  • 2
3 Comments
 

Author Comment

by:HSI_guelph
ID: 39962729
Ok, I've figured out what was causing this but not how to stop it.  I changed the chart to collect the small slices and put them together as one marked Other.  If I changed the chart type I could click on the data labels even if I changed it back to a pie chart.  But whenever I put it back to collecting slices it would give me that error.  

So the work around is to get everything set up exactly the way you want it, with regards to the labels, and then set the collected slices.
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 500 total points
ID: 39963622
Valentino has written a great Article to do with Pie Chart techniques and might have some additional ideas for you : http://www.experts-exchange.com/Database/MS-SQL-Server/MS-SQL_Reporting/A_1884-Pie-Chart-Techniques.html
0
 

Author Closing Comment

by:HSI_guelph
ID: 39966574
Ooohh, thank  you very much!  I'll definitely read that.

I left the question up so it can be added to the knowledgebase in case anyone else experiences this problem.  It's a simple workaround but frustrating when you don't know why you can't access the data labels.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

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

Suggested Solutions

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

763 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