Page 1 of 1

Report Footer - maximum size

PostPosted: Wed Oct 14, 2020 3:22 pm
by Atronics
Is there a maximum size for the Report Footer. I want to include Terms and Conditions on the last page, which is not a problem. However, the T&C take up nearly a whole A4 page. No matter what I attempt in suppressing all other sections of the report, I am unable to get the Report Footer to print on one page. As soon as the RF section is longer than about 16cm it will spill over to two pages.
How do I get the report footer to have the whole of the page available to it?
There is nothing useful on a web search, which can assist.

Re: Report Footer - maximum size

PostPosted: Thu Oct 15, 2020 2:23 pm
by Scott.Pearce
I'm going to need an example report. I just threw together a test report with an 18 cm text report footer and it appeared to behave itself.

Re: Report Footer - maximum size

PostPosted: Thu Oct 15, 2020 3:09 pm
by Atronics
Hi Scott.
Sample report is attached. Have also supplied the sp that drives the report. Note: The report footer is currently set at the maximum length without spilling over to an additional page. The client needs to add additional conditions.

Re: Report Footer - maximum size

PostPosted: Thu Oct 15, 2020 3:32 pm
by Scott.Pearce
By default Crystal will simply show or hide the page footer based on suppression options. However, suppressing simply hides the text/objects - the white space of the section remains.

To reclaim this white space, you need to tick "Reserve Minimum Page Footer" in the section expert for the "Page Footer" section.

Screenshot 2020-10-15 153205.png

Re: Report Footer - maximum size

PostPosted: Thu Oct 15, 2020 3:58 pm
by Atronics
Scott.
That gives me a little extra space as per the highlight. If I make footer any larger than what it currently is, then it spans to the next page. I still have a big chunk of empty space.

Re: Report Footer - maximum size

PostPosted: Thu Oct 15, 2020 3:59 pm
by Scott.Pearce
Yeah I just noticed that effect. Did this fix give you enough space to get over the line?

Re: Report Footer - maximum size

PostPosted: Thu Oct 15, 2020 4:05 pm
by Atronics
Unfortunately, not. I have searched everywhere for an answer with out success. The client has a couple of paragraphs to add and apart from using an unreadable small font (which defeats the purpose of having T&C, as there is a legal requirement for the font size and colour for T&C to be deemed to have been supplied), I am at a loss.

Re: Report Footer - maximum size

PostPosted: Thu Oct 15, 2020 4:13 pm
by Scott.Pearce
OK, I'll try some other tricks....

Re: Report Footer - maximum size

PostPosted: Fri Oct 16, 2020 9:43 am
by Scott.Pearce
See if this works for you:



I have placed the page footer objects into a new Details section ("Details e"). I ticked "Print at Bottom of Page" in the Section Expert for that Details section. I have set the suppression formula of that Details section to be:

Code: Select all
NOT OnLastRecord


It seems to work OK but I didn't push it real hard. See how you go with it.

P.S. The suppressing of page footers not releasing white space is a known Crystal issue and upsets a lot of people it seems.

Re: Report Footer - maximum size

PostPosted: Fri Oct 16, 2020 9:56 am
by Atronics
Hi Scott.
That seems to work. I have been able to get almost a whole A4 space available, so I think this will be the way to deal with this limitation in Crystal.
Thanks. Much appreciated.