how to supress page footer conditionally

building reports crystal reports
1

Hi All,
I need report with structure like below

Page header
Report header 1a
Report header 1b
Report header 1c
Detail
Report footer 1a
Report footer 1b
Report footer 1c
Page footer

There are few details in the Page Footer and is repeating in each page.
Now I want to suppress Page Footer when ever Report Footer 1c is displayed.

How can I do that ?

Looking for your help.

GNK_BO (BOB member since 2007-07-17)

2

Hi,
I have described below is used to suppress the page footer only on the last page of the report. I guess this may help you to resolve your issue.

Follow the below Steps to suppress the page footer on last page of report

  1. Open select expert window

  2. Select the page footer (which u wants to suppress)

  3. Check the Suppress (no drill)

  4. click on Edit formula option (right to the Suppress (no drill))
    write the below code in formula work area:

        if ( pageNumber = TotalPageCount) then
    True;

    Save and close the formula window.

Thanks,
:thumbsup:

BOPrakasam :india: (BOB member since 2008-07-02)

3

Hi BOPrakasam,
Thanks for your reply. This is not exactly what I wanted,but have got some hint.

Will try and update what I get

GNK_BO (BOB member since 2007-07-17)

4

Hi All,

BOPrakasam,
I was able to suppress only on last page as you did said. And then tried to do some other things to achieve my requirement. But couldn’t do it … running out of ideas.

I am still not able to do what I was trying to do.
Please help me

GNK_BO (BOB member since 2007-07-17)

5

Can you please let us know what exactly you want to do? Upon which condition you want to suppress the page footer? Does it depend upon any kind of column value or only on any static condition like page number? Please explain us little elaborately.

Thanks.

goirik :india: (BOB member since 2006-11-20)

6

Hi goirik,

Thanks for your response.
Here is some details for my problem.
I have a report which has some 4 columns and it is grouped by Year, City.
And it calculates sub-totals by City and Year.

I have text to know about the current city name in the Page Footer,which prints on each page. It is fine when they print details and sub-total by City. But problem comes when it does by Year. Whenever the Year sub-total prints it calculates for each City’s, but the text in the Report Footer still remains for the Last City which it has printed just before printing the Year Sub-totals.

So, I wanted to know how I can suppress the page footer which gives me the description of the Current City only when Year Sub-totals are getting printed.

Thanks,
Naresh

GNK_BO (BOB member since 2007-07-17)

7

Were you able to find any solution to this problem?

Even I have a similar requirement, and tried almost everything that I know… but still unable to find any solution.

ankitsingla :india: (BOB member since 2009-08-01)

8

Try this

Create formula1 with the below code

WhilePrintingRecords;
Global numberVar inc := 0;

Place this in Report header and suppress

Create formula2 with below code

WhilePrintingRecords;
Global numberVar inc := 1;

place this in Report Footer 1c

Now write a suppress logic in Page footer

Global numberVar inc;
if inc = 1 then true else false;

If it doesn’t work, try to move the 2nd formula to different sections and see(your suppress logic will not be changed in the section, try to move the formula only to different sections and test).

anil.ganga1 :us: (BOB member since 2007-07-04)

9

ThankYou so much Anil. It worked. :slight_smile:

ankitsingla :india: (BOB member since 2009-08-01)

10

Thank you so much anil. Wow a simple fix. :+1:

TripleMBI (BOB member since 2011-11-02)

11

This works! was looking for couple days to get this done! Thanks for posting the clue… :+1:

ppgandhi11 (BOB member since 2018-01-26)