This is kind of an obvious question, but I was wondering how to use an OR statement in Report Studio detail filters. It seems that when adding multiple detail filters for a query, Cognos will always insert an AND between them in the SQL it generates.
For instance, I want to build a query with two criteria, A and B. If I place the expression for criteria A in one detail filter and the expression for criteria B in a second detail filter, the resulting WHERE clause will be A AND B. However, I'd like the WHERE clause to be A OR B. One idea is to place the expressions for A and B in a single detail filter with the OR placed between them manually. This works, but it makes for maintaining filter expressions kind of messy. Are there other options I'm missing? It seems Query Studio has a much more elegant way to group filtering criteria into numerous combinations of AND's and OR's.
That's pretty much it if you are looking for simplest way.