Reports with multiple tables from 1-2 objects

  • 28 February 2020
  • 3 replies
  • 8 views

I have a report that groups correctly and sorts correctly, but I can't seem to add all of the headers and content that I want.  IE:

 

Year header followed by

Event header followed by

list of attendees

 

I can get the results to group by year, then by event, but I can't get the template to show the year, then event, then attendees.  I have attached my template document and a screen shot of my DDP DocGen Package Relationship.  I've also attached what the results are.  Ideally, I would not have to manually add the year at the beginning of each set of results.  (the events are grouped by year, then in alphabetical order).  I have tried a ton of different template set ups and groupings and am at the end of my ideas.  Please help if possible.


3 replies

Userlevel 5
Badge +13

@himes are you trying to have multiple events under each table? Or are just having issues pulling the value for year in?


 

Thank you for getting back to me!  The report will have 3 years, with events that occurred in each year, with the attendees for each event.

Userlevel 5
Badge +13

Hi @himes,


 


Are trying to show each year and the events for that year in the same table.

Reply