Reports / Report instructions |
Skips a given number of lines in a report.
SKIP { num-lines LINE[S] | TO TOP OF PAGE }
The SKIP statement allows you to insert blank lines into report output or to skip to the top of the next page as if you had included an equivalent number of PRINT statements without specifying any expression list.
The LINE and LINES keywords are synonyms in the SKIP statement.
Output from any PAGE HEADER or PAGE TRAILER control block appears in its usual location.
The SKIP n LINES statement cannot appear within a CASE statement, a FOR loop, or a WHILE loop.
The SKIP TO TOP OF PAGE statement cannot appear in a FIRST PAGE HEADER , PAGE HEADER or PAGE TRAILER control block.
FIRST PAGE HEADER PRINT "Customer List" SKIP 2 LINES PRINT "Number Name Location" SKIP 1 LINE PAGE HEADER PRINT "Number Name Location" SKIP 1 LINE ON EVERY ROW PRINT r.customer_num, r.fname, r.city