W
WorldCTZen
I'm having trouble with the Detail of a Report stretching beyond its
contents. The Detail has several columnar subreports, each which rolls for
the same height. For some of the records in the main report, one of the
subreports needs hidden (visible = false) and a label shown stating why the
subreport was hidden.
The issue is that this label needs to have its .height property set for each
record in the main report. When the label's height is increased, the entire
Detail will stretch further than required.
For instance, the label is normally 720pts tall while hidden. If I set its
..height property to say 1440 (using VBA in Detail.OnFormat event) the Detail
will stretch out another inch or more. In cases where the subreports stretch
the detail across pages, the extra Detail stretching can be as much as
another page.
The behavior seems to be that if the label's height is increased, the Detail
is being pushed down by the subreport and/or any white space below the Label..
Additionally, the .AutoHeight property for the detail doesn't appear to do
anything, as nothing seems to change based on its setting.
Why am I getting extra white space in the detail??
contents. The Detail has several columnar subreports, each which rolls for
the same height. For some of the records in the main report, one of the
subreports needs hidden (visible = false) and a label shown stating why the
subreport was hidden.
The issue is that this label needs to have its .height property set for each
record in the main report. When the label's height is increased, the entire
Detail will stretch further than required.
For instance, the label is normally 720pts tall while hidden. If I set its
..height property to say 1440 (using VBA in Detail.OnFormat event) the Detail
will stretch out another inch or more. In cases where the subreports stretch
the detail across pages, the extra Detail stretching can be as much as
another page.
The behavior seems to be that if the label's height is increased, the Detail
is being pushed down by the subreport and/or any white space below the Label..
Additionally, the .AutoHeight property for the detail doesn't appear to do
anything, as nothing seems to change based on its setting.
Why am I getting extra white space in the detail??