SET TITLE = OFF
DEFINE FILE EMPLOYEE
EMP_CNT/I2=IF EMP_ID EQ LAST EMP_ID THEN 0 ELSE EMP_CNT + 1;
ROW_CNT/I2 = EMP_CNT/4;
COL_CNT/I2=IMOD(EMP_CNT,4,'I2');
END

TABLE FILE EMPLOYEE
SUM
     LAST_NAME AS '' OVER
     ADDRESS_LN1 AS '' OVER
     ADDRESS_LN2 AS ''
BY ROW_CNT NOPRINT
ACROSS COL_CNT NOPRINT
ON ROW_CNT SKIP-LINE
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.000000,
     TOPMARGIN=0.000000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=4,
$
TYPE=DATA,
     ACROSSCOLUMN=N1,
     STYLE=BOLD,
$
TYPE=TITLE,STYLE=-UNDERLINE,$
ENDSTYLE
END

quote:

Originally posted by RSquared:
I don't have any solutions for yout first problem, however as far as the blank column, if you change your defines to this
/*
DEFINE FILE EMPLOYEE
EMP_CNT/I2=IF EMP_ID EQ LAST EMP_ID THEN 0 ELSE IF LAST EMP_ID EQ '' THEN 0 ELSE EMP_CNT + 1;
ROW_CNT/I2 = EMP_CNT/4;
COL_CNT/I2=IMOD(EMP_CNT,4,'I2');
/*
it will eliminate your problem.