Very intriguing Report Question

[thewesties]

OK. The hardest part of this will probably be explaining this the right way so you can understand.
I have a database that has one report which is a standard proposal ('rpt_Proposal' ) This report has a 2 1/2" Page Header (company info) and 2 1/2" Page Footer (Acceptance of Proposal, etc.)
This report prints fine. After 30 bid line items, it starts a new page (with the correct page header/footer placement.

Now...I am attempting to create a second report. This one will be connected to a faxing feature. On the report header I am creating essentially what would be a fax cover page. This will be a 10" report header to prevent anything else from showing on this page except the report header (at least theoretically.)
When I go to preview the report, I get the proper Fax cover page (no header) BUT... the Footer shows on the first page (which I would naturally prefer not to happen.)
I have tried several things to no avail.
First: was to create 2 reports and insert both of them as subreports on a common report. 1) the Fax Cover Page and 2) The Proposal (which I already had.) With this, I got the fax cover page fine, but no header or footer would show for the Proposal subreport.

Second: Create a fax Cover page report and have the proposal linked as a subreport. No go...Again, no proposal header/footer info appears.

Third: One massive report which had no subreports (described in opening)

Now, I have also tinkered with the sorting/grouping settings thinking perhaps some adjustment might fix it. I have bounced it off of some friends, searched here for prior posts and scoured the internet.

Any help would be greatly appreciated.

 

[Philem]

Hullo. Quick guess is to put some code in the OnFormat section of the report, that EXCLUDES the page footer on the first page only, by page number, then brings it back for all others.

HTH

P

 

[thewesties]

How exactly would I go about it?
Would I have to put something like this:
If [Page] = 1 then
Text160.visible = False
Label73.visible = False
etc for roughly 40 controls....
End If

or...

Is there a shortcut that would make life easier.

Thanks

 

[CT Witter]

You could also create 2 reports (1 for cover sheet & 1 for the actual report)and collate them.

See Microsoft Knowledge Base Article #231805 - Using Visual Basic Code to Collate and Print Two Reports at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;231805&Product=acc2000

HTH,
CT

 

[thewesties]

I managed to get it to work at some point when CT replied. I didn't need to go toMS' site or fight with the OnFormat property. I managed to rig it by adding in a dummy grouping and have the fax cover page inside the Group Header followed by a forced page break. The Page header, detail and footer remained the same.

Thank you all for you responses.

Happy coding!