Page History

Reports can be created using data from many tables and fields used on your platform, e.g., those related to products, orders, sales, etc. 

Step-by-step Guide

1. Create Report Field Groups

In order to create a new report, you first need to create report field groups. These form the criteria

for a report.

Report Field Groups are as follows: 

• What information you want – this is the 'Select Field Group' (Mandatory).
• In what case you want to get it – this is the 'Search Field Group'.
• In what order you want it displayed – this is the 'Sort By Field Group'.
• How the information should be grouped – this is the 'Group By Field Group'.

To create a Report Field Group:

1. On your website, go to Reports Design → Report Field Groups (zReportFieldGroup.aspx).
   
   
2. Click New.
   
   Image Modified
3. Choose a logical name for your field group code and name (e.g 'myReportSelect').
   
   
4. Click OK.
   
   
5. Click Fields.
   
   
6. Click New.
   
   
7. Select the required Table, a heading for the column, and the required field.

1. 
   Example:  a field group that displays all product codes:
   1. Table - Product
   2. Heading - Product Code
   3. Field – Product Code
      
      
2. Click OK.
   
   
3. Repeat Steps 7-9 as required

1. .