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