dyb

Report that doesn't repeat values at every occurrence

Discussion created by dyb on Aug 25, 2016
Latest reply on Aug 25, 2016 by 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.

Outcomes