The fields of the current table do not appear in the Report Expression Builder dialog box in Visual FoxPro 8.0 and earlier versions (225743)

The information in this article applies to:

Microsoft Visual FoxPro for Windows 3.0
Microsoft Visual FoxPro for Windows 3.0b
Microsoft Visual FoxPro for Windows 5.0
Microsoft Visual FoxPro for Windows 5.0a
Microsoft Visual FoxPro for Windows 6.0
Microsoft Visual FoxPro for Windows 7.0
Microsoft Visual FoxPro 8.0

This article was previously published under Q225743

SYMPTOMS

In Microsoft Visual FoxPro 8.0 and earlier versions, if a table is open in the current work area and it is not in the DataEnvironment of the report, the Report Expression Builder dialog box for the report fields does not display fields from that table.

CAUSE

Because FoxPro 2.x reports did not have a DataEnvironment, the fields from an open table were available from within the Report Writer Expression Builder.

With the introduction of the Report DataEnvironment in Visual FoxPro version 3.0, the behavior was changed. All versions of Visual FoxPro from 3.0 to 8.0 exhibit this behavior. However, Visual FoxPro 9.0 does not exhibit this behavior because the Report Designer has been redesigned.

RESOLUTION

You can use one of the following workarounds:

Create a Quick Report to get a list of fields in the currently open table that can then be added to the report.
Add the table to the DataEnvironment of the Report.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to reproduce the behavior

Open a table.
Create a new report using the Report Designer.
Add a field to the report.
When the Report Expression dialog box appears, click the ellipses button to the right of the Expression box. This should open the Report Expression Builder dialog.
Observe that fields from the open table are not listed in the Fields column.

Modification Type:	Major	Last Reviewed:	2/16/2005
Keywords:	kbDesigner kbprb kbReportWriter KB225743