Q: "Cannot generate report. Band height cannot exceed page height"
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
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
This discussion has been closed.
Comments
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
http://www.digital-metaphors.com
info@digital-metaphors.com
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
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
http://www.digital-metaphors.com
info@digital-metaphors.com