Article ID: 114865
Article Last Modified on 2/12/2007
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 5.0a
- Microsoft Visual FoxPro 6.0 Professional Edition
- Microsoft Visual FoxPro 7.0 Professional Edition
- Microsoft Visual FoxPro 8.0 Professional Edition
- 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.
STATUS
Microsoft 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
Additional query words: RQBE crosstab kbFP250 kbFP260 kbvfp300 kbvfp500 kbvfp600
Keywords: kbbug KB114865