The Filter screen is used to created a view of the data with only the record / fields the user wants.
The important parts of the screen are:
This section of the screen has 2 functions
This section of the screen allows you to select which fields will be displayed (using the Include Check box).
Clicking on the record PriceR 1 (in the record filter above) will display the fields of record PriceR 1.
|Field Value Filter||
This section of the screen allows you to select which record will be displayed based on record content.
In the above example, only records where the field Product contains 12 and Description contains t will be displayed.
Clicking on the record PriceR 1 (in the record filter above) will alloy you to enter Data-based filters for PriceR 1
You can enter up to 4 data filters per record type. A record must satisfy
all filters (i.e. a logical And) to be displayed.
You can create very basic reports by combining Filtering (see "Filter Screen") with the Save-As / Export Function (see ).
With the AMS-PO file which consists of
It looks like this:
you can select specific fields of the PO header by entering:
This will produce a filtered view like
To save as a HTML file, select the Export button, then enter the following on the Export Screen:
This will produce the following HTML
|Line||8 : 10|
|18 : 12|
|30 : 6|
|48 : 4|
|52 : 6|
Expected Receipt Date
|87 : 2|
|RecordEditor at SourceForge||Download Page||Forums|