Report Recipe Filter

[nborrerojr.]

Is there a way to add a filter that can return only values where a relationship field is empty? I tried this but it doesn't seem to work.

<%filter%>((field[Category] = "My Category") and not (relationship.exists forwards using field["My Relationship Field"]))<%endfilter%>

I am able to achieve this by using <%beginrelationshipsdetailL2 My Relationship Field%> and  <%beginrelationshipsection none%> but I believe this is resulting in extra processing.

[nborrerojr. · Accepted solution]

Looks like you just do...

<%filter%>((field[Category] = "My Category") and (field["My Relationship Field"] = ))<%endfilter%>

It is a lot quicker than querying the relationship separately and using <%beginrelationshipsection none%>. Having nothing on the right of the equals sign seems kind of weird but it appears to be working.