The first thing we will need to do is create a query to show the Fundraiser and all the participants.
  1. Click Queries
  2. Click Manage Queries
  3. Click on the category that you want to store query
  4. Click New Query under the tasks menu
  5. Name the query
  6. Set the Starting Query to Base/All Accounts
  7. Under Results, set the Data Return Type to Journal Entries
  8. Under Criteria Options mark Match each criteria
  9. Under Browse Fields select Commonly Used Fields from the drop down menu and click on Journal Entry Type
  10. Select Participation
  11. Under Browse Fields select Defined Fields from the drop down menu and click on Fundraisers
  12. Select your Fundraiser
  13. Click Save and Preview

Then, we need to create the report to show participants by team as well as show Fundraiser Total Received, Raised, and Pledged.
  1. Click Reports
  2. Click Manage Reports
  3. Click on a category where you would like to store this report in (ex: system)
  4. Click on New Report under the Task Menu
  5. Name the report
  6. Under Browse Fields, select Commonly Used Fields in the drop down menu and click Account Name and Date
  7. Select Journal Fields under Browse Fields and click Team Name, Team Role, Fundraiser Total Pledged, Fundraiser Total Raised, and Fundraiser Total Received
  8. Arrange the columns into order by clicking on the middle of the field column and dragging up or down.
  9. Scroll up to Group Results and select to Group Report By Team Name and Show Group Totals
  10. Click Save and Run under the Task Menu
  11. Under Select Query choose your category and query
  12. At the bottom of the page choose a Delivery Option and then click Submit