BUG: The text specified by using the HEADING clause of the REPORT FORM command is printed over the column headings in Visual FoxPro (114865)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
- Microsoft Visual FoxPro for Windows 5.0
- Microsoft Visual FoxPro for Windows 5.0a
- Microsoft Visual FoxPro for Windows 6.0
- Microsoft Visual FoxPro for Windows 7.0
- Microsoft Visual FoxPro 8.0
- Microsoft Visual FoxPro 9.0 Professional Edition
This article was previously published under Q114865 SYMPTOMS
The text specified with the HEADING <expC> clause on the REPORT FORM
command does not align properly with the Page Header or Title band of a
quick report. The HEADING text is printed or displayed in page preview, but
it will be printed over the column headings.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. WORKAROUND
The misalignment occurs only when a quick report is printed with the
HEADING clause.
FoxPro 2.x
Use the following workaround if you are seeing this behavior while using
the RQBE tool:
- Using the MODIFY command, open the report created by the query.
- From the Report menu, choose Data Grouping.
- Choose Add, and then type _PAGENO in the Group box. Choose OK twice.
- Move all the fields and text from the Page Header band to the Group
Header band.
- Save the report.
- Using the MODIFY command, open the query.
- Choose Options, select Report, clear the Overwrite File checkbox, and
choose OK.
- Using the DO command, execute the query.
Steps to Reproduce Problem
To reproduce this problem, issue the following code in the Command window:
CREATE REPORT test.frx FROM C:\FoxProW\Tutorial\Salesman ;
WIDTH 637 COLUMN
USE C:\FoxProW\Tutorial\Salesman
REPORT FORM test.frx HEADING "This is a test" PREVIEW
NOTE: This example assumes that the SALESMAN database resides in the
FOXPROW\TUTORIAL subdirectory on drive C. If this subdirectory does not
exists on your C drive, change the pathname and use any database in your
FoxPro directory.
To reproduce this problem in Visual FoxPro 6.0 and later, issue the following code in the Command window:
CREATE REPORT test.frx FROM HOME(2)+"data\customer" ;
WIDTH 637 COLUMN
USE HOME(2)+"data\customer"
REPORT FORM test.frx HEADING "This is a test" PREVIEW
| Modification Type: | Major | Last Reviewed: | 2/17/2005 |
|---|
| Keywords: | kbBug KB114865 |
|---|
|