We are facing an issue with SSRS 2008 charts. We have a report which shows dynamic number of series on a line chart. The data values may not exist for all series for the same x axis points. We expected SSRS to connect the missing points as average and have set the empty point option to average. The issue is that the 1) lines for interpolated points only appear when we set the color of empty point to say red and not when it is set to automatic. We need the interpolated line in the same auto colour as the original line as we will have markers for the data points from the DB and no markers for empty points. 2) The interpolated lines extend backwards in the series also – we expect it to only fill the gaps and not extend backward or forward. Are these issues known and is there a work around for these issues ? We got your name from one of the SSRS community discussions. Could you please connect us with the right person if you are not the right contact for this issue ? I also got following reply from one of the MS guy, it says Hi Akshay, The lines should not go backward. I have seen this happen before and I’ll have to double-check on what that occurs. If you are using a Category Axis, make sure you set the sorting to use a Cdate() expression. I think that might be it ,but I’ll have to double check. As far as using the auto-coloring on the series when you have empty points like this, I don’t think that’s possible. It would require a DCR. You may need to implement something along the lines described in this article http://msdn.microsoft.com/en-us/library/aa964128(SQL.90).aspx. When I tried the suggestions I over come the auto colouring issue and also used CDATE () but lines still extend bacawords. Can anyone suggest what to do it this situation ?

Hi AKshay_Jadhav, Firstly, I am not sure who is that MS guy you mentioned without the detail name. Based on my understanding to your issue, I think you could utilize the function IsNothing in reoprting services to have a check whether the value is null, if it is Null, you should give a average value to this point, if not leave it to be the original value. Of course, you could achieve this in T-SQL. To the color and marker, we could type in the expression in both feature to control their display effort. Hope this helps. Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

His name is Sean Boon My main problem in chart is extending backwards. If SSRS can handle it without modifying the SP then it will be less complex.

Hi, I believe the issue with the line extending backwards is that the chart doesn't have the sort property set on the Category Group. To do this, select, the Category Group, and open the property page. There should be a tab there for sorting. Make sure the sort property is set. This should correct the issue. If it doesn't, we'll need to get a copy of the RDL. -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

For color line on empty points, you can add an expression to force the color in function of the serie type (Series properties pane / empty point / color) For example : =iif(Fields!ows_theorique.Value="Réel", "LightSkyBlue", "Orange") Where "Fields!ows_theorique.Value" is your discreminant color key in series Look at this example on step 5 : http://www.mssqltips.com/sqlservertip/2373/how-to-handle-empty-values-in-a-line-chart-in-ssrs/Not the ultime solution but a good bypass.