cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports 11 - Missing Page Header or Printing Blank Last Page

Former Member
0 Kudos

Hi,

I am using Crystal Reports Ver 11 through Microsoft Dynamics 2010 to print POs.  I have recently been asked to add an additional page for Terms & Conditions to print automatically after the PO page.

Report Header is blank and suppressed.

Page Header has Company Logo, name, address, etc.

Group Header is linked to GP pulling Vendor info

Details (a&b) linked to GP pulling PO info

Group Footer linked to GP pilling item info

Page Footer states Page count info

Page Footer hidden and suppressed

So for the Terms & Conditions:

I added the Terms & Conditions in the Report Footer section

I changed my Page Header to suppress 'OnLastRecord'

When a PO is for 2 or more items, the PO prints correctly with a page header on one page and the Terms & Conditions separately on a second page. 

When a PO in only for 1 item, the PO does NOT have a page header but the Terms & Conditions print on a separate page.

I have tried to change the Page Header to suppress with PageNumber=TotalPageCount-1 and I get an extra blank page at the end.  The blank page increases my page count.  So the PO would state page 1 of 3, 2 of 3.

I am not really sure what needs to be adjusted on my report so that the page header prints on the PO and the Terms & Conditions print on the next page.

I am not sure what screen shots will be needed, so please let me know.

Thank you!

Audrie

Doctor_ogm
Explorer
0 Kudos
Good working...!

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Audrie.

Please see if this suppression formula on the Page Header works:

Count({Items}) > 1 AND OnLastRecord


-Abhilash

Former Member
0 Kudos

With this, the Page Header also printed on the Terms and Conditions page with made the T&C go to 2 pages.

Thank you for your suggestion.

Audrie

DellSC
Active Contributor
0 Kudos

Try using:

Not OnFirstRecord

-Dell

abhilash_kumar
Active Contributor
0 Kudos

Do you need the Page Header to print on all pages except the page that prints the T&C?

Try this:

1) Create a formula with this code:

whilereadingrecords;

'';

2) Go to the Group Expert > Add this field to the top of the group list.

3) While in the Group Expert, highlight this formula field > Options > options tab > Check 'Repeat Group Header on each page'.

4) Move all contents from the Page Header to this new Group Header 1

5) Suppress the Page Header and Group Footer 1

-Abhilash

Former Member
0 Kudos

The Page Header also printed on the Terms & Conditions which made the T&C split to 2 pages.

Thank you for your suggestion.

Audrie

DellSC
Active Contributor
0 Kudos

Try:

Not OnFirstRecord and not OnLastRecord

If that doesn't work, you could do this:

PageNumber > 1

-Dell

Former Member
0 Kudos

We are getting close!  This worked as long as the PO was small enough to print on 1 page.  I tested a larger PO that would normally print on 2 pages, and the header was not on the second page.

Audrie

DellSC
Active Contributor
0 Kudos

Ok....once more with feeling.....

(Not OnFirstRecord and Not OnLastRecord)

or

Not (OnLastRecord and PageNumber > 1)

-Dell

Former Member
0 Kudos

Thank you for all your help.  I was able to get it to work!

I used (OnLastRecord and PageNumber >1)

My single page and my multiple page PO's all printed with headers on the correct ages and the T&C at the end with no header!!

Thank you again!

Audrie

Answers (0)