Reporting on different types of Event Registrations

Cate Laskovics · October 2014

For our luncheon we set up several different types of tickets (early bird prices, different sponsorship levels, table hosts, student prices, etc.) and I was hoping to be able to pull a simple report that broke down all the money from registration fees into the number of different tickets purchased. Example: Early Bird ticket - 10 tickets - $1000 Student ticket - 30 tickets - $1500 Total Registration Income: $2500 Is there a canned report that I can use to make something like this work? The closest I've come is creating a participant query that has registration information, exporting it, and then adding the numbers up myself, hoping they all balance out to what I have for registration fees. Any suggestions would be appreciated! Thanks!

Jana Gay 2 · October 2014

Cate Laskovics:
For our luncheon we set up several different types of tickets (early bird prices, different sponsorship levels, table hosts, student prices, etc.) and I was hoping to be able to pull a simple report that broke down all the money from registration fees into the number of different tickets purchased. Example: Early Bird ticket - 10 tickets - $1000 Student ticket - 30 tickets - $1500 Total Registration Income: $2500 Is there a canned report that I can use to make something like this work? The closest I've come is creating a participant query that has registration information, exporting it, and then adding the numbers up myself, hoping they all balance out to what I have for registration fees. Any suggestions would be appreciated! Thanks!

Hi Cate,

Over the years I have had numerous requests for reports that subtotal event income (or provide a count) by participation unit. I would love to see this as a standard report in the event reports!!! Unfortunately, what you are doing (exporting participant records and subtotaling in Excel or creating a Crystal report based on the participant export) is the closest fix that I have found. Maybe someone else has found a way... [*-)]

Beverly Lyles · October 2014

Jana Gay:

Hi Cate,

Over the years I have had numerous requests for reports that subtotal event income (or provide a count) by participation unit. I would love to see this as a standard report in the event reports!!! Unfortunately, what you are doing (exporting participant records and subtotaling in Excel or creating a Crystal report based on the participant export) is the closest fix that I have found. Maybe someone else has found a way... [*-)]

I have been blessed to have found someone to create these type of reports through Crystal for me. They work great for my events team and provide information that can't otherwise be made available in a report or export format. The type of reports he makes comes directly from the data files which pulls the information a lot quicker than going through export. For lack of a better way of putting it - he basically pulls the information from the backside of RE and he uses SQL to make the reports pull exactly the type of information I need.

Helen Wieger · October 2014

Cate Laskovics:
For our luncheon we set up several different types of tickets (early bird prices, different sponsorship levels, table hosts, student prices, etc.) and I was hoping to be able to pull a simple report that broke down all the money from registration fees into the number of different tickets purchased. Example: Early Bird ticket - 10 tickets - $1000 Student ticket - 30 tickets - $1500 Total Registration Income: $2500 Is there a canned report that I can use to make something like this work? The closest I've come is creating a participant query that has registration information, exporting it, and then adding the numbers up myself, hoping they all balance out to what I have for registration fees. Any suggestions would be appreciated! Thanks!

What we have done is to create an appeal for each event, and a package in that appeal for each type of ticket and sponsorship. Then we can run an Appeals Analysis report (under Analytical Reports) and get the total given for each package (each type of ticket), and the number of donors for each package (presumably the number of people that purchased tickets). This doesn't allow us to break it down by number of tickets if, say, a mother and daughter paid with one check. But it does work for the most part.

Reporting on different types of Event Registrations

Comments

Categories