When creating a report in report builder it may generate a large amount of output. You can add filters to focus on just the information that meets specific criteria. Sometimes you may wish to just report if any data exists in a specific field or if no data exits i.e. the field is empty. There are two filter types available for number and decimal fields that will allow you to do this:

• Is Empty
• Is Not Empty

The type of filter will depend on the field you wish to filter on e.g. text, date or number. In the case of a field containing a number there are filter types to compare the recorded data with a criteria or value entered in to the filter including:

• Equals
• Not equal
• Greater than
• Less than

and so on.