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
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