I am using SSRS 2008 and developing my reports in BIDS. I have a report with two data points. I want to chart the first as a bar (horizontal) chart and then the second as an overlaying line chart. I created both data series, originally, as a bar chart. I have clicked on the second series in the "Drop Data Fields Here" area and changed the chart to a line chart. When I do that, it changes both series to a line chart. However, if I use the column (vertical) chart for the first series, it will let me make the second one a line chart. Is this a limitation of SSRS 2008? Can I not have one data point be the horizontal bar chart and the second one a line chart? If so, are there any suggestions how to get around this? Thanks.

SSRS 2008 does not support combining a horizontal bar series with a line series in a single chart area.-SeanProgram Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs

Both charts for SSRS 2005/2008 are very limited when it comes to horizontal charts and are infact supporting only left-to-right bar charts, with no ability to combine them with other charting types (lines,areas, points etc.). For a SSRS charting solution that supports all types of charting type combinations in left-to-right and right-to-left horizontal fashion you can use Nevron Chart for SSRS - www.nevron.com. Besides a huge number of charting types and subtypes (most of which are not available in the MS Chart for SSRS 2008) it also provides better image quality in 2D and 3D modes, more settings, has support for rich text formatting in texts, has image filters, ability to customize via C# code and implements many more large and small charting related details. Best regards, Crank

You can do it. Fistly you define two data fields. When you click one of the data field , you see the small white circles top of the bars on the chart area.Then right click one of these circles and "Change Chart Type" to line ..Then one of the data field show as line, other one remains as bar.