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 →

Quiz — Prompts

Once you have designed that perfect report, you will want to use it over and over again. The report may only have to be modified by date range or other filters. Enter the prompt With prompts, the person running the report never has to mess with the Quiz Pad.    Page 1 — Prompts
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 — Count

The count reserved word is used in to print a count of fields. The count can be filtered by conditions and the values of other fields. There are two forms for the count reserved word.      Page 1 — count    Page 2 — end count    Page 3 — count as column Next 
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 — Mask

A mask is a literal value (enclosed in quotation marks or dictionary words) that is used to format field values. Captions are a special form of a mask.      Page 1 — mask   Page 2 — the asterisk   Page 3 — numeric masks  
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 →