QUESTION

A report designer report should contain some complex filter criteria, that cannot be entered in the normal way (i.e. compare single field with value or other field). How can this be achieved?


RESOLUTION

In many cases, it is possible to add a custom field using a complex SQL query to the data collection. The complex filter criteria could be built into this custom field, e.g. it evaluates to 1 when there is a match and 1 if not. Then add a basic filter referring to that custom field, comparing it to 0 or 1.