Overview

Consolidation Reports are reports that show registrations, charges, payment and refunds, transactions, contacts, and location data across multiple events in the current account, and optionally from all sub-accounts if the account has any.

Consolidation reports return records only for live registrations, not for test registrations.

Access and Basic Tasks

Access via: Events > Consolidation > Reports
Add Report: To create a new custom consolidation report, open this page by clicking Add Report on the Events > Consolidation page in an account.
Add Report note: The options shown for a new report, especially the Report Types, may depend on modules enabled for the account.
Edit: To edit an existing custom consolidation report, click the icon in the Actions column for that report on the same Events > Consolidation page.
Edit note: The options shown may depend on the modules enabled, but you may not change the Report Type when editing.

About Reports

To create a report, complete the information described in the sections below and click Save.
Cross-reference: For additional information, see How do I perform common tasks in the reports area?
To preview the report, click Run Report at the bottom of the page.
To delete a report that has been saved, click Delete at the bottom of the page.

Left Navigation Panel

Custom reports are configured using several pages. After saving a new report from the Setup page, the Left Navigation panel includes links to these other pages; go to each one to complete the configuration.

| Page | What It Does | | Setup | This page sets the name, description, and visibility of the report. | | Display | Sets the report's output type and printer settings. | | Groups | Enables you to specify up to three summary groups for organizing reports in printable formats (HTML and PDF). | | Subtotals | For reports that display numbers, the Subtotals area enables you to set the automatic display of totals on the report. Works for reports in printable formats only (HTML and PDF). | | Columns | Configures the specific data fields that will be displayed on the report. | | Filters | Enables you to filter data based on up to two separate date criteria and up to six general data field criteria. | | Page | Enables you to create custom report headers and footers that include HTML formatting and dynamic data fields. | | Export | You can select up to three Mass Actions to apply to all records when the report is exported. | | Custom | You can define up to 20 user-defined columns per report. |

Report Name and Visibility

Report Name (Required): Enter a name that makes it easy to identify the report by title.
Description (Optional): Enter a brief description with more information about the report.
Report Group: To make reports easier to review, group them as needed. The group name appears as a subheading on the Consolidation Reports page. To create the first group, enter a group name in the text entry field. After one group is created, you can select an existing group from the Group drop-down list or create a new group.
Visibility: This section shows options based on previous selections.
Current Account only: The custom report is available to users within the current account and shows only the applicable Custom Profile and Custom Event questions for that account.
All Accounts: The custom report is available to users within all accounts, but will not show any Custom Profile Question, Custom Event Question, or Custom Registration Question column group.
Note: Once one of the previous options has been selected and the report has been saved, the setting cannot be changed.
Show to selected user only: If selected, choose a single user to grant access to only that user.
Private Report: By assigning a report to an individual user the report becomes a Private Report and is displayed on the Consolidation page with a superscript P at the end of the report name. Other users cannot see, edit, copy, or run the report, even if they know the report URL. Private reports should be for a specific meeting planner, since no other users can access it, except System Administrators who have access to view and edit all private reports.
Include in 2.0 API EVENT object response: Applies only if the account has 2.0 API enabled.

Report Data and Tokenization

Report Tokenization: This section is available only if Enable Report Tokenization is selected under the Account/Event Report Module. It appears only after you save a new report or while editing an existing one. This section lets you generate a unique link to a version of the report which restricts data access. You can make access read-only or allow mass actions. You can also choose whether to allow data export. Use this to share the report with someone who is not a Certain user, such as an event sponsor or supplier. Full details of Report Tokenization.
Report Data: When you first create a report you must select one of two data options to specify the data included in reports.
Current Account Only: The data in the report comes from all events in the current account, but not from any sub-accounts.
Current Account and All sub-accounts: The data in the report comes from all events in the current account and from any sub-accounts it may have (and from any sub-accounts that they may have, and so on down the hierarchy as deep as it may go).
Note: Report Visibility is independent of Report Data.
Example: A System report is set up in Account A with visibility for all sub-accounts, and report data is set to include all sub-accounts.
Example: Account A has sub-accounts B, C, D, and account B has sub-accounts B1, B2.
Example: If this report is run from within Account A, it returns data from Accounts A, B, C, D, B1, and B2.
Example: If the user changes to Account B, the user is able to see the same system report in account B's Consolidation Reports, and when they run it there, the report returns data from Accounts B, B1, and B2.
Note: Report Visibility is independent of Report Data.

Report Type

When you first create a report you must specify the Report Type (the default is Registrations Across Events in the Registration Reports group). The report type determines the rows of data that are returned by the report.
The report type cannot be changed once a report has been saved, so the options are not shown if you are editing an existing report. If you wish to change a report's type, you need to create a new report instead.
The available report types are as follows:

Available Report Types

| Report Category | Report Type | What It Does |

| Consolidation Reports | Registration Contacts | Reports on Registration Contacts and the events they are assigned to. Returns one row of data per registration contact. |

| | Documents | Returns one row of data per document. |

| | Events | Reports on events within the current account, including their registration contact and location. Returns one row of data per event. |

| | Locations/Venues | Reports on Locations/Venues/Hotels and the events they are assigned to. Returns one row of data per event. |

| | Meeting Requests | Returns one row of data per meeting request. |

| Registration Reports | Registrations Across Events | Returns one row per registration per event. |

| | Registration History Across Events | Returns one row per registration change per event. |

| Travel Reports | Registration and Travel Across Events (Requires the Travel Module.) | Returns one row per registration per event. Columns and filters can include Travel Custom Questions. |

| Check-Ins | Check-Ins Across Events (Requires Certain Check-In) | Returns one row per registrant per check-in. |

| Financial Reports | Charges Across Events | Returns one row of data per charge for registrations that have charges, plus one row per registration for registrations without charges (when no Filters are applied). |

| | Invoices Across Events | Returns one row of data per invoice, for one or more events. |

| | Payments and Refunds Across Events | Returns one row of data per payment or refund. |

| | Transactions Across Events | Returns all charges, payments and refunds for registrants that have these transactions, plus one row for each registration that has no such transactions. |

| Agenda Reports | Registration Agenda Across Events | Returns one row of data per agenda item (activities, sessions, tours, fees, etc.) if the registrant selected any, per registration. |

Report Setup (Consolidation Reports)