Knowledge Base

BUG: Field aliases options in Expression Builder dialog box are disabled

Article ID: 174404

Article Last Modified on 2/11/2005

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 Q174404

SYMPTOMS

In the Report Writer, all the options in the Field Aliases section of the Expression Builder Options dialog box are disabled. Therefore, the Report Writer always adds alias names to the report field objects. This is not a problem in the Visual FoxPro 3.0x.

RESOLUTION

There are two workarounds for this problem. First, issue a CREATE REPORT command and select Quick Report from the Report menu bar. In the Quick Report dialog box, clear the Add Alias option. Second, use the Report Wizard to create the report. The Report Wizard does not place alias names on the field objects.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

Type the following in the Command window:
```
      CREATE REPORT Zjunk
```
Add a field from the Report Controls toolbar to the Report.
In the Report Expression dialog box, click Expression.
In the Expression Builder, click Options.
All the options within the Field Aliases section of the Expression Builder Options dialog box are disabled.

Additional query words: Report writer

Keywords: kbnofix kbprb KB174404