FIX: @R Displays Incorrect Format in Report Writer

WINDOWS   | MS-DOS    | MACINTOSH  | UNIX

The information in this article applies to:

• Microsoft FoxPro for Windows, versions 2.5x, 2.6x
• Microsoft FoxPro for MS-DOS, versions 2.5x, 2.6x
• Microsoft FoxPro for Macintosh, versions 2.5x, 2.6a
• Microsoft FoxPro for UNIX, version 2.6

SYMPTOMS

In the Report Writer, if the R character formatting check box is selected for an expression, the expression does not display correctly in Page Preview if the number of characters in the expression do not equal the number of place holders (the character 9) defined in the Format text box.

NOTE: The R character formatting check box places @R in the format string.

WORKAROUND

Define the expression to have the same number of characters as the format defined with the '@R' (without the quotation marks).

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Visual FoxPro 3.0 for Windows.

NOTE: In Visual FoxPro for Windows, select the "Ignore Input Mask" check box in the Format (Field) Dialog Box to prevent this problem from occuring.

MORE INFORMATION

Steps to Reproduce Behavior

1. In the Command window, type the following:

         myvariable = "1234"
         USE SYS(2004)+"\Tutorial\Customer"
   

2. Start the Report Writer and define a an expression called "myvariable" (without the quotation marks) in the Detail band.

3. Choose the Format button.

4. In the Format dialog box, type "9,999,999,999" (without the quotation marks).

5. Under Editing Options, select the R check box.

6. Choose OK twice to return to the Report Design window.

7. From the Report menu, choose Page Preview.