Solved

SSRS Pie Chart Data Points Inside AND Outside

Posted on 2016-10-11
4
114 Views
Last Modified: 2016-10-12
I'm using SQL Server Data Tools for Visual Studio 2013 to create SSRS reports.  One of the report is a Pie Chart which I want the Data Points to be displayed both Inside and Outside the pie.  Is that even possible?

Under the Pie properties » CustomAttributes » PieLabelStyle you can only select "Inside" or "Outside".  I see an <Expression...> option but I'm not sure how this used to accomplish have the data point labels both inside and outside the pie chart.

Any recommendation or assistance on this would be great!
0
Comment
Question by:KANEDA 0149
[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
4 Comments
 
LVL 12

Accepted Solution

by:
Arifhusen Ansari earned 500 total points
ID: 41839559
Hi,

It's not possible to show the label inside as well as outside of the pie chart.

I just want to know why you need to show the labels both the  way ?
0
 

Author Comment

by:KANEDA 0149
ID: 41840118
Thank you Arifhusen for the confirmation.  I wasn't sure if was possible in SSRS, I kinda figured but I thought I'd ask.  

The reason why I would like it inside & outside was the ability to show the data labels smaller than the pie slice outside so the report viewer can view the values without having to include a data table.  It was more visually appealing.  In the screen shot below you'll see the effect with some data points outside and some on the inside, looks clean.

As a workaround in SSRS, all I did was make the data points invisible if the values were less than 10 and included it in the Legend.  Best solution for me.  Thanks again for your response!

pie_example.jpg
0
 

Author Closing Comment

by:KANEDA 0149
ID: 41840120
Thank you for confirming!
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 41840701
The Labels of the chart also have a Position property. When I set this to:
=iif(Fields!value.Value<10,"Outside","Auto")

Open in new window

I get the effect you are looking for (kind of).
 ChartI tried to find a property to control the distance of the label from the chart, but I couldn't find it.
I've attached the sample report.

You also might find some interesting information in these articles:
https://msdn.microsoft.com/en-us/library/dd220583(v=sql.120).aspx
https://betterdashboards.wordpress.com/2009/01/20/overlapping-labels-on-a-pie-chart/
PieLabels.rdl
1

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

749 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