Selecting Data To Display |
Top Previous Next |
Looking at the initial display of a file can be rather intimidating. Often it includes far more data then you actually want to see, and it can be tiring scrolling back and forth across the screen to see the information. For this reason, the File Editor provides two methods for filtering your display data, and they can be combined to give you a great result.
Selecting Records ( rows ) to View
Enter a filter statement: This is a complex programming statement, and unless you understand the available xbase commands, you will not likely use this option. However, MasterLink technicians may use this to quickly locate specific information in a large database. For repetitive operations, we can provide you with statements to use. It is suggested you keep them logged into your system Notebook on a "Commands" page.
Select : Here you will build the filter statement by selecting the following information - •Field = The particular "cell" where the information is stored. Each field has a name as discussed in the System File Structures section of this manual. •Operator = The operator is a "comparison" tool. It will match the field to the specified data. The available operators are: = Equal < Less then <= Less then or equal to <> Does not include >= Greater then or equal to > Greater then •Data = The actual value you wish to use in the filter. This must be an exact value. Close is ignored by the computer.
When you press the Process Filter button, it will apply the filter and then you will only be viewing the selected data.
When you re-enter this option and press the Exit - Clear Filter button, your filter will be removed and all data will once again be displayed.
The filters do not change data so feel free to experiment with this feature.
Selecting Fields ( columns ) to View
Combining the filters
By setting both the Filter, and the Column display, you can fine tune your view and make it very easy to see the information you want without a lot of distraction. Resetting one does not reset the other. So, if you have selected only a few columns, and then you change the filter, the column selection remains in place until you change it. The "View" you have created with these filters is also in place when you export to a Report or Excel ( see next topic ). This process allows you to create some custom reports from a single database.
|