We have multiple contractors and we want to show report data related for them only and don't want them to see other contractors rows.

Some contractors have multiple users so we can't use criteria something like [userid == zoho.loginuserid].

I need to fetch company name from user table.

Getting company info from userid is easy with a function like get_companyid(zoho.loginuserid).

But I got error when I try to use function in report criteria like [company_id = get_companyid(zoho.loginuserid)]

Is there someone who did something like this?

Thanks in advance.

atsuro