Sub Report on First Page Only

N

neenmarie

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
 
A

Al Camp

Habe you tried using the Report Header. That section only prints on page1.
hth
Al Camp
 
N

neenmarie

Thx for the idea, but the powers that be would like it on the bottom of the
first page.
 
A

Al Camp

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
 
N

neenmarie

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
 
N

neenmarie

Thank you for your responses. I guess everyone will have to live with it on
the last page for now. thx again
 
E

ETC

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