Solved

SSRS Pareto Chart adjust Axis

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

688 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