Columnar Reports
Columnar Reports list all the fields from the data source vertically down the page, one record at a time. Typically, these are used where there are a large number of fields in a table. For example: you might want to print out record cards, one per person, for a personnel database.
Sample Table
Here's a typical table that can be printed out in this format - it shows the books held in stock by a computer products company:
| QUICKLINX | MANUFACTUR | PART_CODE | DESCRIPTIO | CHILD_CAT | EX_VAT_PR | INC_VAT_PR | AVAILABILI |
| 28YX | Brady Publishing | 744001943 | Grand Theft Auto: Vice City Guide | Computer Books & Manuals | 9.99 | 9.98 | Ordered Upon Request |
| 2Z6P | Computer Step Bublishing | 1840781688 | Mac OS X in Easy Steps | Computer Books & Manuals | 9.99 | 9.98 | Ordered Upon Request |
| 2Z7H | Computer Step Bublishing | 1840782366 | Windows XP in Easy Steps in Colour | Computer Books & Manuals | 11.3 | 11.3 | Ordered Upon Request |
| 2ZF2 | Haynes Publishing | 1859609953 | Digital Photography Manual | Computer Books & Manuals | 13 | 13 | Ordered Upon Request |
| 2SKY | MS Press Books | 735619425 | Access 2003 Core Referance | Computer Books & Manuals | 29 | 29.5 | Ordered Upon Request |
| 2FY2 | MS Press Books | 735614229 | Applied .NET Framework Programming | Computer Books & Manuals | 29 | 29 | Ordered Upon Request |
| 44G | MS Press Books | 1-57231-369-2 | At A Glance: Excel 97 Bk | Computer Books & Manuals | 12 | 12 | Ordered Upon Request |
| R82 | MS Press Books | 1-57231-964-X | At A Glance: Internet Explorer 5 | Computer Books & Manuals | 12 | 12 | Ordered Upon Request |
| R8B | MS Press Books | 0-7356-0577-7 | Backoffice Small business Server v4.5 Resource Kit | Computer Books & Manuals | 35 | 35.61 | Ordered Upon Request |
| 22P1 | MS Press Books | 735614067 | Building XML Services for .NET Platform | Computer Books & Manuals | 35 | 35.61 | Ordered Upon Request |
Sample Report
And here's what it looks like in OOoReport (click on the graphic to
download the whole report as a .pdf)
