Solved

Not able to edit data labels for pie chart in SSRS

Posted on 2014-03-28
3
864 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

Veeam gives away 10 full conference passes

Veeam is a VMworld 2017 US & Europe Platinum Sponsor. Enter the raffle to get the full conference pass. Pass includes the admission to all general and breakout sessions, VMware Hands-On Labs, Solutions Exchange, exclusive giveaways and the great VMworld Customer Appreciation Part

Question has a verified solution.

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

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…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

636 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