A Chart on a report displays the incorrect data in Access 2002 (318096)

SYMPTOMS

When you preview a report that contains a graph object, you might notice that the graph does not match the data that you expect. The graph may also reference data from a previous record in the report.

This behavior occurs only on computers that are running Microsoft Windows 2000 or Microsoft Windows XP.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.

CAUSE

This behavior is caused by a timing problem between Microsoft Access and Microsoft Graph. The data is first transferred from Microsoft Access to Microsoft Graph. Microsoft Graph is responsible for generating the appropriate graph. If Microsoft Graph does not generate and return the graph object while Microsoft Access is formatting the report, the graph object might become disassociated from its recordset. This will cause the graph object to display an unrelated record.

RESOLUTION

To work around this problem, use one of the following methods.

NOTE: These methods may not work in all situations.

Method 1: Requery the Graph Object

Open the report in Design view.
Click the section of the report that contains the graph object, and then click Properties on the View menu.
In the Properties dialog box, click the Events tab.
To the right of the On Format property box, click the Build (...) button, click the Code Builder, and then click OK.
In the On Format event for the section, call the Requery action for the graph object. For example, if your graph object is named objMyGraph, you would type the following statement to requery the object:
```
' Replace objMyGraph with the name of your object.
Me!objMyGraph.Requery 
					
```

Method 2: Use a DoEvents Loop

Create a new module.
Paste or type the following function into the new module:
```
Function TestProc()
    Dim i As Integer
    For i = 1 To 5
        DoEvents
    Next i
End Function
						
```
Because this behavior is related to timing, you may have to increase the number of iterations through the loop. Because the number of iterations to be performed is variable (it is dependent on such things as the complexity of the report, the complexity of the graph, or the number of records), a maximum value is not provided.
Save and then close the module.
Open your report in Design view.
Open the Properties window for the section that contains the graph object, and then select the Events tab.
For the On Format event, call the TestProc procedure that you created in step 2.

MORE INFORMATION

Steps to Reproduce the Behavior

Start Microsoft Access, and then create a new database.

Create the following table:

   Table: Sheet1
   ----------------------------
   Field Name: ID
   Data Type: AutoNumber

   Field Name: Field1
   Data Type: Text
   Field Size: 255

   Field Name: Field2
   Data Type: Number
   Field Size: Double

   Field Name: Field3
   Data Type: Number
   Field Size: Double

Populate Sheet1 with the following sample data:

ID Field1 Field2 Field3
1 a 1 2
2 b 2 3
3 c 3 4
4 d 4 5
5 e 5 6
6 f 6 7
7 g 7 8
8 h 8 9
9 i 9 10
10 j 10 11
11 k 11 12
12 l 12 13
13 m 13 14
14 n 14 15
15 o 15 16
16 p 16 17
17 q 17 18
18 r 18 19
19 s 19 20
20 t 20 21
21 u 21 22
22 v 22 23
23 w 23 24
24 x 24 25
25 y 25 26
26 z 26 27

Create the following query:

   Query: qryTest
   ------------------
   Type: Select Query

   Field: Field1
   Field: Field2
   Field: Field3

In Design View, create a new report that is based on the qryTest query.
Add Field2 and Field3 to the detail section of the report.
On the Insert menu, click Chart, and then click anywhere in the detail section of the report. This starts the Chart Wizard. To add the data to the chart by using the Chart Wizard, follow these steps:
1. Under View, click Queries.
2. Click qryTest, and then click Next.
3. In page 2 of the Chart Wizard, move Field2 and Field3 from the Available Fields box to the Fields for Chart box, and then click Next.
4. In page 3 of the Chart Wizard, click Column Chart, and then click Next.
5. Select Column Chart and click Next.
6. Add Field3 to the Data node.
7. Remove items from the Axis and Series nodes, and then click Next.
8. Select Field2 for the Report Fields and Chart Fields lists.
  
  NOTE: Click OK to the warning and set the fields as directed.
9. Click Next, and then click Finish.
Save and then close the report.

When the report is opened, it will display Field2, Field3, and the chart object. The chart should match the value of Field3. This is not true in all cases, because some charts will display the wrong record.

REFERENCES

Microsoft Access 2002 includes a new charting feature known as the PivotChart view. Microsoft PivotChart technology is more flexible than the technology in Microsoft Graph. Therefore, PivotChart views do not exhibit the same behavior that is discussed in the "Symptoms" section of this article.

For additional information about the new features in Microsoft Access 2002, click the article number below to view the article in the Microsoft Knowledge Base:

295358 ACC2002: What's New and What Are the Enhancements in Access 2002