Microsoft KB Archive/225743

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

Article ID: 225743

Article Last Modified on 2/12/2007

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft Visual FoxPro 7.0 Professional Edition
 * Microsoft Visual FoxPro 8.0 Professional Edition

-



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.



Steps to reproduce the behavior

 * 1) Open a table.
 * 2) Create a new report using the Report Designer.
 * 3) Add a field to the report.
 * 4) 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.
 * 5) Observe that fields from the open table are not listed in the Fields column.

Keywords: kbdesigner kbprb kbreportwriter KB225743

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.