Supress Group Footer if last section on page

[auylox]

Hi,

Using CRXI on an oracle database

I'm trying to figure out how to suppress my Group Footer 3 when it is the last section on a page. I've tried to do a running total by using
numbervar count:=count+1
in each group footer 3,2,1 and Page footer and resetting it in each page header but when I try to use the suppression formula
{Count Up}>next({Count Up})
I get a message telling me that {count} has no previous or next values.

Is there way to make this work?

KB

 

[lbass]

Can you explain why you want to do this? Also, do you have any sections set to new page before or new page after?

-LB

 

[auylox]

Hi lbass

The footer contains a design element that I only want to appear in between group 3 sections. I've figured out how to suppress it if it is the last group 3 within a group 2 but if group 2 continues on the next page, I don't want the design element to show up at the bottom the page.

I don't have any sections set to start a new page after.

KB

 

[chelseatech]

If you want to suppress the last record then you could use OnLastRecord

If its a Group Footer 3 in the middle of the report try
{Table.Field} <> next({table.field})

Or the Previous field value might do what you want.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[lbass]

The only solution I can think of is to count the sections displayed on the page as you started to do with your formula placed in each displayed section:

whileprintingrecords;
numbervar count := count + 1;

Then observe the count at the bottom of the page and conditionally suppress the GF3 if it falls on that count:

whileprintingrecords;
numbervar count;
count = 45; //if 45 equals the last count on the page

-LB