cancel
Showing results for 
Search instead for 
Did you mean: 

Hide page footer page 2 onwards

Former Member
0 Kudos

Hi

We have a report developed for a customer which has an OLE object holding a PDF image in the report's page footer.

The customer would now like this OLE's image only displayed on page 1 of the report to allow the detail section to show more data on subsequent pages.

I have tried to hide/suppress the OLE object and/or the page footer but without success. I can get the image to not show on subsequent pages but the height of the page footer remain the same throughout the report.

Effectively what I want to do is to make the height of the page footer section zero for pages 2 onwards.

How may I achieve this?

Yours in hope.

Edited by: bobjohnbarker on Sep 2, 2010 6:27 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Thanks for your response.

I had tried this and, although the contents of the page footer are suppressed on page 2 onwards, the height of the page footer remains the same throughout the report as on page 1 where the page footer contents are correctly displayed.

I want to effectively have the page footer section height as 0 on pages 2 onwards to allow the detail section to be bigger on these subsequent pages.

I had suggested moving the page footer contents into the report header but this was no good for my customer.

Any further ideas?

Former Member
0 Kudos

Hi

You could insert a second page footer, that would only print, at the normal height, from page 2 onwards

And the footer with the ole object would only print on page 1

best regards

patrick

Former Member
0 Kudos

Thanks for your suggestion Patrick.

I have tried this by suppressing PageFooterA (with the OLE object) where pagenumber>1 and suppressing PageFooterB ('normal' height) where pagenumber=1.

Same result. My OLE object is correctly not displayed on pages 2 onwards but the size of PageFooterA remains (i.e. PageFooterA height is not 0)

Maybe I have not understood what you mean? When you mean 'only print' did you mean controlling this by suppress?

patrick_genest
Advisor
Advisor
0 Kudos

The reason this is happening, it's because when generating a page, Crystal Reports will reserve the space for the Page Footer section first, then print in the rest of the space available the other sections information: Details, Group Header, Group Footer,... And when it arrives at the Page Footer section it will evaulate if it needs to be suppressed or not. So the space for the footer is already reserved and it only display or not the information that section contains.

For simple report, one way around it, will be to not use the Page Footer section, and instead use a second details section and conditionnally suppress and print it at the end of a page.

For example:

Details a section will contains all the database fields you want to display on your report

Details b section will contain what you want to print at the bottom of the page on page 1

Then create a conditionnal suppression for Details b section to only print once. The formula will look like:

WhilePrintingRecords;

NumberVar x := x + 1;

If x = 50 Then False Else True

And create a conditionnal print at the bottom of section for Details b section. The formula will look like:

WhilePrintingRecords;

NumberVar x;

If x = 50 Then True Else False

On Page 1, it will print the first 50 records, then print Details b section at the bottom of the page.

On the next pages, it will not reserve any space for it since it is not a page footer.

The number 50 used is only an example, and it will need to be adjusted for your report. It could be 20, 10,...

Hope this help!

Patrick

Former Member
0 Kudos

Thanks for your suggestion Patrick.

You suggest

>

> create a conditionnal suppression for Details b section to only print once.

>

and

>

> And create a conditionnal print at the bottom of section for Details b section.

>

I can see in the section expert where to set my conditionnal suppression but not a 'conditional print'.

Can you advise further.

Thanks again

Bob

patrick_genest
Advisor
Advisor
0 Kudos

Hi Bob,

The section option: "Print at Bottom of Page" is located in the Section Expert, under the tab "Common"

In Crystal Reports 2008 and XI R2, it is right under the "Suppress (No Drill-Down)" option

Patrick

Answers (1)

Answers (1)

former_member292966
Active Contributor
0 Kudos

Hi,

When you right-click the Page Footer and go to Section Expert. In the Conditional formula for Suppress you can use this formula:

PageNumber > 1;

This will suppress the Page Footer from page 2 onward.

Good luck,

Brian