on 09-02-2010 5:26 PM
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.