Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supress Group Footer if last section on page

Status
Not open for further replies.

auylox

Technical User
Feb 7, 2007
20
CA
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
 
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
 
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top