--- Main Sail Rule ------------

load(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 10
  ),
  /* getAllGroupsNames- Group Functions pulugin */
  with(
    local!getAllApplicationGroups: getallgroups(
      batchSize: local!pagingInfo.batchSize,
      startIndex: local!pagingInfo.startIndex
    ),
    {
      a!gridField(
        label: "Groups & Users Report",
        labelPosition: "ABOVE",
        totalCount: count(
          getallgroups(
            batchSize: - 1,
            startIndex: 1
          )
        ),
        columns: {
          a!gridTextColumn(
            label: "Group Name",
            field: null,
            data: apply(
              group(
                _,
                "groupName"
              ),
              local!getAllApplicationGroups
            )
          ),
          a!gridTextColumn(
            label: "User(s)",
            field: null,
            data: apply(
              rule!GetUsersFromGroup(
                _
              ),
              local!getAllApplicationGroups
            )
          )
        },
        value: local!pagingInfo,
        saveInto: local!pagingInfo
      )
    }
  )
)

-------Expression Rule || GetUsersFromGroup-------------

Input : groupName | Type Number

joinArray(
getdistinctusers(
  togroup(ri!groupName)
  ),char(10))