Komen Report

All Affiliates have the following reports:

Under Data Management > Reports > Reports Classic> Custom Reports folder
*Settled Transaction / Gifts and Registrations by Participation Type

This was the original report that was built back in 2006 or 2007. 

This report Settlement Report per participation type (only shows Primary) and no upsells are listed on the initial interface.
To get the secondary information, you will have to look at the "Details" link provided in the report. At the end of the report columns,
You will get a "Secondary" link. This will only tell you "who" are the secondary participants, but not their participation type. 
To find out which Participation Type they are, you will have to go to their record and look at either the Interaction tab, or find their Registration Record in TeamRaiser. 

So if you need a report that shows you how many participation types on a specific Settlement Report...it cannot be done yet.  FR-17591

The closest that we can get is the Participant Registration Report by Transaction Date. 

In Report Writer, select the TeamRaiser Report
From the list select the Registration Report 
Select the following fields:
•	Participant First Name
•	Participant Last Name
•	Participant Email
•	Participation Type Name
•	Registration Date
•	Is Secondary Registration
•	Upsell Total Amount($)
•	Event Name

Select the following Filters:
Event 
Registration Date

*Note, the registration date will be one day behind Settlement Date. So if you are looking for Participants’ on 5/2/09, then look at registration date 5/1/09.
The only time you will run into a problem will be on Friday, Saturday, and Sunday transactions as they don't settle until the following Monday evening. 
So for Tuesday Settlement date, use Registration for Monday
So for Wednesday Settlement date, use Registrations for Tuesday
So for Thursday Settlement date, use Registration for Wednesday
So for Friday Settlement date, use Registration for Thursday
So for Monday Settlement date, use Registrations for Friday.
At times, Saturday and Sunday Registrations will also settle on Monday. 
You may have multiple batches on Monday settled because of this. 

So from the report, you will gather how many were secondary by using the "Is Secondary Registration" set to "TRUE" for you to determine how many of each participation type you had on that day. Also, you will be able to determine which ones of the secondary registrations had Upsells as well.