Navigation:  Working with Reports >

Report Setup Window

Print this Topic Previous pageReturn to chapter overviewNext page

The Report Setup window (shown below) allows the user to specify various reporting parameters.
 

Template Selector

This drop-down list (combo box) includes all of the reports (templates) in the report group. When you select a report via the Reports pull-down menu, or a report button, this combo box is automatically preset to the proper template. You can use the template selector to select a different report, or to print more than one type of report without closing the Report Setup dialog.

Header Information

The values in these fields are normally printed in the report heading area of the reports.

Report Title – This field will be preset to the default title stored in the report library.
Report Date – This field is preset to today's date. Changing this date will affect the effective date of the report and will return a report that reflects expiration dates based on the report date setting.
Revision – This field has no preset value since it is not utilized by any of the pre-defined standard reports. However, it is available for inclusion in custom templates or future standard templates.

Report Filters

The Report Setup area displays one or more Report Filter panels. The number of panels will vary, depending on the report you are printing. The filter panels come in four "flavors", depending on the type of information stored in the selected search field. They are:

Drop-Down List Panel – This type of panel is used to allow selection of specific records (e.g. selecting a specific pilot or aircraft).
Date Panel – This panel is displayed when filtering on fields which hold a calendar date.
Character Panel – This panel is displayed when filtering on fields which hold letters, numerals and other keyboard symbols.
Numeric Panel – This panel is displayed when filtering on fields which hold numeric values.

Drop-Down List Panel

 

 
This type of panel has a single drop-down list (combo box) containing specific records (e.g. pilots, aircraft, etc.). Simply select the desired record, or select "(Include All)" for all records.

Date Panel

 

 
This type of panel has five fields. The first field is a drop-down selector (combo box) presenting two choices:

is within – includes the records which match the date search criteria selected in the remaining fields.

is within or earlier – same as "is within" with the addition of all records dated earlier than the specified criteria.

is within or later – same as "is within" with the addition of all records dated later than the specified criteria.

is not within – includes the records which do not match the search criteria.

The second field (also a combo box) is for setting the date search option. The search options are described below. Some of the options require entry of additional information in one or more of the three fields to the right.

All Dates – This option defines a "null" date search and will include everything in the report regardless of date.

Fixed Range – Use this option to search for records dated within a specific date range. Enter the specific starting and ending dates in the date range fields on the far right.

This Month/Quarter/Year – Use these options to search for records dated within the current calendar month, quarter or year (respectively) based on the computer's clock.

Last Month/Quarter/Year – Use these options to search for records dated within the previous calendar month, quarter or year (respectively) based on the computer's clock.

First/Second/Third/Fourth Quarter – Use these options to search for records dated within the selected calendar quarter of the current year, based on the computer's clock.

First/Second/Third/Fourth Quarter – Use these options to search for records dated within the selected calendar quarter of a specific year. Enter the desired 4-digit year into the field to the right.

Past ... Days/Months/Years – Use these options to search for records dated within the past [n] days, months, or years (respectively) from the computer clock date.  Enter the number [n] into the field to the right.

Next ... Days/Months/Years – Use these options to search for records dated within the next [n] days, months, or years (respectively) from the computer clock date.  Enter the number [n] into the field to the right.

Calendar Year – Use this option to search for records dated within a specific calendar year. Enter the desired 4-digit year into the  field to the right.

January/February/ . . . December – Use these options to search for records dated within the selected calendar month of a specific year. Enter the desired 4-digit year into the  field to the right.

Character Panel

 

 
A character panel has a search option combo box, and a field for entering the search text. The character search options are described below.  Note that each search option has a companion  "negative image" choice which produces an "everything but" View.

is exactly like/is not exactly like – Use these options when you want to search for an exact character-by-character match between the field and the search text.

begins with/does not begin with – Use these options when you want to search for field entries which begin with the search text. For example, an Aircraft Type search with "LR" as the search text would match any of the following field entries: "LR23", "LR24", "LR25", "LR28", "LR29", "LR35", etc.

contains/does not contain – Use these options when you want to search for field entries which contain the search text characters anywhere in the field.

is in list/is not in list – These options are similar to the "contains" options above, except that the search text can contain multiple search items (separated by commas).

is empty/is not empty – These options are useful for locating missing or blank field entries. No search text is required.

Numeric Search Panel

 

 
A numeric panel has a search option combo box and either one or two search value fields (depending on the search option selected). The numeric search options are described below. Note that some search options have a companion "negative image" choice which produces an "everything but" View.

is any value – This option defines a "don't care" or "null" search.

is equal to/is not equal to – Use these options when you want to search one specific numeric value.

is less than – This option locates values which are numerically smaller than, but not equal to the search value.

is less or equal to – This option locates values which are numerically smaller than or equal to the search value.

is greater than – This option locates values which are numerically larger than, but not equal to the search value.

is greater or equal to – This option locates values which are numerically larger than or equal to the search value.

is between/is not between – These options locate values which are numerically larger than or equal to the first search value, and smaller than or equal to the second search value.

is empty/is not empty – These options are useful for locating blank entries. Important: A value of zero (0) is not the same as an empty or "null" field. This search option only locates the latter.

Command Functions

– This button opens the Templates dialog from which templates can be added, edited, re-ordered, or deleted

– Click this button to "run" the selected report. The report will first be displayed in the Preview window, from which it can be viewed and/or sent to a printer or other output device.

– Allows editing of report-related options in the Program Options Window.

 

 


Page url: http://ISBAOSolutions.com/index.html?report_setup_window.htm