Reports FAQ - Report Results Window

The Report Results window displays the records returned when you run a report. The window shows the records that match the current report criteria. The window areas are the Top (Action Bar), Mid (Record Display Area), and Bottom (Row Controls).

Action Bar

The Action Bar is at the top of the window. The available actions depend on the report type. For example, the Compose Email action is only available for Registrations reports.

Actions Available in the Action Bar

Compose Email
Manage Agendas
Print Itinerary (see Itinerary Settings)
Export
Filter
Drill Down
Mass Action
Print Badges

Export (in the Action Bar)

Export outputs data to external formats or prints the report results. The formats available for export are:

Printable HTML
Acrobat PDF
Printable Excel
Excel Spreadsheet
Comma-Delimited
Tab-Delimited Text

Filter

To filter results by the initial letter of Last Name, click that letter. For example, clicking the letter “B” displays attendees whose last name starts with “B.” Click Other to display those whose last name begins with a non-alpha character. Click All to return to the complete list.

If you have defined fields in the report as Drill-Down Filters, select values to apply for them. For example, if Attendee Type is a drill-down filter you can select one from the drop-down list or leave it set to the default of [Any]. When you have selected the filter(s), click Drill Down to view the filtered report results. See Reports/Analyze > Filters for information about defining drill-down filters.

Mass Action

Select rows in the record display area. Select a Mass Action from the list, and click Go. A progress bar is shown until the action is complete. The mass actions available depend on the report type (and your user type), on the modules in use, and on the data setup. For example, mass actions available for Registration reports include:

Setting Standard Registration Properties, such as marking as Complete or Incomplete, marking as Test or Live, etc.
Changing Registration Status
Changing Attendee Type & Fee

Print Badges

Select rows in the record display area. Select a badge (from the list of those set up on Manage > Badges). Click Print to print that badge for all selected attendees, or click PDF to generate PDFs of them all (in a single zip file).

Record Display Area

The main area of the Report Results window displays the records that match the criteria set for the current report. Each row represents a record in the Certain database. Each column of the report results is equivalent to one data field configured in Reports > Columns. Click the Row number in the first column of a row to see the details of that record. To select a record (in order to perform an action on it), select its check box in the Row column. You may also use the check box in the header row for that column to select all records on the current page of report results (or clear it to deselect all). Click the up/down arrow after a column name to sort the records by that column in ascending order (A to Z or 1 to 10). Click it again to reverse the sort to descending order (Z to A or 10 to 1).

Row Controls

"Records x to y are shown" at the bottom of the page tells you what part of the full set of results you are seeing. Next – Move forwards one page-full of records (Available only if there are more to display). Previous – Go back one page-full of records (Available only if you are past the first page). Change the display by adjusting any of these figures and clicking Display:

Rows/Per Page – How many rows to show on each page
Start Row – Which row to start the report on
Max Records – The maximum number of records to be returned

Was this article helpful? 0 out of 0 found this helpful