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
.....