Generating a report in ZC

Generating a report in ZC

I'm confused as how this works in zoho, is there an example or documentation on how to do something like this?


Say I have employees paid by job, where each job is paid by hour.

I'm a little lost as to where to create a report like this in Zoho Creator.

So I have a form/view like these:

Employees
---------------
ID
Name
Hourly Wage


Job
--------------
Employee (lookup Employee.ID)
Time Start
Time End
Status


I need a report like this for each Employee ... where user chooses Month/Year

Job      TimeStart        TimeEnd   Hours (TImeEnd - TimeStart)     Status      Wages (HourlyWage x Hours)
---------------------------------------------------------------------------------------------------------------------------------------------