Build Custom Report Filters
Example: either of two conditions
Use Any when either condition should include a record. For example, a report for bookings
that are either confirmed or cancelled should use Status is Confirmed and
Status is Cancelled in an Any group. If you put them in All, one booking would
have to match both statuses at once, so it would not match either condition.
Connected records let you filter by related information, such as a booking’s class or a
membership’s program. Follow the relationship in the picker, then choose the field to compare.
A related record can be unavailable because it belongs to another school or was deleted; its
details do not become visible merely because another record refers to it.

Search terms: