Order Details By Event

Report Overview

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

Order Details By Event 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

▤

View Sample Report

Open the Order Details By Event PDF to see an example of the finished report, including department-organized product and order details.