Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Supress page header

Posted on 2013-11-21
9
Medium Priority
?
510 Views
Last Modified: 2013-11-21
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
Comment
Question by:Star79
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39666254
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
 

Author Comment

by:Star79
ID: 39666322
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 39666372
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

Author Comment

by:Star79
ID: 39666445
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 39666633
Is there only 1 record for the report?

Is the report footer on the last page?

mlmcc
0
 

Author Comment

by:Star79
ID: 39666730
The subreport in the details section has multiple rows and the RF is the last page
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39666776
Try this to suppress the page header

PageNumber = TotalPageCount

mlmcc
0
 

Author Comment

by:Star79
ID: 39666809
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 39666817
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question