Static main report, dynamic subreport

rbuser

Hi,

When I create a main report that has a detail band with printheight of
phStatic and put a subreport within that with a printheight of
phDynamic, the subreport stays the size it was at design time no matter
how many records are in it.

For example, create a report. Set the detail band height to static. Put
a couple of fields on the detail band and a subreport off to one side.
Make the subreport's detail band's height dynamic and make sure that the
data is such that several records should be in the subreport. Size the
subreport on the main report so that it's only high enough to display
one record. When you preview the report only the first record in the
subreport displays. If you resize the subreport, more records (up to the
height of the subreport) will be displayed.

Surely if there's plenty of room on the main report, even if that report
height is static, a dynamic subreport should be allowed to expand as far
as it needs to? Is there a setting I'm missing?
We're using report builder for payslips and have a main report with
three subreports. The left hand side is additions and could be made
bigger and static, but the right hand side contains one subreport above
another and so we can't make them static as the number of records within
them could vary, and we don't want a space between them.

Any help is appreciated,

Thanks,

Steve Branley

nicocizik

Hi Stephen,

The child subreport is designed to be used inside a dynamic height band.
Try using a fixed style subreport instead, sized to the height of the static
detail band. The subreport itself will still grow dynamically, it will
simply stop once it runs out of space.



Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com