Suppress Footer on Condition

[ddfff]

Is there any way to suppress the page footer when using a formula?

Far as I can tell, it will ONLY suppress when I check the box for supress but do NOT enter a formula condition. Otherwise, it always reserves space for the footer even when the suppression condition is met.

Thanks in advance.

 

[synapsevampire]

A formula in the page footer works fine, but if you don't share what you're trying, nor the version of Crystal, you're just wasting time.

Try placing the following in your page footer X 2 suppression formula:

1=1

You'll see that it's suppressed.

If yours isn't suppressing, then it's your formula, so share specifics if you'd like specific answers.

-k

 

[ddfff]

Ok. Lets try this again....

Using version 8.5.

Create a report with neither the report header or page footer suppressed.

Draw a verticle line on report header and select "extend to bottom of page". Then make the report header section at least as big as a single page, let's say 11 inches.

Make sure the page footer is sizeable (maybe a couple of inches), but it can be left blank.

Now preview the report and you will see that the line from report header does NOT extend to bottom of the page, the report reserves space for the page footer even though it may be blank.

Now go back to design and click Suppress(no drill down) for the page footer and preview again. You will see the line now extends to bottom of page. This is what I need.

However, if you go back and add a formula to the Supress(no drill down) section of the page footer (say 1=1), and preview....Line No Longer extends to bottom of page.

So my problem is that I cannot suppress the page footer when using a formula as suppression criteria.

Any way around this?

Thanks again.

 

[lbass]

You could use a workaround which uses another section(s) for the page footer. First you would need to create a formula {@linecnt}:

whileprintingrecords;
numbervar linecnt := linecnt + 1;

Place this in each section on the page: group header, detail, group footer. Note the maximum number of lines you want per page, e.g., 40.

Insert new sections: GH#1b, detail_b, and GF#1b. Format each of these to suppress with:

remainder({@linecnt},40) <> 0 or
{table.condition} = "x" //add your criteria here

For each of these sections also format "new page after" with:

remainder({@linecnt},40) = 0

Place the page footer text into each "b" section.

-LB