Hi,

Is there any way by which we can implement the same thing done by SET LINES in HTML format, in EXCEL also.
SET LINES property doesnt work in xls but I want to put a page break after say 100 lines of data.

Plz help
Regards,
CD

Digger,

See an example with 10 lines per page.

TABLE FILE CAR
PRINT SALES
BY COUNTRY
BY CAR BY BODYTYPE
ON TABLE HOLD
END
DEFINE FILE HOLD
L/I5 WITH COUNTRY = 1 + LAST L; 
PB/I1=IF IMOD(L,10,'I1') EQ 0 THEN 1 ELSE 0;
END
TABLE FILE HOLD
HEADING
"Page <TABPAGENO "
PRINT COUNTRY CAR BODYTYPE SALES
BY L NOPRINT
BY PB NOPRINT
ON PB PAGE-BREAK WHEN PB EQ 1;
FOOTING
" "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
END

Danny-SRL solution is good, especially if you don't have by fields in the report. Of course, I don't think I've ever actually printed an excel sheet which has a 'page-break' to see if it does 'page-break' in printing if that is what is wanted rather than to just put in some space. Have to try it some time.

Digger, you understand that excel is going to talk to the users printer driver, whereas html is not, right?