Solved

How to create a Pareto Chart with SQL Reporting Services?

Posted on 2007-03-22
7
2,001 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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

707 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

12 Experts available now in Live!

Get 1:1 Help Now