0 Replies Latest reply on Oct 22, 2013 5:19 PM by Warren Bromfield

    Show Null and Max Date Filter

    Warren Bromfield

      Hi all, I have run into a serious problem with my report that I am unable to resolve.

       

      I am doing a join on two tables, I always want to see all the records in my left table but on my right table, I only want to show records where the date is the last date available, if i apply a filter on (max(Right_Table.Date)) i loose all my left records too. (i hope that make some sense)

       

      Any help is greatly appreciated!

       

      Regards,

      Warren