Sub Report on First Page Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I get a Sub-report to print on the first page only. I have been able
to put it in the report footer so it prints on the last page. But, I'd like
it on the first. Any help is much appreciated
 
I'll try to test something out if I can... and get back to you.
In the meantime...
I think you need some kind of a "trigger" so that the second time the
subreport goes to print (Page 2) you've made the hieght 0.
Something akin to using a Header section to set a boolean variable like
SubHasPrinted = True.
Then, when the sufreport comes to print the seconmd time SubHasPrinted =
True, and use the OnFormat event to collapse the subreport. If SubHas
Printed = True Then.... Else...

Also, could you give more info on where the subreport resides now...
Deatil Section, Header, Footer?

hth
Al Camp
 
The subreport is currently in the Report Footer- so it shows at the end of
the last page. We'd like it at the bottom of the first page.
thx so much
 
neenmarie said:
The subreport is currently in the Report Footer- so it shows at the
end of the last page. We'd like it at the bottom of the first page.
thx so much
Click to expand...

Difficult. The only way to position something at the bottom of the first
page is to use the PageFooter. You could use code to hide the PageFooter on
all other pages, but the blank space would still be there and since
PageFooters can't grow you would need to make it tall enough to show the
entire subreport (and of course the subreport wouldn't be allowed ot grow
either).
 
Thank you for your responses. I guess everyone will have to live with it on
the last page for now. thx again
 
Hi Al,

I have a similar problem. I figured out how to make the subreport in the
footer of my report. But now I've forgotten how I did it and I want to move
it to the beginning of the first page (Report Header). Is it as easy as cut
and paste? If not, I can't even figure out how to delete it in the Report
Footer.
 
Back
Top