printing a subreport that has no records

[kaosyeti]

hey.. i have a report that is basically 14 different subreports, all in their
own group header or footer. each header/footer is forcing a new page (after).
each subreport has its own header, footer and detail section. when there are
no records for one of the subreports, the corresponding page will be
completely blank. what i'd like is for the subreport to still display/print
the header and footer, despite the detail section being empty. is this
possible? thanks.

 

[SA]

Greg:

To accomplish this you need to create a "pseudo" subreport for each true
sub, with the pseudo report not bound to a query, but just containing the
text you want displayed. You can put the pseudo report on top of the true
sub and set its visible property to false. Then in the group header or
footer where the sub would normally be displayed, add code like this:

If Me!YourTrueSubreport.Report.HasData = False Then
Me!YourPseudoSub.Visible = True
Else
Me!YourPseudoSub.Visible = False
End if

 

[kaosyeti]

hey... worked great. thanks.

Greg:

To accomplish this you need to create a "pseudo" subreport for each true
sub, with the pseudo report not bound to a query, but just containing the
text you want displayed. You can put the pseudo report on top of the true
sub and set its visible property to false. Then in the group header or
footer where the sub would normally be displayed, add code like this:

If Me!YourTrueSubreport.Report.HasData = False Then
Me!YourPseudoSub.Visible = True
Else
Me!YourPseudoSub.Visible = False
End if

hey.. i have a report that is basically 14 different subreports, all in
their

[quoted text clipped - 7 lines]

the header and footer, despite the detail section being empty. is this
possible? thanks.