4 Replies Latest reply: Apr 29, 2013 7:54 AM by user476771 RSS

    URGENT: outer join issues


      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.