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.
RESOLUTION
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 "Applies to" section.
This problem was first corrected in Microsoft SQL Server 2000 Reporting Services Service Pack 2 .
MORE INFORMATION
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
- 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.
REFERENCES
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:
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
Additional query words: SRS SP1 rosetta
Keywords: kbbug kbfix kbqfe kbsqlserv2000reportservsp2fix KB883675