Help with Summary field in Report Footer

[Former Member]

Hello All,

I have a crystal report which consists of total 8 pages. And on page 9 I want to show only the grand total without displaying anyother information. So my report will have 9 pages all together.

When I am adding a summary field (distinct count) in the Report Footer its getting displayed on the page 9 but along with column headings(which are in Page Header)

How can I achieve this by keeping the column headings in Page Header itself.

Any help is greatly appreciated.

Thank You!

[Former Member · Accepted solution]

I do not have CR in front of me but try this....

Open the section expert for page header and add the formula "pagenumber = totalpagecount" for suppression. That should keep the page header suppressed on the last page.

[Former Member · Accepted solution]

Thanks a lot!

And in Page Footer I have a graphic whose suppress formula is as follows:

{usp_PU101OVERSEAS;1.language}<>'korean' or {usp_PU101OVERSEAS;1.aorb}<>'2'

I want to suppress this also on page 9, I forgot to mention this in my original thread. Shall I follow the same approach as you suggested.

[Former Member · Accepted solution]

Yes, anywhere you see a suppress formula, you can add that. If you did not want to suppress the whole page footer, then right click the image itself and suppress with the same formula.

[Former Member]

If I'm understanding correctly, this can be achieved using the section expert.

In the section expert click on report footer:

check "New Page Before"

Go to the Page Header:

Next to "Suppress" go into the formula (x-2 button)

Input:

onlastrecord

Save and close the formula. Click ok, and it should produce the result you're looking for.

[Former Member]

>

> If I'm understanding correctly, this can be achieved using the section expert. 
> 
> In the section expert click on report footer:
> check "New Page Before"
> 
> Go to the Page Header: 
> Next to "Suppress" go into the formula (x-2 button)
> Input:
> onlastrecord
> 
> Save and close the formula. Click ok, and it should produce the result you're looking for.

Since he is producing a "summary" page after the details section (page 9), I believe that onlastrecord will only be true for page 8, where the last detail record exists. I may be wrong though!