There are lots of Reporting types which are missing in SQL reporting Services. Now this is possible using third party tool with SQL reporting Services named Dundas Charts for Reporting Services supported in SQL Server Reporting Services. There are four reporting controls available.
1. Dundas Chart for Reporting Services
2. Dundas Gauge for Reporting Services
3. Dundas Calendar for Reporting Services
4. Dundas Map for Reporting Services.
Dundas control feature includes are
- Pareto Chart
- Polar Chart
- 3D Chart
- Bar Chart
- Pie Chart
- Area Chart
- Pyramid Chart
- Step Line Chart
- Gantt Chart
- Box Plot Chart
- Gauges
- Calendars in Reports
- Maps in Reports
- Funnels
- Scatter Chart

Links:
Dashboard Web Chart Control
See live Dundas Reporting Sample