Report Lava for Small Group Leader

The following Lava will allow you to pull the small group leaders name of anyone inside the data view.

This will require a column in the report titled "personid" which I would not show in the grid.

Next create a column titled "Group Leader Name" and paste in the following inside the Template.

**Note the Groups: "38" = our Adult Small GroupType ID, this can be changed to whatever Group ID you want to search.**

{% assign groupMembers = personid | PersonById | Groups: "38",'Active' %}

{% for groupMember in groupMembers %}

{% assign group = groupMember.Group %}

{% for member in group.Members%} {% if member.GroupRole.IsLeader == 'true' %}

{{member.GroupRole.Name}} - {{member.Person.FullName}}

{%endif %}

{% endfor %}

{% endfor %}

*credit to: Kevin Rutledge for helping with the Lava