Recollector User’s Guide


Generating Printed Reports (with a wizard)


This section describes how you can easily generate a printed report, for your entire collection or for a subset, and customize the report to fit your needs.  This is done using a “wizard” invoked by selecting Generate Printed Report (with wizard) from the File menu.


A printed report consists of three sections:


1)      A cover page.

2)      The body of the report, containing entries for all the records.  This section will have as many pages as needed, with each page printed compactly, containing as many entries as will fit.

3)      [Optional] A summary for currency-type fields, listing totals for those fields across all the records in the report.

4)      [Optional] One or two indexes, allowing you to index the entries in the report by one or two of the database’s fields.


Here is a view of what the main part of the report (the body) looks like, with a thumbnail image of a single page on the left, and a full-sized view of a couple of entries from that page on the right:


This example shows several features of the report that reflect its compact format:

After you pick Generate Printed Report (with wizard) from the File menu, the wizard window will be shown. The wizard takes you through a sequence of steps, letting you provide the information needed to configure the report you want. The following illustrations show the sequence of pages displayed by the wizard. You move from one page to the next by clicking on the Next button. You can also use the Back button to go back to an earlier step to modify selections made earlier. Only when you get to the last page is there a Finish button that will start the actual processing and printing of the report.

Initial wizard page (introduction):

Wizard page for step #1:

Choose whether your report will cover your entire collection, or just a specified subset. (If you have not defined any subsets for your collection, this page will only allow you to report on the entire collection.)  Note: If a search subset is currently in effect, it will not have an effect on the records chosen for inclusion in the report. Only regular subsets can be used to limit the set of records included in a report.

On this step, you can also choose the font size that will be used in printing your report. The font family used in the report will be the same as the display font currently used by the Item Details view.  This font can be chosen from the Item Details tab of the Preferences dialog.

You can also specify a header image. This image will be displayed centered in the upper margin of each page of the report (except for the cover page, where the image will be shown near the bottom of the page).  The header image allows you to decorate or “brand” the report by putting a standard illustration (perhaps an icon, or a styled text title) atop each page. Because the upper page margin is a thin, horizontal area, it makes sense to choose an image that is horizontal in shape.  For example, the following image is appropriately shaped to be used as a header image:


You can use any of the standard image file formats (jpg, gif, png, etc.) for the header image.  The header image is taller than 48 device-independent pixels, it will be scaled to that height, so that it fits in the header margin.

Wizard page for step #2:

Choose which fields to include in the report's entries, and also choose the order in which the fields will be listed within each entry.

Once you are familiar with generating reports and have found a report format that you are happy with and that you expect to re-use in the future, it makes good sense to define a Field Profile that reflects the set of fields (and their order) that you want to use in your reports.  (See the section on Creating and using Field Profiles for details on how to define a Field Profile.)  Once you have created an appropriate Field Profile, it is easy to complete this step in the wizard: Just select the fourth radiobutton and then select the particular Field Profile from the drop-down list.

This page in the wizard also lets you make some choices for images. If your selection of fields contains any image fields, these will be displayed as thumbnails in the report. In general, images are self-explanatory and so there is usually no need to show a label (with the field name) in front of each image. If, for any reason, you do want to include field name labels for images, turn off the Omit field labels for images checkbox. This page is also where you specify the maximum height and width for thumbnail images in the report.

Wizard page for step #3:

Choose how you want the entries in the report to be ordered. You can either use the current sort order of the List view, or you can choose any field as the sorting field (whether or not the field is one of those selected, in the prior step, for inclusion in the report’s entries), as well as choosing ascending or descending order.

Wizard page for step #4:

If you want your report to contain indexes, specify that here. Each index will be in the form of an alphabetized list, one line per entry, showing the value of the chosen index field, along with the corresponding entry number in the report and the page of the report on which the entry begins. (Each entry in the report is numbered in the left-hand margin, as can be seen in the example at the top of the page.) You can also request that the index show the value of the ID # field (in addition to the index field and the entry number). The following image shows part of a page containing an index:

Note that if an entry’s value for the index field is too long to fit on a single line, the index entry truncates the text and appends ellipses (…).

At the bottom of this page in the wizard is a check box that lets you specify that a summary page be included in your report. On this summary page the totals for all currency-type and number-type fields will be listed.  (Only currency-type fields and number-type fields that are among the fields chosen for inclusion in the report will be shown.  If you have a currency or number field that was not selected for inclusion in step #2 of the wizard, that field’s total will not be listed.)  The totals are computed across all the records included in the report, so if you are reporting on a subset, the totals are just for those records that are included in the subset.

Note: Totals for currency fields will be treated in a special way if your collection contains a number-type field whose name is Quantity* (exactly as shown here, with capital ‘Q’ and an asterisk as the last character in the field name). If a Quantity* field exists, then its value will be multiplied by the currency field’s value in calculating totals. This allows you to handle the case of a collection with multiples, by having just a single record for the set of duplicate items, with the number of duplicates specified in the Quantity* field.  The currency field should reflect the price/value for just a single item, and the computation of totals will be done by multiplying the currency value by the Quantity* value.  (If Quantity* is left blank in a record, a default value of 1 will be assumed.) The multiplication by the Quantity* field value is only applied to currency-type fields, not to number-type fields.

The currency/number-field summary page is printed immediately after the record-by-record section of the report and just before the indexes.

An additional check box at the bottom of this page in the wizard lets you request that each record start on a new page in the report.  By default, the program will put more than one record on a page, as long as the last record on the page still fits entirely on the same page. But if you want each record to be printed on its own page (or pages, if the record doesn’t fit on a single page), then turn on this check box.

Generating the report

After you have gone through the pages of the wizard and made your choices, click the Finish button. The program will ask whether you want to proceed to a full run, or whether you would like to generate just one page, as a test of the choices you have made:

As you can see from the information displayed in this dialog, if you request a test page, then only the first page of the report (excluding the cover sheet, and excluding the currency/number-field summary page and any index pages) will be printed. After printing the test page, the program will ask you whether to go ahead and execute a full run, or whether to re-enter the wizard to make adjustments to your choices. If you choose to go back into the wizard, all of the choices will be as they were when you previously completed the wizard's steps, so you will only need to make selections for anything that you now want to change. On pages where no changes are needed, just click Next to move to the next page, and repeat until you get to the last page and can click Finish.

A few hints for generating printed reports:

Back to: Using the Collection

Back to: Recollector - Home Page