Solved

Not able to edit data labels for pie chart in SSRS

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now