3 Replies Latest reply on Aug 25, 2016 6:37 AM by dyb

    Report that doesn't repeat values at every occurrence

    dyb

      I have data that looks mostly like this:

       

      tables:

      - "pictures"

      - "description"

       

      table "pictures" fields:

      - "id"

       

      table "description" fields:

      - "id"

      - "id_pictures" // to connect descriptions to pictures

      - "itemName" // what is in the picture

      - "itemSubName" // second part of the name

      - "itemCount" // how many?

       

      "itemName" is repeating very often so across 100 records i have 10 different names

      "itemSubName" is only 3 different names

       

      Now i want to create a report that shows:

       

      "itemName" #1    // all occurrences of itemName summarized into one group

                "itemName" & "itemSubName"     "itemCount"

                "itemName" & "itemSubName"     "itemCount"

                "itemName" & "itemSubName"     "itemCount"

      "itemName" #2

                "itemName" & "itemSubName"     "itemCount"

                "itemName" & "itemSubName"     "itemCount"

                "itemName" & "itemSubName"     "itemCount"

       

      etc...

       

      Please point me in the right direction.