quote:

Is there any way to change the period "ON TABLE SET EMPTYREPORT ANSI" creates

You can do that with the NODATA option:
TABLE FILE CAR
PRINT *
IF COUNTRY EQ 'MEXICO'
ON TABLE SET EMPTYREPORT ANSI
ON TABLE SET NODATA '0'
END
This will show all zeroes for all fields in the report.

Could you not use:

 
-RUN
TABLE FILE HOLD
SUM
MAX.TOPS_NBR
ON TABLE SAVE
END
-RUN
-SET &PCOM = IF &LINES GT 0 THEN '' ELSE '-*';

then in the report use

&PCOM.EVAL TOPS_NBR AS 'Policy,Number'

Since this is for ReportCaster, can you setup two report jobs - one for the zero policy numbers where the column is omitted and a second for the non-zero policy numbers where the column is printed?

I apologize but I have not had a chance to get back on this one. I hope to be able next week when I get back from vacation.

Have a great weekend!

Thanks for all the help. The user decided not to go with this after all. I apologize for such a late response from me but they have me buried in reports.