Reporting on event questions

Quick tutorial Training course

The Questions tab displays registrant responses to event-level questions.

The questions tab.

Note: If you copy an event or use a template to create an event, the event questions are copied over and cannot be deleted. If needed, you can hide questions. See Adding program items to an event for information on how to hide event questions.

Use the Response reports to report on the event questions:

  • Summary - Answers are displayed in a percentage format for yes/no questions, in a graph format for multiple-choice questions, and as a collapsible list for open-ended response questions.

    • Summary report.

    Summary report continued.

    Expand each section before exporting the report if you want all data to display in the exported report.

    Expand before exporting if you want names to display in the summary view.

    Expanded view continued.

  • Detail - Responses are displayed per question with the registrants full name and organization.

    • Detail view.

Event questions can be reported on using the FormDefinitionFieldData and FormFieldResponseData business objects. Do the following to create your own event question report:

  1. Create a new query.
  2. (Sources tab) Add the following sources:
    • FormDefinitionFieldData
    • FormFieldResponseData
    • NetContactData
    • CsEvent
  3. (Sources tab) Relate the sources:
    • FormFieldResponseData.Form Definition Field Id = FormDefinitionFieldData.Form Definition Field Id
    • FormDefinitionFieldData.Form Definition Id = CsEvent.Form Definition Id
    • FormFieldResponseData.Id = NetContactData.Id
  4. (Filters tab) Add any desired filters, such as setting the [CsEvent] Event Code property equal to a specific event.

    5. The [CsEvent] Event Code property configured for the query.

  5. (Display tab) Add the following display properties:

      From the display tab, add the following properties.

    • [FormFieldResponseData] Form Definition Field Caption - Alias this property as Question.
    • [FormFieldResponseData] Response
    • [NetContactData] Full Name
  6. (Sorting tab) Sort on [NetContactData] First Name, so that all responses for a single contact are grouped together.

    7. Sort on [NetContactData] First Name.

  7. Click Save.
  8. Click Run.

    9. The query results.