QUIZ — the basics

Not to offend the technological professionals –  but Quiz is the report writer for the non-IT elect. You want a Customer list? That takes nine words: (or seven words if you don’t care about the sort order).      Page 1 — the basics    Page 2 — the result    Page
View Article →

Print — Combining Fields

Concatenation allows you to print several fields as one column. The fields to be combined are enclosed by the “{“ (left squiggly bracket) to begin concatenation  and “}” (right squiggly bracket) to end concatenation reserved word characters. Next – Exampl
View Article →

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 a
View Article →

Print — Summarize

summarize is used in two ways: For numeric fields, summarize will calculate a running total of the field. The on arguments then determine when the accumulated value prints. When the field prints, the running total is reset to zero. Where break will print totals under an existing colum
View Article →

Print — Column Headings

Quiz supports up to two rows of column headings. The default is one row. The default caption is the name of the column field.      Page 1 — column headings    Page 2 — default column headings    Page 3 — column labels Next – Default Column Headings >
View Article →

Print — Header

A Quiz header is a field that is printed, but not defined as a column. The default print position for headers is at the left margin of the report. First, we’ll look at what the report looks like without the header.      Page 1 — header    Page 2 — no header    P
View Article →

Print — Break

Break is a relative of header, or vice versa. It is the mechanism to print sub-totals for a group of items. The break reserved word is used on the parent or driver of the sub-totals. The best way to see how it works is to view an example:      Page 1 — break    Page 2 ̵
View Article →

Quiz — Reserved words

Every word and symbol on a Quiz pad that is not a literal (enclosed in quotation marks) is a word in the Quiz dictionary. Reserved words are those that are pre-defined with special meaning to Quiz. So, here we go…   Page 1 — Quiz words  Page 2 — Operators  P
View Article →