We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Supressing Report Header in the Report Footer

pothireddysunil
on
Medium Priority
469 Views
Last Modified: 2010-07-15
I had a Report(Crystal Report) in My Application.

I am Printing PO Terms in the Report Footer(Section 4).I need to suppress the Page Header(Section 2) in the Report Footer(Section 4).Is there any way to do this.

Thanks
Comment
Watch Question

Top Expert 2004
Commented:
Once a section is printed, you can't have a section that prints later go back and suppress that previous section.
Can you explain more about your report?
Are you trying to suppress the Page Header on the same page that the Report Footer prints on?

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Use a conditional formatting formula to supress the PH when its the last page like this :

formula:
PageNumber = TotalPageCount

Author

Commented:
I have a CrystalReport.

Its has Page Header(Section 2).It prints in Every page in the Report.

I have Included Report Terms in the  Report Footer(Section 4).

Here I need to suppress the Page Header(Section 2) when Report starts printing Report Footer(Section 4).

Author

Commented:
I need to Print Report Footer in a starting in a New Page .

Now while doing so I want to suppress the Page Header for the total number of pages utilized to print the report footer.
Top Expert 2004

Commented:
Go into the Section Expert.
Highlight Page Header.
Click the X+2 button to the right of Suppress (No Drill Down).
In the editor window, enter this:

not onlastrecord

Save and CLose and Test.

Author

Commented:
The requirement is the following

I need to Print Report Footer in a starting in a New Page .

Now while doing so I want to suppress the Page Header for the total number of pages utilized to print the report footer.

Author

Commented:
hai bdreed35 u r reply is not working.

But my requirement exactly is :


I need to Print Report Footer in a starting in a New Page .

Now while doing so I want to suppress the Page Header for the total number of pages utilized to print the report footer.



Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Add the following suppression to the page header

Open the report
Right click the PAGE HEADER in the left margin
Click FORMAT SECTION
CLick the formula button next to suppress
Fromula is
OnLastRecord

mlmcc

Author

Commented:
Thanks
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Glad i could help

mlmcc
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.