Now, it's time to do some experimenting with filters. We want to accomplish a couple of things through our experimentation. First, we want to get more comfortable with how filters are entered; and second, we want to see the effects of different types of filter structures and combinations. If we had a database with a large volume of data, we could also test the speed of filtering on fields in keys and on fields not in keys. However, the amount of data in the basic CRONUS database is small, so any speed differences will be difficult to see in these tests.
We could experiment on any report that allows filtering. A good report for this experimentation is the Customer/Item list. This reports which customer purchased what items. The Customer/Item list can be accessed on the role tailored client Actions menu via Reports | Customer | Customer/Item Sales.
When we initially run Customer/Item Sales, we will see just three data fields listed for the entry...