Report Footer - maximum size

Support for Crystal Reports within Jiwa.

Report Footer - maximum size

Postby Atronics » Wed Oct 14, 2020 3:22 pm

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.
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 111
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 8

Re: Report Footer - maximum size

Postby Scott.Pearce » Thu Oct 15, 2020 2:23 pm

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.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Jiwa Senpai
Jiwa Senpai
 
Posts: 625
Joined: Tue Feb 12, 2008 11:27 am
Location: North Sydney, New South Wales
Topics Solved: 182

Re: Report Footer - maximum size

Postby Atronics » Thu Oct 15, 2020 3:09 pm

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.
Attachments
TEST - Invoice Proforma. and Terms.rpt
(2.72 MiB) Downloaded 6 times
usp_SNE_Invoices_Invoice.sql
(89.4 KiB) Downloaded 5 times
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 111
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 8

Re: Report Footer - maximum size

Postby Scott.Pearce » Thu Oct 15, 2020 3:32 pm

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
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Jiwa Senpai
Jiwa Senpai
 
Posts: 625
Joined: Tue Feb 12, 2008 11:27 am
Location: North Sydney, New South Wales
Topics Solved: 182

Re: Report Footer - maximum size

Postby Atronics » Thu Oct 15, 2020 3:58 pm

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.
Attachments
Capture.JPG
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 111
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 8

Re: Report Footer - maximum size

Postby Scott.Pearce » Thu Oct 15, 2020 3:59 pm

Yeah I just noticed that effect. Did this fix give you enough space to get over the line?
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Jiwa Senpai
Jiwa Senpai
 
Posts: 625
Joined: Tue Feb 12, 2008 11:27 am
Location: North Sydney, New South Wales
Topics Solved: 182

Re: Report Footer - maximum size

Postby Atronics » Thu Oct 15, 2020 4:05 pm

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.
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 111
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 8

Re: Report Footer - maximum size

Postby Scott.Pearce » Thu Oct 15, 2020 4:13 pm

OK, I'll try some other tricks....
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Jiwa Senpai
Jiwa Senpai
 
Posts: 625
Joined: Tue Feb 12, 2008 11:27 am
Location: North Sydney, New South Wales
Topics Solved: 182

Re: Report Footer - maximum size

Postby Scott.Pearce » Fri Oct 16, 2020 9:43 am

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.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Jiwa Senpai
Jiwa Senpai
 
Posts: 625
Joined: Tue Feb 12, 2008 11:27 am
Location: North Sydney, New South Wales
Topics Solved: 182

Re: Report Footer - maximum size

Postby Atronics » Fri Oct 16, 2020 9:56 am

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.
Atronics
Frequent Contributor
Frequent Contributor
 
Posts: 111
Joined: Fri Feb 29, 2008 4:40 pm
Topics Solved: 8


Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 1 guest

cron