Creation and display of song setlists I am using Drupal version 7.42 and a content type used for information regarding Concert setlists. It includes labels for:


Date.
Venue.
Location.
Setlist.
Description.
Lineup.


I will give you an idea of what I am looking to achieve in the end regarding its display. I also have a content type for the Songs.

Each performance listing will be different. I will have some listings that show Songs known to be performed yet the Setlist isn't complete. I will have some listings that show songs known to be performed in:


Set 1.
Set 2.
Encore.
etc.


Also, some performances may have more than one encore, so I also will have performances noted with Encore 1, Encore 2, etc. if the listing requires it.

How do I manage to get the display of the setlist to show a label above the songs indicating the song placement?

I thought having multiple fields in the content type (Set 1, Encore, Encore 1, Encore 2, etc) does the trick. But with time mulling over this one I am thinking is it possible to be achieved by just having one setlist field (Setlist) instead of multiple setlist fields in the content section? 

Below is an example of the display I am describing for site viewers to see when visiting a performance page. Each song listed in a performance page at the moment uses Entity Reference to link to its unique song within the Songs content type.


Set:


Song 1
Song 2
Song 3

Encore 1:


Song 4
Song 5

Encore 2:


Song 6



Any suggestions?
Below is a possible approach you may want to consider. It's using &quot;State&quot; names (like Florida, Illinois, etc.) instead of &quot;Set 1, Set 2, etc&quot; and &quot;Cities&quot; instead of &quot;Songs&quot;.
If I was to implement this in a Drupal site, I'd use either of these &quot;displays&quot;:

Option 1 - Master detail with nested blocks
Have a look at this example, which shows 1 &quot;block&quot; for each &quot;State&quot;, and within each &quot;block&quot; it shows the &quot;Cities&quot; (and one of its attributes) in that &quot;State&quot;.

Option 2 - Report that filters based on some lookup
Have a look at this example, which shows only the data about a specific &quot;State&quot;, together with all the &quot;Cities&quot; (and one of its attributes) in that &quot;State&quot;. To switch to another state, select the desired state from the Parameter form near the top (&quot;IL&quot; is used as the default in this example).


If you wonder &quot;How did you do that?!?!&quot; ... then this is the answer: that's really a piece of cake using the Forena module. Checkout the Community Documentation for details, and/or the documentation that comes with the module. The above 2 examples are actually delivered with the module (out-of-the-forena-box), though you probably don't notice that it is even not a typical &quot;Drupal database&quot;. It could be such database instead, but in this case it's an SQLite (sample) database (it could also have been Oracle, MS SQL, Postgress or any PDO compliant database).
Disclosure: I'm a co-maintainer of Forena.