Print full last page, no headers or footers

[Danster]

I am hunting down a solution which works for this seemingly easy problem, but is massively difficult. I have seen the question asked on several forums, including here on tek-tips but nothing is working for me.

I have a CR invoice layout. It has a few page header sections with company logo, customer addressing info etc.
Then a group relevant to the database structure, then the details, the group footers, report footer and page footers.

All I want is a full page on the final page. It will be a Terms & Conditions page and needs to populate the full page.

I have tried putting in the text box with T & C in the report footer, the page footer, one of the group footers. Have tried suppressing page headers and footers on last page, blah blah...Just about every trick in the book. The problem is that Crystal, even though the page headers & footers are getting suppressed on final page - is still allocating the page real estate.
I have tried a solution which nearly works. It uses a formula placed in the details section (suppressed) which saves the PageNumber when OnLastRecord to a variable.
Then the page header and footers are suppressed when PageNumber > variable. It works when I only have a small invoice, but when it is bigger and goes over a few pages, the T & C are not displaying on the last page, they start midway on the second page. I have been struggling with this for about 2 days now, have searched google high and low. At wits end.

As a secondary question - how do we go about submitting an enhancement request to SAP for the next version of Crystal Reports? I would love to see two new 'sections'. First Page. Last Page. By default they'd be suppressed.
They would have their own special tickboxes in the section expert plus all the normal ones we see. The special ones for First Page and Last Page would be 'Include Page Headers' and 'Include Page Footers'. The idea of the Last Page would be to include a final last page on reports - it might be a Terms & Conditions page, a Company details with logo & contacts details, maybe some advertising material...As for the First Page, this might be an introductory page for whatever reason. Anyway just thinking out aloud. I reckon it'd be great.

 

[pmax9999]

I just achieved what I think you are trying to do (getting a text box to print on the final page on its own) by placing it in the Report Footer section and formatting the secton with New Page Before.

You may need to conditionally suppress Page Headers (and any Group Headers formatted to Repeat Group Header on Each Page), but this can be done using OnLastRecord.

Or maybe I have misunderstood your requirement.

Hope it helps.


Cheers
Pete

 

[Danster]

Thx, but do you find that Crystal is leaving blank space where the Page Headers (and footers) would print, even though suppressed? I can't use the OnLastRecord suppression formula because if an invoice only has a few lines, the OnLastRecord will be the first page, and I need them to display on the first page.

 

[pmax9999]

Try the following as your conditional suppression formula:

OnLastRecord and
PageNumber <> 1

This will vercome the issue of suppressing sections when there is only a page single page of data.

Apply it to the Sections to be suppressed rather than the contents of those sections.

Regards
Pete