How to shift a subreport depending on height of memo above it?
I have a report with a couple of subreports.
In a group header is a memo that can stretch downwards if there is a lot of text.
Below the memo is a little white space and then - in the same band - is a subreport.
The subreport is in the same band as its linked to the field used for the group condition. ie it shows data related to the group condition
The trouble is that if the memo contains a lot of text it stretches downwards and sometimes will overlap the subreport.
How can I make the subreport shift downwards to maintain the whitespace and not be overlapped even if the memo stretches?
(I've tried playing with child bands but am not really sure what I'm doing and couldn't get it to work correctly.)
Attached picture shows my design.
The band 'GroupHeaderJudgementArea' is the one causing a problem (indicated by the thick blue line). It has 'stretched = true
The memo that can stretch (highlighed in yellow) has stretchmode = smactualheight.
The subreport that gets overlapped has the red dot in it.
hsm
In a group header is a memo that can stretch downwards if there is a lot of text.
Below the memo is a little white space and then - in the same band - is a subreport.
The subreport is in the same band as its linked to the field used for the group condition. ie it shows data related to the group condition
The trouble is that if the memo contains a lot of text it stretches downwards and sometimes will overlap the subreport.
How can I make the subreport shift downwards to maintain the whitespace and not be overlapped even if the memo stretches?
(I've tried playing with child bands but am not really sure what I'm doing and couldn't get it to work correctly.)
Attached picture shows my design.
The band 'GroupHeaderJudgementArea' is the one causing a problem (indicated by the thick blue line). It has 'stretched = true
The memo that can stretch (highlighed in yellow) has stretchmode = smactualheight.
The subreport that gets overlapped has the red dot in it.
hsm
Comments
Thank you Mick.
Unfortunately that didn't work (the memo was printed after the subreport instead of before)
However, adapting your idea I put the subreport in the child band instead together with the white space gap around it and reduced the size of the group header so the memo reached the bottom of the band. I then set the child property of the group header to point to the child band.
Now it works OK with the memo stretching if necessary but still maintaining the desired white space before the subreport.
Odd, as I'm sure that was one of the combinations I tried when playing around with child bands before, using examples in the user guide.
Never mind.
Attached is the corrected design in case it helps anyone else reading this.
hsm