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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppressing Values and NOT Supressing

Status
Not open for further replies.

LeonelSanchezJr

Programmer
Jan 26, 2001
522
US
I am using the compute code below to supress repeated values on a field which is not a BY field.

The code works great! However, I now face a new challenge.
I need to SHOW the field if it appears on a new page. I suppose this is to duplicate Widows/Orphans from Word?
Can this be done?

COMPUTE FIELD_ABC/A25 = IF FIELD1 NE LAST FIELD1
THEN FIELD1 ELSE ''; AS 'Series'

Thanks,

Leo ;-)
 
You could try setting up a line counter and include it with your compute...

DEFINE FILE XXX
LINECNT/I2 = IF LINECNT GT 55 THEN 1 ELSE LINECNT + 1;
END
....
COMPUTE FIELD_ABC/A25 = IF FIELD1 NE LAST FIELD1 THNE FIELD1
ELSE IF LINECNT EQ 1 THEN FIELD1 ELSE '';
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top