Click on the create report button to start creating a report

1. Enter a name for the report
2. Describe what the report is showing
3. Select the Product Sales view
4. Select a template for the report. Using the A4 Landscape with 8pt Detail  provides the most amount of space for a report
5. Enter a name for the folder the report will be saved in
6. Click on the next button

1.    Add the following columns to the report

• ProductName - Name of the product used in the transaction
• TicketNumber - The ticket number that appears on the docket
• DateOut - The data and time the transaction was completed
• ClientName - Name of the client
• LicensePlate - registration of the vehicle used in the transaction.
• Quantity - The number of units delivered of the product
• ProductStockUnit - The stock unit for the product.
• TotalPrice - The total amount charged for the transaction/
• ProductID - Link to the list of Products.
• ClientID - Link to a list of clients.

2.   Set the column widths as shown in the screen shot.

3.   Hide ClientID  and ProductID columns as they are only used for filtering

4.   Remove the header for the ProductStockUnit column.

5.  Set the Alias for some of the columns to improve readability

6.   Click on the next button

1. Set the Event column as a grouped column
2. Set the sort type for the DateOUt column as Ascending and make sure it is number 2 in the sort order
3. Click on the next button

Set the DateOut , ProductID and ClientID as Allow Filter. then click next

1. Change the aggregate option for TicketNumber to COUNT so that the number of items in the group are shown.
2. Except for the Qty and TotalPrice column set the remaining columns to a location of Detail only (no aggregate)
3. Click on the Save button
4. Click on the view button

The report can now be run with current data.

1. Set the DateOut criteria to a period the report needs to be run for.
2. Generate the report