BUG: Remove Line When Blank Does Not Work with General Field

• Microsoft FoxPro for Windows, versions 2.5x, 2.6, 2.6a

SYMPTOMS

If the Print When check box is selected in the Report Expression dialog box and the Remove Line When Blank check box is selected in the Print When dialog box, the general field prints several blank lines when the general field is blank.

With character or numeric fields, selecting these check boxes would cause the blank field to be removed.

RESOLUTION

1. Double-click the general field in the report.

2. In the Report Expression dialog box, select the Print When check box.

3. In the Print When dialog box, select the Remove Line When Blank check box.

4. Select the Print Only When Expression Is True check box.

5. In the Expression Builder dialog box, enter the following expression

         !empty(<gen>)
   

   where <gen> is the name of the general field in the database.

6. Choose OK three times to return to the Report Layout window.

7. From the Report menu, choose Page Preview. Note that the empty general field has been removed.

STATUS

Microsoft has confirmed this to be a problem in FoxPro versions 2.5, 2.5a, 2.5b, and 2.6 for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.