This tutorial demonstrates how to create a report containing selected observations from your FieldNotes dataset. Automated reports provide a quick and easy way of summarising important observations (and related information) for distribution to interested parties.
Before starting you will need to know ...
This tutorial assumes that your FieldNotes database contains a number of observations (or sites) that you wish to use as the basis for a report.
Creating a new report is a very straightforward process that at its simplest requires no more than specifying a suitable output filename.
The fields used for creating a Report are combined into a propertysheet - a collection of tabbed forms grouped on top of each other. The quickest way of opening the 'Report' forms is to select the
button from the main toolbar.This step initialises relevant fields using values based on your current session and displays the 'Report' propertysheet on the screen.
The report propertysheet includes of four forms (General, Cover, Content, Advanced) with options to control the appearance and content of your report. Although each separate form includes a number of fields, most are preset with sensible values that will generate a 'standard' report. As you need to generate more specific reports you may choose to modify the layout and content more precisely.
Sections 1-5 below describe the steps in completing the Report wizard.
The 'General' propertysheet form contains the most important information about the report. The fields allow you to specify the location of the report file, the scope of the report (ie. how much detail it will include), and the overall 'look and feel'.
Field | Notes | |
---|---|---|
File location | Path / name of the report file. | |
Level-of-detail | Report detail (number of fields described). | |
Displaying values | Preferred method for displaying data values in the report. | |
Missing values | Text used for missing values in the report. | |
Report display | Method for displaying report on completion (if req'd). | |
Overwrite warning | Display a warning message if existing files will be overwritten. |
The default report file is named 'fieldnotes_report.doc' and is located in the 'FieldNotes' folder in 'My Documents'. If you wish to use an alternative location / filename either:
The level-of-detail setting affects which fields are included in the report; for example, if the level-of-detail is 'Quick', then only the fields that are visible in data-entry forms when displayed in 'Quick' mode will be written to the report.
Overall this controls how much detail the report will contain, and should be chosen carefully according to the intended audience for the report.
The control is initially set to your working (current) level-of-detail.
This setting determines how database values will appear in the report - either as plain text or wrapped in single quotes. The preferred style is a matter of personal choice, affecting only the overall 'look and feel' of the final report.
The default setting is to wrap data values in single quotes, distinguishing them from explanatory text in the report.
This setting determines how empty fields (ie. those where data is not available) are displayed, again affecting the 'look and feel' of the final report.
The default setting is to label empty fields as 'No information'; however this can become tedious if a high level-of-detail is chosen.
After creating the report, it is highly likely that you will want to examine its contents to check that it meets your requirements. Use these checkboxes to choose which application (if any) you want to use to display the report.
This checkbox (which is selected by default) will ensure that a warning message is generated if you attempt to overwrite an existing file.
The information from the 'Cover' form is used to create the frontispiece (header section) of the report. The frontispiece includes the title, author and a brief description of the contents, within a mosaic of wildlife pictures.
Field | Notes | |
---|---|---|
Title | Report title. | |
Author | Author of the report. | |
Summary | A brief description of the contents. | |
Display options | Footer 'signature' |
Choose a suitable title for the report. The initial value is set from the title / owner of the FieldNotes database; however if only a small subset of the records are selected this may not be representative of the report contents.
Check the author of the report is correct - this field is initially set to the current user (not the FieldNotes database owner).
Include a brief summary of the report - this may relate to aims, content or other aspects of the report.
Include a report footer containing FieldNotes application information.
The settings on the 'Content' form are used to choose which records will be included in the report, and the order in which they should be listed. Field-based filters may be applied separately to each table (Observations, Sites, Localities, Surveys) to ensure that only appropriate records are published.
Field | Notes | |
---|---|---|
'Observations' record filter | Filter settings for inclusion of records. | |
'Sites' record filter | Filter settings for inclusion of records. | |
'Localities' record filter | Filter settings for inclusion of records. | |
'Surveys' record filter | Filter settings for inclusion of records. | |
'Observations' record ordering | Field by which records are ordered | |
'Sites' record ordering | Field by which records are ordered | |
'Localities' record ordering | Field by which records are ordered | |
'Surveys' record ordering | Field by which records are ordered |
The listbox displays a list of the filters which will be applied to Observations table, affecting which records will be included in the report.
A record must meet all separate filter criteria (a filter is displayed on a single line and may include a number of criteria) to be accepted. However where multiple filters are used (displayed as separate lines in the control), a record only needs to pass any single filter to be included in the subset.
The bottom line of the Record filters box shows the number of records which meet the filter criteria, and also the total number of records tested. These provide an important indicator of the final report contents.
FieldNotes automatically implements 'baseline' Observation and Site filters for reporting purposes. Both filters are intended to:
These initial filter settings, which protect your most sensitive data and avoid copyright issues, may be amended or deleted as required.
To update the filter settings:
The Filter tool help pages contain a more detailed description of using the filter tools to select an appropriate subset of records.
The listbox displays a list of the filters which will be applied to Sites table, affecting which records will be included in the report. See section 3.1 (above) for description.
The listbox displays a list of the filters which will be applied to Locality table, affecting which records will be included in the report. No filters are set initially. See section 3.1 (above) for description.
The listbox displays a list of the filters which will be applied to Surveys table, affecting which records will be included in the report. No filters are set initially. See section 3.1 (above) for description.
This field is used for ordering Observation records (numerically or alphabetically) in the report. Options are 'Species name', 'Date', 'Site name' or 'Survey name'.
This field is used for ordering Site records (numerically or alphabetically) in the report. Options are 'Site name' or 'Locality name'.
This field is used for ordering Locality records (numerically or alphabetically) in the report. Options are 'Locality name' or 'Access'.
This field is used for ordering Survey records in the report. The only option is 'Survey name'.
Information on the 'Advanced' form is used to set certain attributes the report (not normally visible) which affect how the report is interpreted electronically (for example, if published on the internet). The information is encoded as meta-tags in the report document.
Field | Notes | |
---|---|---|
Document Title | Publication title. | |
Document Owner | Publication owner. | |
Document Description | Brief summary. | |
Document Author | Publication author. | |
Keywords | Keyword list. |
The initial value is set from the title / owner of the FieldNotes database from which the report is generated. The publication title may differ from the report title (section 2.1), particularly regarding additional information about scope (start/end dates etc.).
The owner of the report (and generally of the report data). This field is initially set to the FieldNotes database owner (not the current user).
A brief summary of the report, suitable for creating a catalogue entry.
The author of the report - initially set to FieldNotes software application.
A list of relevant keywords describing the report, for use by search engines / information-retrieval systems.
Take a moment to check that the report type you have specified matches your distribution requirements.
Pressing the
button will generate a report based on the information and settings provided. FieldNotes will carry out a number of internal consistency checks on the values you have entered, and warn you if changes are required, for example if the report is empty (ie. no data records have been selected).The Report is now saved as a file on your computer for reference or distribution.
Error / Warning Message | Cause | |
---|---|---|
Error | No Observation / Site records selected for export | Filter settings prevent any records from being published. |
Warning | No Observation filters set - potentially sensitive records will be exported | Review Observation filter settings to ensure that private records are not disclosed. |
Warning | No Site filters set - potentially sensitive records will be exported | Review Site filter settings to ensure that private records are not disclosed. |
See relevant sections above for details of valid values.
If the 'Show completed report' checkbox (in the 'General' form) was checked, the report will be displayed on your computer after it has been generated. Otherwise locate the report file that you specified and open it.
Take a moment to examine the contents of the report, and check that the content and format match your expectations.
If required, the report may be updated using a suitable editor (eg. Word); however you should maintain a list of changes to ensure that you do not overwrite them when creating a new report.
The underlying report format adheres to the HTML specification and may be linked from your website or social media pages. However you may find that FieldNotes web-report offers a more web-friendly document style for publishing your observations on the internet.