Solved

How to create a Pareto Chart with SQL Reporting Services?

Posted on 2007-03-22
7
2,041 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Get row count of current SQL query 8 59
Query Builder end user tool for SQL Server 1 89
Insert from Stored Procedure where some field/s > 0 7 45
CROSS APPLY 4 56
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

860 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