I think the script is saying: show all rows from Groups where Group_Members.UserRecrodD contains (zoho.loginuserid)
I want it to say: show all rows from Groups where Group_Members.UserRecordID contains (User.RecordID)
list Copy_of_Groups_Report
{
displayname = "Groups I belong to"
show all rows from Groups [Group_Members.User.contains(zoho.loginuserid)]
(
Company
CompanyViaFetch
Group_Name as "Group Name"
Role
Group_Members as "Group Members"
(
view = Group_Members_Report
)
Group_Members.User
)
}