Solved

Not able to edit data labels for pie chart in SSRS

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql query 34 35
Read a Table and add those records into a existing parameter that was send from a SSRS report 11 48
sql query Help 12 52
tempdb latch contention 12 47
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
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 …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

943 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

6 Experts available now in Live!

Get 1:1 Help Now