I am trying to filter a report based on zoho.loginuserid.  I have the PM field in the Job_Number table to use as part of the filter criteria.  Basically, I put the following in the criteria area on the Report Summary:

PM equals emp_list.PM[zoho.loginuserid = = Email]

I run the report, the filter does nothing, and it deletes the criteria.  I'm sure due to an error or syntax.  Let me know if there is a better way to do this, is there a way to write a script for this in the report?

Thanks.