FIX: Invalid values appear in a chart if you change the default color for the value series in SQL Server 2000 Reporting Services Service Pack 1 (883675)

MORE INFORMATION

Steps to reproduce the behavior

1. Start SQL Query Analyzer.
2. 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 Northwind
   create table Datapoints (Category int, Data int NULL)
   go
   
   insert 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)

3. In Report Designer, use the following information to create a new report:

   Data source
   ------------------
   Name: Northwind
   Type: Microsoft SQL Server
   Connection string: data source=< Instance of SQL Server >;initial catalog=Northwind
   
   Query string
   ------------------
   SELECT Category, Data FROM Datapoints
   
   Report 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.
4. In Layout view, add a chart control. Name the chart control SampleChart.
5. 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.
6. In the Fields pane, click Data, and then drag the Data field to the Drop data fields here section of the SampleChart chart control.
7. Right-click SampleChart, and then click Properties.
8. In the Chart type list in the Chart Properties dialog box, click Line.
9. Click the Data tab.
10. In the Values list, click [Value], and then click Edit.
11. In the Edit Chart Value dialog box, click the Appearance tab.
12. Click Series Style to open the Style Properties dialog box.
13. In the Color box on the Border and Line tab, type Brown, and then click OK.
14. In the Edit Chart Value dialog box, click OK.
15. In the Chart Properties dialog box, click OK.
16. Preview the report.