Suppress page header when report footer prints 1

[Meredith]

I have a report that contains a subreport in the report footer. I don't want the main report's page header to print when the report footer prints (therefore printing the main report page header on top of the subreport). I also do not want the page header of the main report to print on the first page so currently I have a suppression condition in the pageheader that says:

pagenumber = 1

The first page suppression formula works but I just don't know how to combine that along with the condition to not print when the report footer prints.

Any help is appreciated!
Thanks.

 

[MrBillSC]

Meredith,

Try suppressing the page header if

PageNumber = 1 or
PageNumber = TotalPageCount

I think this should work.

 

[Meredith]

It works - kind of. The problem is that it just suppresses the header on the very last page. Unfortunately my subreport is several pages long and so it has to suppress from the time that the report footer prints. Thanks though!

 

[MrBillSC]

Meredith,

Try creating a formula (call it SuppressPageHeading) something like this:

If OnLastRecord then "y" else "n"

Conditionally suppress the page heading if SuppressPageHeading = "y"

This could be a problem if the last record of your detail section moves to the top of a new page - you might not get a page heading for that page.

I haven't tested this, but its the direction I would go.

MrBillSc

 

[herrld]

I have the same problem as Meredith. My report footer contains a crosstab report that is several pages long. I want to suppress the page header on all of the pages of this crosstab. Cannot get it to work.

Thanks, Linda

 

[kenhamady]

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

http://www.kenhamady.com/

- tek@kenhamady.com

 

[DrJavaJoe]

Thanks Ken, just the solution I was looking for.