Skipping Lines Between Groups
You can further enhance the visual effect of break processing by inserting one or more lines between groups. To do so, use the SKIPLINES qualifier with ON-BREAK. Here is the list_customers procedure from ex5b.sqr with the modified line shown like this:
begin-select
state (,1) on-break skiplines=1
city (,7)
name (,24)
phone (,55)
position (+1) ! Advance to the next line
from customers
order by state, city, name
end-select
The output for the modified ex5b.sqr program is:
State City Name Phone
IN Davenport Harold Alexander Fink 3015553645
Miningville Harry's Landmark Diner 3175550948
MI Bell Harbor Sam Johnson 3135556732
NH Frogline Jerry's Junkyard Specialties 6125552877
.....