6 Replies Latest reply: Jun 13, 2013 12:28 PM by tapodevc RSS

    Reporting duplicate data

      All,

      I have a scenario like this:

      Two tables - Positions and BookRef

      Position table

      ==========

      BookQty
      B1600
      B2300

       

      BookRef table

      ==========

      BookDescription
      B1Test Book 1
      B2Test Book 2
      B2Test Book Two

       

      As you can see, if I join the two tables, I will have the B2 as duplicate as the refrence data has a duplicate. Like this:

      BookDescriptionQty
      B1Test Book 1600
      B2Test Book 2300
      B2Test Book Two300

       

      What I need to do instead is, show two reports -- one showing the non-duplicate data and other JUST the duplicate data as an exception. Something like this:

       

      Standard Report

      ============

      BookDescriptionQty
      B1Test Book 1600

       

      Duplicate Book Exception Report

      ========================

      BookQtyDescription
      B2300
      Test Book 2
      Test Book Two

       

      Is there anyway to do this?