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
Solved

SSRS Pareto Chart adjust Axis

Posted on 2014-10-04
4
744 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
  • 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

839 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