FIX: @R Displays Incorrect Format in Report Writer

ID: Q125047

2.5x 2.6x | 2.5x 2.6x | 2.5x 2.60a | 2.60

WINDOWS   | MS-DOS    | MACINTOSH  | UNIX

kbtool kbprint kbprg kbfixlist kbbuglist

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.

Note that the format displays a portion of the string and other random characters.

Additional reference words: RWriter VFoxWin FoxWin FoxDos FoxMac FoxUnix 2.50 2.50a 2.50b 2.50c 2.60 2.60a fixlist3.00 buglist2.50 buglist2.50a buglist2.50b buglist2.50c buglist2.60 buglist2.60a KBCategory: kbtool kbprint kbprg kbfixlist kbbuglist KBSubcategory: FxtoolRwriter

Keywords          : FxtoolRwriter kbbuglist kbfixlist
Version           : 2.5x 2.6x | 2.5x 2.6x | 2.5x 2.6
Platform          : MACINTOSH MS-DOS UNIX WINDOWS
Solution Type     : kbfix

Last Reviewed: September 24, 1997