Solved

SSRS Pareto Chart adjust Axis

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

910 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

21 Experts available now in Live!

Get 1:1 Help Now