Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

mulriple subreports not aligning to top of page

Status
Not open for further replies.

Decana

Technical User
Jan 25, 2003
1
ZA
Hi :)
I have a report which contain multiple subreports, the subreports are only printed if they contain data, so in some instances only 2 of the possible 27 reports are printed.
Now the problem I have is that the subreports are divided by pagebreaks , but eventhough the page breaks are there, they will not align to the top of the page, unless the previous subreport prints, if it doesn't, they all move down if you know what I mean lol.
I have tried a pagebreak infornt of the subreport and behind, but I run into even more issues thatn just having it after the subreport, below is a peice of code that is repeated for each subreport,

Me!ConcilliationSTReport.Visible = Me!ConcilliationSTReport.Report.HasData

If Me!ConcilliationSTReport.Report.HasData = False Then
PageBreak28.Visible = False
End If

any ideas on how to get this sorted would be wonderful, I just cannot work out how to tell the report that the next subreport that does have data must move to just after the last pagebreak. Am I being more confusing? If anyone wants to help with this and I am not being clear enough, just shout I will be only to happy to post and epistle on it lol ;-)
Many thanks
Decana
 
Try this. Change the height property of all of the subreports to 0 and modify the Can Grow property to True.

This will prevent the extra space from being used if there are no records for the subreport but allows for the subreport to grow to whatever size if there are records.

You will have to play with the placement of the subreports as they should all look like thin lines. I have used this technique before with success. Bob Scriver
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top