Selection of data for reports

Monitor Selection tab additional Features

Unique Cursor Behavior: If you do not place your cursor on a field in a Select tab, the first tab key or enter key you type will jump you back to the Criteria Set tab.

Data can be selected from the AQS database either by Geographical Criteria (Area Selection tab) or by Site-Monitor Criteria (Monitor Selection tab). Selection only by State/County can be done from either form. The differences in the fields between the two selection tabs are shown here. (Because of report design and database structure, some reports will not have all the fields available for selection shown here.)

$image\ebd_ebd16.gif$

Selection of data is done by creating a logical "phrase" from the selection criteria you have entered. The phrase is built using the following rules:

1. 1. "And" is placed between each field in a row

2. 2. "Or" is placed between each row in a block

3. 3. "And" is placed between each block

Note:

· · "And" is an addition to selection criteria making the selection more EXCLUSIVE. (At first glance this may seem counterintuitive.)

· · "Or" provides an alternative selection making it more INCLUSIVE.

$image\ebd_ebd17.gif$

So the selection shown above reads as follows:

((UAR = 0000 and in region 01) or (UAR = 0000 and in New York)) and LandUse = AGRICULTURAL.

In plain English we might say:

"All monitors listed as agricultural land use in New York or New England that are not in a UAR…"

The Monitor Selection tab has some additional features:

$image\ebd_ebd18.gif$

On the Monitor Selection tab the same fields appear in two different blocks. If Parameter, Method, Duration or Date selection criteria are put in the upper block they apply only to the Site-Monitor in their row. If the selection criteria are put in the lower "Global" blocks they apply for all. The form will not allow entries in both areas.

· · Once you put data in one of these common fields in the upper block you will not be able to put anything in the corresponding field in the Global block.

· · If you put data in the global block and then proceed to use the corresponding fields in the upper block the global fields will be grayed out. Graying out of fields indicates that the values remain but are IGNORED.

TO UNLOCK this feature, delete the data from the field, re-select the Report Code from the Criteria Set tab, (your other settings will not be lost) and then go back to the Monitor Selections tab.

When you request a stored Criteria Set, data will be placed in both selection tabs at that time. Subsequent changes made in a field common to both will not be reflected in the other selection tab. (In other words: Loading a Criteria Set and then changing dates in the Monitor Selection tab will not change the dates in the Area Selection tab.) Saving a criteria set will save only the values in the currently open tab. All other data on the inactive tab will be discarded.