Solved

How to create a Pareto Chart with SQL Reporting Services?

Posted on 2007-03-22
7
2,033 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to check data in sql table 11 47
MS SQL page split per second is high 19 97
SQL Server 2012 express 24 38
Move SQL 2005 Express to Server 2012R2 19 126
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

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