By default, all the entries in a Form will be displayed in the Report. By setting criteria to the report, you can create report for specialized reporting needs. For example, in a Sales Database, display only the sales made in a specific region or in an Employee database, display only the employees who have joined on a particular date. The Criteria can be set from the GUI or by writing Deluge Script.
To view the entire list of criteria, click here.
To restrict a user from viewing records entered by other users, a Criteria should be set for the report . When the following criteria is set for the report, only the records added to the database by the user who is currently logged in into Zoho Creator is displayed in the Report.
Note:Please note that if users can access the form and enter data without logging into Zoho, then this criteria will not deliver the desired results. In addition to displaying the records entered by the user who is accessing the report, the records entered by users who entered data without logging into Zoho will also be displayed.
The criteria specified in the GUI will be added to the report definition. You can view the definition by selecting Report Settings -> Definition. For example, the screen-shot given below is the report definition of the report named "Employee Joined on Febraury" whose criteria we defined in the GUI.