FIX: Print Range Incorrect with Stretched Group Footer field

WINDOWS   | MACINTOSH

The information in this article applies to:

• Microsoft FoxPro for Windows, versions 2.5x, 2.6
• Microsoft FoxPro for Macintosh, versions 2.5x

SYMPTOMS

Trying to print a subset of pages from a report by selecting Pages under Print Range in the Print dialog box gives incorrect results if there is a field in a Group Footer band that is set to stretch.

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 Microsoft FoxPro version 2.6a for Windows and Microsoft FoxPro version 2.6a for Macintosh.

MORE INFORMATION

Steps to Reproduce Problem

1. Put the following code into a .PRG file and run it to create a sample table:

        CREATE TABLE test ( descript C (20), notes m)
        FOR i = 1 TO 20
             APPEND BLANK
             m.notes = REPLICATE('X',i*100)
             m.descript = "Record " + STR(i)
             GATHER MEMVAR MEMO
        NEXT
   
   

2. Create a new report.

3. From the Report menu, choose Data Grouping. In the Data Grouping dialog box, choose the Add button. In the Group Info dialog box, type "RECNO()" (without the quotation marks) in the Group box. Choose OK twice.

4. Create a field in the Group Footer band. In the Report Expression dialog box, type "test.notes" (without the quotation marks) in the Expression box. Under Position Relative To, select the Top--Field Can Stretch radio button. Choose OK. Size the field so that it spans the entire width of the page.

5. Create a field in the Detail band and type "test.descript" (without the quotation marks) in the Expression box.

6. Save the report as TEST_PRT.FRX. Save the environment when prompted.

7. In the Command window, type the following command, and then press ENTER:

         REPORT FORM <full path>\TEST_PRT.FRX TO PRINTER PROMPT
   

   When the Print dialog box appears, choose OK. All the pages in report will be printed.

8. Issue the above REPORT FORM command again, but this time when the Print dialog box appears, select the Pages radio button and type 3 in the From box and 5 in the To box. Choose OK.

9. Compare pages 3 through 5 from the first and second reports. Although they should be identical, they will be different.