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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress Page Header in Report Footer

Status
Not open for further replies.

herrld

Technical User
May 10, 2001
69
US
I have a report with a Report Header, Page Header, 5 Group Headers, a Page Footer, and a Report Footer. The report footer contains a crosstab report that summarizes the data found in the details.
In Format Section, Page Header, Suppress formula editor I used

WhilePrintingRecords;
onLastRecord;

I worked well in the fact that I don't see the page headers within the Report Footer pages (my crosstab is several pages).

The only problem is this:
If my last record happens to be the first record on a new page, my page header will not print on that page.

I don't know how to get around this. Really bugging me.

Thanks for the help! Linda
 
Create 2 report footers, A and B, and put your crosstab in B.
Then create a boolean variable in a formula that you put in A:

WhilePrintingRecords;
BooleanVar Suppress := True


Then suppress the PH with:

WhilePrintingRecords;
BooleanVar Suppress Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
 
Awesome!

Thanks Ken. Worked like a charm. Linda
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top