FIX: Error message "Summary band is too large to fit on page" (265880)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 5.0
  • Microsoft Visual FoxPro for Windows 5.0a
  • Microsoft Visual FoxPro for Windows 6.0
This article was previously published under Q265880

SYMPTOMS

When you preview or print a report that is created by using the Visual FoxPro Report Designer, you may receive the following error message:
Summary band is too large to fit on page.

RESOLUTION

To resolve this problem, obtain Visual FoxPro 7.0.

A supported fix that corrects this problem for Visual FoxPro 6.0 is also available from Microsoft, but it has not been fully regression tested and should be applied only to systems experiencing this specific problem.

To obtain this fix, contact Microsoft Product Support Services and refer to Q265880.

For a complete list of Microsoft Product Support Services phone numbers and information on support costs, see the following address on the World Wide Web:

http://support.microsoft.com/contactus/?ws=support

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

This problem was corrected in Visual FoxPro 7.0.

MORE INFORMATION

This error message occurs when you choose to print the summary band on a new page and the page header band height plus the summary band height is greater than the page height. When you choose to print the summary on a new page, you expect the allowable summary band height to be less than or equal to the page height.

Steps to Reproduce Behavior

  1. Open Visual FoxPro and type the following in the Command window: For Visual FoxPro 5x:

    OPEN DATABASE HOME()+"data\testdata"
    USE CUSTOMER

    For Visual FoxPro 6.0:

    OPEN DATABASE HOME(2)+"data\testdata"
    USE CUSTOMER

  2. Create new report.
  3. On the Report menu, click to select Quick Report, accept the defaults, and then click OK.
  4. On the Report menu, click to select Title/Summary.
  5. Select both the Summary band and New page options, and then click OK to close the dialog box.
  6. Drag the page header to 4 inches.
  7. Drag the summary band to 7 inches or greater.
  8. Right-click the report and choose Preview. Note that the error message occurs regardless of the setting of the New page check box in the report Title/Summary dialog box. The sum of the header band plus the summary band must be less than 11 inches. When you select New page in the Title/Summary dialog box, you expect the header and summary to act independently.

REFERENCES

(c) Microsoft Corporation 2000, All Rights Reserved. Contributions by Kenneth Robison, Microsoft Corporation.

Modification Type:MajorLast Reviewed:1/20/2006
Keywords:kbbug kbfix kbReportWriter KB265880
©2004 Microsoft Corporation. All rights reserved.