Create a report that shows tickets that were canceled or replaced
Follow these steps to produce report that show details on tickets that were canceled and/or replaced
General Report Details
- Enter a name for the report
- Describe what the report is showing
- Select the Ticket Event Details view
- Select a template for the report. Using the A4 Landscape with 8pt Detail provides the most amount of space for a report
- Enter a name for the folder the report will be saved in
- Click on the next button
Add Columns and change formatting
1. Add the following columns to the report
- TicketNumber - The ticket number for the ticket that was canceled or replaces
- Event - The reason for the cancellation of the ticket
- EventTime - The time stamp that the event occurred at
- EventNotes - Any notes that were captured against the event
- Product - The primary product used in the ticket
- AmountDue - The total amount that was due for this transactions
- RefTicketNumber - The ticket number for the ticket that replaced the original
- EventTypeID - Link to the list of event types. This will be used to only show the canceled to ticket event types
2. Set the column widths as shown in the screen shot.
3. Set the format of the EventTime column to dd/mm/yy hh:mm
4. Hide EventTypeID as it is only used for filtering
5. Click on the next button
Sorting and Grouping settings
- Set the Event column as a grouped column
- Set the sort type for the EventTime column as Ascending and make sure it is number 2 in the sort order
- Click on the next button
Select the filtering for the EventTypeID column
- Check the Cancel Ticket Reason event type.
- Click ok
Review filtering setting
The Filtering page should appear as above.
Click on the next button when ready
Summary data settings
- Change the aggregate option for TicketNumber to COUNT so that the number of items in the group are shown.
- Except for the Event column set the remaining columns to a location of Detail only (no aggregate)
- Click on the Save button
- Click on the view button