In my data, I have a list of records (for example, let's say the table is "Genre" and I have a record where the "Name" is "Pop Music"). These records have related records on another table (for example, let's say the table is "Song" and I have records where the "Name" are "Dancing Queen" and "Bye Bye Bye").
If I report on the Genre table, I know how to set a filter to say, for example, only Genres that have a certain number of songs associated, or songs with a certain title. Or, if I report on the Songs table, I know how to search on the related records for a particular genre.
But, what I need to do is create a report where the songs are grouped by the genre. I can't figure out how to have a view where I can see all the songs, grouped on their genre based on this data structure. I have no control over the data, so have to work with the way it's structured. Hoping there's something easy here that I'm overlooking!
