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)



The information in this article applies to:

  • Microsoft SQL Server 2000 Reporting Services, Service Pack 1 (SP1)

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

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


Modification Type:MajorLast Reviewed:4/22/2005
Keywords:kbSQLServ2000ReportServSp2fix kbQFE kbfix kbbug KB883675 kbAudDeveloper kbAudITPRO