?
Solved

SSRS Pareto Chart adjust Axis

Posted on 2014-10-04
4
Medium Priority
?
791 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 2000 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

777 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