Print — Repeat

SQL returns every field on every row selected on a query. You often don’t want every field to print on every row. So… we have this reserved word.

Where count and summarize keep track of unique values, repeat deals entirely with consecutive values.  If the values of the records are like this:

A B B C B A A C C B B A  — the printing would be like this:
A B    C B A     C     B     A

There are two forms.

  1. norepeat — skips print of duplicate value
  2. repeat on — accepts modifiers. Whenever the target field or any one of the modifiers change, the field prints.

 

   Page 1 — repeat
   Page 2 — norepeat
   Page 3 — repeat on
   Page 4 — repeat on page

Next – norepeat >