Documentation
Documentation

Event reports

All reports in the Staff site are created using either IQA, or an extension of Microsoft called SQL Server Reporting Services (SSRS). There are also reports that combine IQA and SSRS, where the IQA is used to define and pull the data, while SSRS is used to define the layout of the report.

You can run out-of-the-box reports on a variety of data within iMIS. Using an IQA or SSRS report is how you can get report data on the web.

You may in certain situations want to modify an existing SSRS report. To add or remove information from the report, you must download its RDL file and make adjustments to the SQL that the report uses. For more information about modifying a report, see Modifying and creating reports.

📘

Note

Printing a report using IE11 requires that the browser be in Enterprise Mode. Contact Tech Support for assistance.

📘

Note

To print a report, export the report using the PDF or Excel buttons, then print the exported report.

The Event reports and outputs are generated from information gathered during event creation and registration. For more information, see Events.

iMIS provides several out-of-the-box Event reports. To access Event reports from the Staff site, go to Reports > Event reports.

The following Event reports are available:

Combined Badge and Tickets

Prints an event badge and tickets for any registered functions that use tickets. Separate page for each registrant. Includes option to left or center justify the badge. Formatted for Avery 5392 badge stock.

📘 Note

The quantity value for program item registrations determines how many tickets are printed for each program item.

Event 2UP Labels

14 labels per sheet of 8.5 x 11-paper using Avery 5162/5262 template.

  • Source IQA- Event Function Labels
  • Source file path- $/Events/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • EventReport
    • GroupReport
    • ContactDetailReport
    • FullAddressAllReport
  • Relationships:
    • Custom (When GroupReport.MemberContactKey = ContactDetailReport.Contact Key)
    • Custom (When ContactDetailReport.Contact Key = FullAddressAllReport.Contact Key)
    • Custom (When EventReport.Event Group Key = GroupReport.Group Key)
Event 3UP Labels

30 labels per sheet of 8.5 x 11-inch paper using Avery 5160 template.

  • Source IQA- Event Function Labels
  • Source file path- $/Events/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • EventReport
    • GroupReport
    • ContactDetailReport
    • FullAddressAllReport
  • Relationships:
    • Custom (When GroupReport.MemberContactKey = ContactDetailReport.Contact Key)
    • Custom (When ContactDetailReport.Contact Key = FullAddressAllReport.Contact Key)
    • Custom (When EventReport.Event Group Key = GroupReport.Group Key)
Event Badges 8 per page

Prints event badges 8 per page. Formatted for Avery 5395 name badges.

Event Certificates

Prints a certificate of completion for each attendee of the selected event. Text of the certificate can be customized using parameters, including a logo and signature.

Event Function Rosters with Status report

Rosters of Event Function registrants, by Event and Function; allows specification of Event name.

  • Source IQA- Event Function Rosters with Status
  • Source file path- $/Events/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • EventReport
    • EventFunctionReport
    • GroupReport
    • ContactDetailReport
  • Relationships:
    • Custom (When EventReport.Event Key = EventFunctionReport.Event Key)
    • Custom (When EventFunctionReport.Group Key = GroupReport.Group Key)
    • Custom (When GroupReport.MemberContactKey = ContactDetailReport.Contact Key)
Event Products Report

List of Event function products, grouped by Event name; allows specification of Event name.

  • Source IQA- EventProducts
  • Source file path- $/Events/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • ProductKitView
    • Product
    • PriceDetail
    • PriceBreak
    • ProductStatusRef
    • PaymentTerms
    • Product1
    • PriceVersionDetail
    • PriceSheetVersion
    • PriceSheet
    • GroupUpdateInstruction
    • Group
  • Relationships:
    • Custom (When ProductKitView.Product Key = PriceDetail.ProductKey)
    • FK_PriceBreak_PriceDetail (When PriceDetail.PriceDetailKey = PriceBreak.PriceDetailKey)
    • Custom (When ProductKitView.Product Key = Product.Product Key)
    • FK_ProductMain_ProductStatusRef (When Product.Status = ProductStatusRef.Code)
    • FK_ProductMain_PaymentTerms (When Product.Payment Terms = PaymentTerms.Payment Terms Key)
    • Custom (When ProductKitView.Root Product Key = Product1.Product Key)
    • FK_PriceVersionDetail_PriceDetail (When PriceDetail.PriceDetailKey = PriceVersionDetail.PriceDetailKey)
    • FK_PriceVersionDetail_PriceSheetVersion (When PriceVersionDetail.PriceSheetVersionKey = PriceSheetVersion.PriceSheetVersionKey)
    • FK_PriceSheetVersion_PriceSheet (When PriceSheetVersion.PriceSheetKey = PriceSheet.PriceSheetKey)
    • Custom (When ProductKitView.Product Key = GroupUpdateInstruction.Target Uniform Key)
    • FK_GroupUpdateInstruction_GroupMain (When GroupUpdateInstruction.Group = Group.Group Key)
Event Program Item Certificates

Prints a certificate of completion for each attendee of the selected program item. Text of the certificate can be customized using parameters, including a logo and signature.

Event Question Response Details

For each question associated with an event, registration option, or program item, prints a list of active registrants and their response to the question.

Event Registrations Cancels Report

List of Event, Registration Options and Program items with Registration and cancellation counts.

  • Source IQA- Event Registration Cancels Report
  • Source file path- $/Events/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • GroupReport
    • EventFunctionReport
    • Organization
    • Event
  • Relationships:
    • Custom (When GroupReport.Group Key = EventFunctionReport.Group Key)
    • Custom (When EventFunctionReport.Event Key = Event.Event Key)
Event Roster with Status Report

Rosters of Event registrants, by Event; allows specification of Event name and registrant status.

  • Source IQA- Event Roster with Status
  • Source file path- $/Events/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • GroupReport
    • ContactDetailReport
  • Relationships:
    • Custom (When GroupReport.MemberContactKey = ContactDetailReport.Contact Key)
Event Simple Badge Report

Event badge for each participant information in Avery 5392 badge stock.

  • Source IQA- Event Simple Badge Report
  • Source file path- $/Events/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • EventRegistrantsReport
  • Relationships:
    • Not applicable
Events List Report

List of Events; no functions are displayed; allows specification of Event name and start date range.

  • Source IQA- Events List
  • Source file path- $/Events/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • EventReport
    • Event
  • Relationships:
    • Custom (When EventReport.Event Key = Event.Event Key)
Events list with Functions Report

Event list with associated functions. Allows specification of Event name and start date range.

  • Source IQA- Events List with Functions
  • Source file path- $/Events/DefaultSystem/Reports/Queries
  • Source Business Objects:
    • EventReport
    • EventFunctionReport
    • Event
  • Relationships:
    • Custom (When EventReport.Event Key = EventFunctionReport.Event Key)
    • Custom (When EventReport.Event Key = Event.Event Key)
Function Tickets

Prints tickets for those event functions which use tickets. Separate page for each registrant. Formatted for Avery 5392 badge stock.

📘 Note

The quantity value for program item registrations determines how many tickets are printed for each program item.

ProgramItemRegistrantsReport.rdl

This report details an event's attendees by either registration options or program items.

Updated 4 months ago

Did this page help you?