SSRS- Bar Chart with single bar needs to display Percentage data

Question

Hi All, I have a requirement to show percentages in bar chart on a single bar using SSRS. For example, I want to show a employees by Age in a percentage in an SSRS report.

1.How many % employees between age 20 and 30? 2.How many % employees between age 30 and 40? 3.How many % employees between age 40 and 50?

All this on a chart which has only single bar chart in percentage?

Is it possible?

Thanks

Answer 1

You can easily do it in 2008, but I guess that's not what you wanted to hear.

So basically you want the concept of a pie-chart but as a single bar (known as a linear gauge in 2008)?

I don't think you can. This is about the limit of what you can do http://msdn.microsoft.com/en-us/library/aa964128%28SQL.90%29.aspx

You could always buy dundas http://www.sql-server-performance.com/articles/reporting/Enhancing_Reporting_Services_with_Dundas_Reporting_Controls_p1.aspx

essentially this what MS have rolled into 2008