This article has been archived. It is offered "as is" and will no longer be updated.
When you preview a report that contains a chart in Microsoft SQL Server 2000 Reporting Services Service Pack 1, you notice that invalid data points appear in the chart. For example, the data point with a NULL value is an invalid data point and it must not appear in the chart.
This problem occurs if you explicitly change the default color for the value element or the value series of the chart that contains the data points.
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000 Reporting Services . For more information, click the following article number to view the article in the Microsoft Knowledge Base:
842440 How to obtain the latest service pack for SQL Server 2000 Reporting Services
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Date Time Version Size File name --------------------------------------------------------29-Jul-2004 02:05 8.0.894.0 823,296 Dundaswebchart.dll 29-Jul-2004 02:05 8.0.894.0 815,104 Dundaswinchart.dll 29-Jul-2004 02:04 8.0.894.0 1,327,104 Microsoft.reportingservices.processing.dll
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in Microsoft SQL Server 2000 Reporting Services Service Pack 2 .
Steps to reproduce the behavior
Start SQL Query Analyzer.
To create a table and to insert values in the table, run the following code in the query window.
Note You use these values as the data points for the chart.
use Northwindcreate table Datapoints (Category int, Data int NULL)goinsert into Datapoints Values (1,3)insert into Datapoints Values (2,5)insert into Datapoints Values (3,6)insert into Datapoints Values (4,9)insert into Datapoints Values (5,7)insert into Datapoints Values (6,NULL)insert into Datapoints Values (7,NULL)insert into Datapoints Values (8,NULL)insert into Datapoints Values (9,NULL)insert into Datapoints Values (10,NULL)
In Report Designer, use the following information to create a new report:
Data source------------------Name: NorthwindType: Microsoft SQL ServerConnection string: data source=< Instance of SQL Server >;initial catalog=NorthwindQuery string------------------SELECT Category, Data FROM DatapointsReport name------------------ChartReport
Note When you create the report project, you must provide the appropriate credentials to access the database on your instance of SQL Server.
In Layout view, add a chart control. Name the chart control SampleChart.
In the Fields pane, click Category, and then drag the Category field to the Drop category fields here section of the SampleChart chart control.
Note If the Drop data fields here section is not displayed, double-click the SampleChartchart control. You notice that the Drop data fields here section, the Drop category fields here section, and the Drop series fields here section appear.
In the Fields pane, click Data, and then drag the Data field to the Drop data fields here section of the SampleChart chart control.
Right-click SampleChart, and then click Properties.
In the Chart type list in the Chart Properties dialog box, click Line.
Click the Data tab.
In the Values list, click [Value], and then click Edit.
In the Edit Chart Value dialog box, click the Appearance tab.
Click Series Style to open the Style Properties dialog box.
In the Color box on the Border and Line tab, type Brown, and then click OK.
In the Edit Chart Value dialog box, click OK.
In the Chart Properties dialog box, click OK.
Preview the report.
You notice that the data points that have NULL values appear on the chart.
You can view the correct result if you do not change the color property in step 13.
For more information about the chart enhancements in SQL Server 2000 reporting Services Service Pack 1, see the "Chart Enhancements" section of the following Microsoft Web site: