Experimenting with filters

Now it's time for some experimenting with filters. We want to accomplish a couple of things through our experimentation. First, to get more comfortable with how filters are entered; and second, 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 which items. The

Get Programming Microsoft Dynamics NAV - Fifth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.