The following examples of some Custom Reports may help you to understand how to write a Custom Report.


1.  Example of how to select a list of Customers with names between aaa and hhh.
 
    



  2. Example of how to select Employee Surname, First Name and Clock In times between 20 July 2014 and 22 July 2014, sorted firstly by Surname and then by First Name.
 
   


 

3. Example showing Job Number (Job Our Reference) and the Product in each Job.  As the Distinct check box has been selected, each row returned will be unique (i.e. repeating rows will not be shown).