trying to display the BY field in my report. It shows BY fieldname correctly but when the corresponding value for the BY field goes to new line then BY field prints there too.

EX:

Page1
1 xxxxxxx
xxxxxxx
2 xxxxxxx
xxxxxxx
Page2
2 xxxxxxx
3 xxxxxxx


I dont want 2 to print in Page2 as we already printed that in Page1. This is happening in PDF.

How about this, where you're printing Y by X?

DEFINE FILE XYZ
XFIELD/A2 = IF X EQ LAST X THEN ' ' ELSE X;
END

TABLE FILE XYZ
PRINT XFIELD Y
END

Note that this only works if the file is already sorted by X. If it is not, then this might work:

TABLE FILE XYZ
PRINT
COMPUTE
XFIELD = IF X EQ LAST X THEN ' ' ELSE X;
Y
BY X NOPRINT
END

If that doesn't work, then create a hold file sorted by X and implement the first idea.

another alternative is to make the BY field a NOPRINT and do
ON FIELD SUBHEAD
"<FIELD"

Have you tried using 'ON byfieldname NOSPLIT'?

CurtisA, NOSPLIT works fine. Thanks a lot.

NOSPLIT only works if your data for a particular BY field all fits on one page.
If you have more than one page of data it will print the BY field on the new page.