I read Michael's Discoverer Blog about outer join issues in conditions.
I think that the reason it does not seem to work for me is that the field, Apply Date, in the condition that I am trying to use (Apply Date between :FromDate and :ToDate) is in a folder which is a Master Folder in one join and a Detail Folder in another join.
I have tried adding a calculated field and adding a condition that the "calculated field = 1 or the calculated field = 1". I also tried using the field <> 0.
I still am getting the rows that I want along with other rows the Apply Date blank.
Can anyone help?
Edited by: user476771 on Apr 28, 2013 1:58 AM
Another point: in the join where the field Apply Date is the Detail folder, none of the Master Folder fields are in the report.