• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 513
  • Last Modified:

Supress page header

Hello all,
I have a crystal report XI report:
it has report header,page header,details(has a subreport), page footer, report footer(has a subreport).
When printing the report footer, how to suppress the page header?
Thanks.
0
Star79
Asked:
Star79
  • 5
  • 4
1 Solution
 
mlmccCommented:
You can try using a formula as

OnLastRecord

That will suppress the page header when processing the last record

Right click the page header in the left margin
Click SECTION EXPERT
Click the formula button for SUPPRESS
Enter
    OnLastRecord
CLick SAVE AND CLOSE
Click OK

mlmcc
0
 
Star79Author Commented:
mlmcc,
I put the formula OnLastRecord
 on the formula expert for suppress for the page header, but the page header is getting suppressed in all the pages in addtion to the report footer. I only need it suppressed in the RF
0
 
mlmccCommented:
Since you didn't mention it, I assume there are no groups.

Does the detail section ever split across a page boundary?
If not try this

IN the report header add a formula
WhilePrintingRecords;
Global BooleanVar SuppressPH := False;
""

Open in new window


IN the detail section add a formula
WhilePrintingRecords;
Global BooleanVar SuppressPH;
SuppressPH := OnLastRecord;
""

Open in new window


IN the suppression formula use
WhilePrintingRecords;
Global BooleanVar SuppressPH;
SuppressPH

Open in new window


mlmcc
0
Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

 
Star79Author Commented:
hello mlmc,
RH is already suppressed by design
PH has some logo and this has to be suppressed only in the RF
detail has a subreport which inturn has groups inside it
RF has a subreport
PF has some text and logo.
I did the above that you mentioned.It still suppressed the PH in all the pages.
Thanks.
0
 
mlmccCommented:
Is there only 1 record for the report?

Is the report footer on the last page?

mlmcc
0
 
Star79Author Commented:
The subreport in the details section has multiple rows and the RF is the last page
0
 
mlmccCommented:
Try this to suppress the page header

PageNumber = TotalPageCount

mlmcc
0
 
Star79Author Commented:
hello mlmcc, the above worked but I did not understand what it actually means when we put

PageNumber = TotalPageCount in the suppress formula expert of the PH.
Pls let me know.
0
 
mlmccCommented:
It is just testing if the page being printed is the last page of the report.  If so then suppress the page header

mlmcc
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now