Crystal Report Filters with QQube | CLEARIFY

Filters are used to exclude or include information on a record by record basis, or on a group basis.  However, when a group is filtered, the underlying row details still exist.

Using the sales_(qqube10.x).rpt let’s create an appropriate static filter: only include inventory and assembly items. Choose the Filter Icon – for records.

Find Item Type in the list of fields, and click OK.

In the first list, choose ‘is one of’:

In the next drop down list, you will see a list of item types.  Choose Payment Item (or whatever item you don't want to show in your report).

This is the result.  Click OK when done.

Drag the Item Type field onto the report canvas:

When you run the report, Payment Items will now be filtered out.