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

ID: Q116273

The information in this article applies to:

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.

Additional reference words: FoxWin RWriter 2.50 2.50a 2.50b 2.60 2.60a buglist2.50 buglist2.50a buglist2.50b buglist2.60 buglist2.60a KBCategory: kbtool kbprint kbui kbbuglist KBSubcategory: FxtoolRwriter

Last Reviewed: June 27, 1995