Solved

How to create a Pareto Chart with SQL Reporting Services?

Posted on 2007-03-22
7
2,014 Views
Last Modified: 2008-01-09
How can I create a stacked bar - Pareto Chart with Microsoft Reportint Services 2005?
0
Comment
Question by:Nobletucky2004
  • 4
  • 3
7 Comments
 
LVL 18

Expert Comment

by:chrismc
ID: 18776173
In the chart control, right click for properties. There is a chart type property. What's in that, are your only options.

If you need more, google for the Dundas Reporting Services Chart controls. It's not cheap though!

Cheers
Chris
0
 
LVL 18

Expert Comment

by:chrismc
ID: 18776181
FYI There is a Database Reporting topic under MS SQL 2005 which is more relevant for RS questions.

Cheers
Chris
0
 

Author Comment

by:Nobletucky2004
ID: 18776185
We actually have Dundas...unforunateley Dundas doesn't support stacked bar - Pareto, already contacted their tech support.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 18

Expert Comment

by:chrismc
ID: 18776323
Bummer!

As an aside, how have you found the full Dundas control? Is it much better than what ships with RS (which I know is Dundas as well).

Cheers
Chris
0
 

Author Comment

by:Nobletucky2004
ID: 18776523
To tell you the truth, I would do it a dis-service in critique, I rarely if ever use it.  A colleague of mine deals with report development, I'm more back-end, I was only stepping in to see if there was a code based solution I could offer.  I will ask him though and post his response to get you some accurate feedback.
0
 

Author Comment

by:Nobletucky2004
ID: 18777454
Hey Chris,
  I was actually able to create a Pareto with Reporting Services 2005 using the RunningValues() function and an empty Series Group, unfortunately I'm still unable to create this same chart with a stacked bar as it is creating 3 pareto lines as I expected it would since a stacked bar requires two Series groups.  If you have any ideas please let me know.  
Ryan
0
 
LVL 18

Accepted Solution

by:
chrismc earned 500 total points
ID: 18778362
Hi Ryan, the chart control is quite weak and there really is nothing you can do about it.
I was hoping that the full Dundas control was going to be much better.

I'll keep my eyes peeled if there any other 3rd party add-ons.

Cheers
Chris
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 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