I had a SSRS report in 2005, the report worked perfectly fine and it clearly showed all the lines in line graph, however now converting the report from 2005 to 2008, the report doesn't show up all the lines or shows broken lines? Any clue why?creativity..

This is due to the fact that we changed how we handle empty points in SSRS 2008. In SSRS 2005 we automatically drew lines through empty points that didn't exist in the dataset. In 2008, we require you to set the empty point properties to get this behavior. To fix this, open the property grid and check under the Data node you should see a section for formatting Empty Points, where you can set the function that will be used for the empty points as well as the formatting properties. Note that in order to take advantage of this feature you will need to return records that represent these points, but with a NULL value. -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

I have the same issue, but what I don't get is how to implement this feature correctly. The only thing I have to do in Excel is to click on "Connect data points with line" radio button to achieve this. In SSRS the missing point won't show unless I specify a colour, but that means that they're shown with the same color/style. Also the "Average" function for the value only shows a constant value and not the interpolation between two points. I'm trying to merge intra-day and historical data in the same graph, avoiding weekend values (so the x-axis has to be "category", not "scalar") and obviously intra-day data are all missing on historical series and vice-versa. In SSRS 2005 this was really simple to achieve, I just wonder how can I get this with the new version of SSRS 2008 R2. Thanks, S.