Interpolating a line for missing data points in line / bar graph

I know I'm not the only one with this problem. I have a set of data values I want to display as lines from left to right, grouped by month, and a series is specified. There is no aggregation as the series/month combination is unique. However, sometimes there is no data for a given series and month. When this happens, my line breaks at the previous month and starts again on the next month. I tried using a column chart and specifying plot data as line, but I still get the same result. Is there a way to get SQL Server Reporting Services 2000 to connect the dots with the existing data or do I have to alter my stored procedure and create an interpolation scheme for missing months?

If not, will this be addressed in 2005?

Thanks in advance

Please make sure you have RS 2000 SP2 installed (on the report server and the report designer machines).

On SQL Server 2005 it will work just fine.

-- Robert

|||

I have the opposite problem. I'm using SQL Server 2005. I have data to graph by month, but when I have no data for a given month, I'd like like to see the gap in the line. If I leave out the row, the graph just leaves the month out. If I make the data value null, it puts the month in, leaves the marker off, but still draws a line from the previous to the next month. Is there a trick to make the line break?

|||I have the same problem - I am plotting a financial instrument and want to overlay the plot with buy/sell activity. Thus I buy at, say 09:00 and sell at 09:30 before buying again at 10:00. The Chart plots a line between the end of the buy line at 09:30 and the next buy at 10:00. This is despite the result set having a a null value between these two times.
Has anyone an answer to this problem?