Solved

How to create a Pareto Chart with SQL Reporting Services?

Posted on 2007-03-22
7
2,073 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
[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
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

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…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 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