Part 4: Reports — Zoho Creator

. Earlier parts we created Vacation Request form, We imported employee information, we connected the already filled employee information to vacation request form using Lookup. This way we can avoid mis-entry of employee names and can maintain steady entry.
· In this part, we will learn how to create reports so that the manager will have an idea of which all employees have taken the leave, duration, their remaining leaves. This gives power to manager to manage employees leave effectively and also have track of his teams usability to work on backup when say employee A is on leave to access employee B as backkup.
· Lets create the report form.
· Go to Edit mode
· Top left below Dashboard is “Create New” — “Report”.
· In the report select the relevant fields like “Report Name” — report is for Vacation Request . So lets name it as Vacation Report. Report Type — “Calender” as we want to see the vacation details with calender for easy understanding. Report Based on — Of course the report will be generated based on Vacation Request, so select Vacation Request here.
· Where you want the report to be placed — Same form where the vacation request is generated. So select Vacation Request Form.
· Start Date & End Date & Display Field. Select Start date, end date & employee name respectively. This will help us to have Calender as report with employee names against the number of days of leaves from start date to end date.
· Once you click on “Create” you will see below image. Post that go to the live mode by clicking “Access Application” and the following image comes up with the details of which employee has taken leave from when to when.


· When you click on any of these banners, it will take you for more details. Give it a try.
This time live it to you to decide how difficult it is ;)
Those who missed earlier parts mentioned below fyr:-
Part 1: https://medium.com/@janakis13/vacation-request-app-13-short-steps-32c18b904e14
Part 3: https://medium.com/@janakis13/zoho-creator-part-3-connect-the-forms-for-validation-b365de091743
