The Order Details By Event report provides a detailed listing of products ordered for a selected event, organized by department. It includes booth and exhibitor information, order details, delivery dates, and optional pricing, with flexible filtering and grouping options.
Description
The Order Details By Event report lists products ordered within a selected event, organized by department. It is similar to the Booth Check List report but offers additional options, including displaying pricing and grouping results by location or revenue type.
The report's flexible filters make it useful for reviewing orders, identifying product usage, and tracking delivery information throughout an event.
Report Details
Common Uses
Use the report to identify which booths have ordered one or more specific products by selecting those products in the Product(s) filter.
You can also review products ordered by individual exhibitors and compare their delivery status, delivery dates, and pricing.
Report Organization
The detailed grid is organized by department, following the department display order configured for the store.
Within each department, the report displays products with their associated booth number, exhibitor name, order number, onsite contact information, and delivery start or pickup time.
You can group results by location or revenue type, sort by booth or exhibitor name, and optionally insert page breaks between booths.
For a simpler report without the additional pricing and grouping options, see the Booth Check List.
Report Example
Available Filters
Use the following filters to customize the products, delivery information, grouping, and level of detail included in the report.
| Field Name | Available Values | Default |
|---|---|---|
| Event | All events in the store | None |
| Delivery Status | All Not Delivered Delivered |
All |
| Delivery Start Date | Any date | First date of the event |
| Delivery End Date | Any date | Last date of the event |
| Group By | None Location Revenue Type |
None |
| Revenue Type(s) | All revenue types in the system | All revenue types |
| Sort By | Booth Exhibitor Name |
Booth |
| Product(s) | All products being used in the event | All products |
| Page Break Between Booths | No Yes |
No |
| Print Product Codes | No Yes |
No |
| Print Pricing | Yes No |
Yes |
| Customer Types | Exhibitor EAC Show Organizer |
All |
| Items Modified Starting | Any date or date and time | Beginning of time |
| Items Modified Ending | Any date or date and time | Now |
| Suppliers | All active suppliers | All suppliers, subject to user permissions |
Filter Details
Event: Select the event for which order details should be displayed. All events in the store are available, and no event is selected by default.
Delivery Status: Determines whether the report includes all items, only items that have not been delivered, or only delivered items. All is selected by default.
Delivery Start Date and Delivery End Date: Define the delivery date range included in the report. By default, the range covers the first through the last date of the selected event.
Group By: Determines whether results are grouped by location or revenue type. Select None to use the standard department organization without additional grouping. None is selected by default.
Revenue Type(s): Allows you to limit the report to selected revenue types. All revenue types are included by default.
Sort By: Determines whether results are sorted by booth number or exhibitor name. Booth is selected by default.
Product(s): Allows you to select specific products to include in the report. All products being used in the event are available, and all are included by default.
Page Break Between Booths: Determines whether each booth's information begins on a separate page. No is selected by default.
Print Product Codes: Determines whether product codes appear alongside product information. No is selected by default.
Print Pricing: Determines whether pricing information appears in the report. Yes is selected by default.
Customer Types: Allows you to include or exclude Exhibitor, EAC, and Show Organizer customer types. All are included by default.
Items Modified Starting and Items Modified Ending: Define a modification date and time range. Only items modified within the specified range are returned. By default, the range extends from the beginning of time through now.
You can enter a date alone or include a specific time, such as 3/11/2012 8am through 3/11/2012 3pm.
Suppliers: Allows you to filter results by active supplier. All suppliers are included by default, subject to the user's security permissions. Some users may only see information associated with their own supplier organization.
Tip: To identify booths that ordered a particular product, select that product under Product(s) and use Sort By: Booth. To prepare separate booth-level reports, set Page Break Between Booths to Yes.
Sample Report
Open the Order Details By Event PDF to see an example of the finished report, including department-organized product and order details.