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!

No page header on last page

Status
Not open for further replies.

kutoose

Technical User
Sep 11, 2002
169
US
In my report, I need to suppress to sections of a page header on the last page. In the last page, i am showing group footer and I don't need this page header.
Please help
 
In the Page Header section, use the following expression for the Suppress attribute:
----------------
OnLastRecord
----------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
IDO -

That will only work if the last record is the only record on the last page


Try this instead in the conditional suppress of the sections you want to disappear


WhilePrintingRecords;
PageNumber = TotalPageCount;

Jim Broadbent
 
Just to clarify. If entered in format section->detail->suppress, "OnLastRecord" will suppress page headings on a page which holds ONLY the last record AND on all subsequent pages. If the last page with detail records has more than one record, the page header will NOT be suppressed.

Because of "keep together" used on report sections and groups, it is rare to find an orphaned detail (which needs the page header to display), so I take the tiny risk of using "OnLastRecord" to suppress subsequent page headers, e.g., if I have "new page before" checked for two or more different group footers which display after the final detail.

If you have only one page after the final detail, the pagenumber = totalpagecount is the best way to go--if you know there will be no details on that page.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top