Non mandatory user prompt filters in a Freehand SQL report?
I have some complicated queries that I only how to do in a Freehand SQL report - such as a "SELECT * FROM table WHERE column IN (SELECT column FROM B WHERE blah)"
The problem I have with Freehand SQL reports are the filtering. I have several non-mandatory user prompt filters, some equal to and some in list. Is there a way to create a filter like that in a Freehand SQL report, where it doesn't have to be filled out? Everything is all from the same table, so it wouldn't require joining to any new tables if a filter was or wasn't filled out.