Vernon Cataloguing
- Featuring some of our clients and few of the artifacts from their collections
-
Client
Royal Air Force Museum
Hendon, London, England
Description
Hawker Hart Mk. II, produced by Hawker Aircraft Limited in 1931
Reporting
Vernons Reporting Window is as easy to use as the Query Window. It presents you with logical steps for preparing a report to print or to view on screen or to be exported. You decide on a format, select records to report on (if you haven′t already selected them), choose which data fields to display, specify any sorting criteria and select some additional options for the look of your report. You can complete these steps in any order and since most of them have default settings you often have to do nothing at all.
There are three distinct types of report:
Listings
Listings are reports created in Vernon. They have two formats - with the fields either orientated vertically Down the Page, where the labels are on the left with data shown adjacent on the right, or horizontally in columns Across the Page.
Exports
Exporting data allows you to take advantage of the formatting, calculation and
other facilities available in word processing, spreadsheets, desktop publishing or
other similar applications. You choose the export format you need (e.g. Excel,
Word ′ you can create more of these for yourself, specifying the delimiters
to be used for records, fields, values, etc). Then specify the records, fields to
display, sorting, etc, and the path/filename to write the data to. The export
facilities can protect your data against unmatched quotation marks in text (e.g.
3′ 6") and can generate a header specifying the names of the fields being exported
(useful for documentation and for column headings in Excel).
BELOW: Vernons Reporting Window.
BELOW: Down the Page reports have the field labels on the left with data on the right. Images can optionally be included.
Word Merge
Microsofts Word Merge is integrated and fully automated within Vernon. Users can create and save report definitions including the Word template. All that is needed is to retrieve the saved report definition, and select the records and then run it. The system exports the data and then calls Word which produces the report. This is often the best way to produce attractive forms reports such as loan agreements, transfers of title for gifts, labels, etc. You get all the functionality of Microsoft Word, with none of the work of creating the merge template manually. There is also a macro which allows users to place an image from the record within the body of the report.
ABOVE: A sample label created using the Word reporting facility within Vernon
General Features
- Build new ad hoc reports easily, selecting from the full list of display and sort fields
- Save reports of all formats for future use. Link reports to named lists or saved queries
- Format reports with page layout, fonts, colours, shading, headings and footings and label overrides
- Output listing reports to Adobe PDF (Portable Document Format) files
- Add totals, sub-totals, numbering and counts to columnar reports
- Suppress the report details (so only totals are printed) in columnar reports