Go Premium for a chance to win a PS4. Enter to Win

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

Not able to edit data labels for pie chart in SSRS

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
HSI_guelph
Asked:
HSI_guelph
  • 2
1 Solution
 
HSI_guelphAuthor Commented:
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
 
Mark WillsTopic AdvisorCommented:
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
 
HSI_guelphAuthor Commented:
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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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