Solved

SSRS Pareto Chart adjust Axis

Posted on 2014-10-04
4
753 Views
Last Modified: 2014-10-08
Hello Experts Exchange
I'm developing a chart in SSRS that a have used the Pareto option under the Chart Series Properties - CustomAttributes - ShowcolumnAs.

I have attached a screen shot of my chart.

How do I adjust the percentage column on the right of the chart?  

I want the axis to come down so that the columns in the column chart look larger.

Regards

SQLSearcher
Pareto-Chart.jpg
0
Comment
Question by:SQLSearcher
[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
  • 2
4 Comments
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 40362347
Looks like a bug in SSRS. I've googled some samples and they also have the same problem. The height of the axis is equal to the sum of the values. Manual setting for the scale of the axis are ignored. This makes this feature totally unusable. You can google for "ssrs pareto" to get some samples of how to create Pareto charts in SSRS without using the Pareto property. This is much more complex of course, but it gives you the result you want.
I haven't checked it but I think this article has some good instructions:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/802a35d2-9e32-453c-99db-159a65e8105c/display-cumulative-percenatges-on-ssrs-pareto-chart
0
 

Author Comment

by:SQLSearcher
ID: 40364313
Hello Nicobo
I really need some help with this,  my skill with SSRS are only beginner and this article does not give me a step by step instruction on how to achieve a Pareto chart.

I have taken off the Pareto chart from my chart and left with a column chart, what do I do next to get a Pareto chart?

Regards

SQLSearcher
0
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 total points
ID: 40365364
Rename Pareto.txt in the zipfile to Pareta.wmv to play the screen recording. This shows how I created the Pareto.dll report. To use this report you must change the Data Source and Dataset so it uses your SQL Server. The query I used for the example is this:
SELECT * FROM 
(VALUES 
('a', 80),
('b',100),
('c',46),
('d',25),
('e',47),
('f',35),
('g',98),
('h',44)
) AS MyTable(category, quantity);

Open in new window


The expression I used in the video is this:
=RunningValue(Fields!quantity.Value, Sum,"DataSet1") / Sum(Fields!quantity.Value,"DataSet1")

Open in new window


If you want to apply this to your own report you need to change 'quantity' to the field name with the values in your dataset. And you need to change 'DataSet1' to the name of your Dataset.

Hope this helps. But please let me know if you have any further questions.
Pareto.zip
0
 

Author Closing Comment

by:SQLSearcher
ID: 40368460
Thank you very much for your help.
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Sum Over Multiple Tables 20 35
SQL parsing XML works but want to do it another way 4 22
Database Owner 3 21
SQL 2012 Instance Problem 3 62
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

726 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