Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to suppress all sections when on report footer

Status
Not open for further replies.

palpet

Programmer
Apr 11, 2003
11
CA
i put enabled "new page before" on the report footer, to make the last page a summary, but all the feild names from group sections show up. is there a way to suppress all sections when it gets to the report footer? thanks in advance for any replies
 
In the last (group or detail) section before the report footer, place the following:

whileprintingrecords;
booleanvar SuppressMe;

If onlastrecord then
SuppressMe := true

Then reference this formula in the suppression of any section which are displaying during the report footer stage, as in:

whileprintingrecords;
booleanvar SuppressMe;
SuppressMe

If you instead opted for just an onlastrecord in the suppression formula of the offending sections, if the page before the summary only contained the last record, you'd lose the headings.

Hope this resolves.

-k
 
exactly what i was trying to do. thanks alot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top