BUG: Format Clause in Report Causes Erroneous Characters

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

SYMPTOMS

In the Report Writer, if a field has a format clause and an IIF(,,) statement in it, erroneous characters will appear if the field is blank.

RESOLUTION

If you remove the format clause ("XXXXXXXXXX" in the example below), the problem will no longer occur.

STATUS

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

MORE INFORMATION

Steps to Reproduce the Problem

1. In the Command window, type the following commands:

   CLOSE ALL USE customer.dbf COPY TO test.dbf CLOSE ALL USE test.dbf REPLACE ALL company WITH ' ' FOR state = 'MA' GO TOP CREATE REPORT test.frx

2. In the Report Writer, choose the Field button, place a field in the Detail band, choose the Expression button, and then type the following expression in the Expression For Field On Report box:

   IIF(company = ' ','BLANK',company)

3. Choose Verify to make sure the expression is valid, and then choose OK.

4. In the Format box, type the following, and then choose OK.

   XXXXXXXXXX

5. From the Report menu, choose Page Preview. Choose the Zoom In button.