Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Q: "Cannot generate report. Band height cannot exceed page height"

edited October 2002 in General
We have a report with several sub-report and one of them has a lot of
records, more then 1700. The thing is that after 46 pages are printed we do
get the error "Cannot generate report. Band height cannot exceed page
height" and the printout is stopped before all pages are printed.

The subreport has KeepTogether = false, PrintBehavior = pbChild. The
subreport itself contains four groups with KeepTogether = true but two of
them have PrintHeight = true and the other two have PrintHeight = false. The
detail band has BandsPerRecord = 1 and the detail band also has a simple
subreport which can be in height.

Is there anything I can do in order to get this report to work and to print
all records.

TIA,
Fred

Comments

  • edited October 2002
    Only the innermost keep together group in a report will actually try to keep
    together.

    What version of RB are you using for this report? Have you tried using RB 7
    if you have an older version of RB?

    If the problem persists in RB 7, then can you send an example report which
    shows the problem to support@digital-metaphors.com

    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited October 2002
    I am using version 5.51 (?) I think, with Delphi 5 Ent.

    TRhe thing is I can't use RB 7 since this is a decision to be made for the
    whole IT-department and things are going pretty good with the environment so
    I don't think it's possible to upgrade soon. :-(

    I just want to add that the error is not occuring when printing to PDF-file
    (via TExtraDevices) or when previewing the report just when printing to a
    printer.

    /Fred

  • edited October 2002
    Perhaps what is happening is the cached pages are being sent to the printer
    when they should be regenerated if you are using a different printer than
    the default printer. Try forcing the report to regenerate. Call Report.Reset
    before printing to the printer to clear the page cache and force it to
    recreate the report for the printer. Check to see if Report.PrinterDevice
    is non nil to determine if you are printing to the printer at runtime.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.