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

[Former Member]

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]

Good working...!

[abhilash_kumar · Accepted solution]

Hi Audrie.

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

Count({Items}) > 1 AND OnLastRecord

-Abhilash

[Former Member · Accepted solution]

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 · Accepted solution]

Try using:

Not OnFirstRecord

-Dell

[abhilash_kumar · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Try:

Not OnFirstRecord and not OnLastRecord

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

PageNumber > 1

-Dell

[Former Member · Accepted solution]

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 · Accepted solution]

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

(Not OnFirstRecord and Not OnLastRecord)

or

Not (OnLastRecord and PageNumber > 1)

-Dell

[Former Member · Accepted solution]

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