I sent two fields from the main report into a subreport.
The subreport runs a separate query and filters results based on the selection criteria.

It's basically A or B, however the results I get only match those that satisfy condition A.

When I write B or A, it only matches those that satisfy condition B.

Condition A checks whether the argument is in an array (that is created on the spot), while condition B checks equality.

I'm not sure why it only matches one condition and ignores the other.

{?param1} in split({field1}) or {?param2} = {field2}

Field1 and field2 are both strings, except field1 has a specific format that I can split on.

Edited by Keikoku - 08 Jun 2011 at 10:18am

Tried that as well.

I tried some simpler conditions like {?param1} = "this" or {?param2} = "that" but even that resulted in the same behavior.

Can't imagine where the problem might be.
When switching the order of the conditions, I get two distinct set of results.

It's possible that my data is not actually what I expect though, but after checking it, doesn't seem to be the case.

EDIT: I decided to print out the boolean value in a formula and it definitely does seem to be checking only the first condition. At least, it doesn't print true when it should when the second condition is met.

Edited by Keikoku - 13 Jun 2011 at 3:43am