Microsoft KB Archive/883675

= 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 =

Article ID: 883675

Article Last Modified on 4/22/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Reporting Services Service Pack 1

-





SYMPTOMS
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

Hotfix information
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



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; 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 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)  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. 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.</li> In the Fields pane, click Data, and then drag the Data field to the Drop data fields here section of the SampleChart chart control.</li> Right-click SampleChart, and then click Properties.</li> In the Chart type list in the Chart Properties dialog box, click Line.</li> Click the Data tab.</li> In the Values list, click [Value], and then click Edit.</li> In the Edit Chart Value dialog box, click the Appearance tab.</li> Click Series Style to open the Style Properties dialog box.</li> In the Color box on the Border and Line tab, type Brown, and then click OK.</li> In the Edit Chart Value dialog box, click OK.</li> In the Chart Properties dialog box, click OK.</li> Preview the report.</li></ol>

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.

<div class="references_section">