Add "Registration Survey Questions" field to the Milestone Report in Report Writer

When running a Milestone report, I'd like to pull the participant's t-shirt size which was collected in the additional questions during registration. But that field is not an option when running the Milestone report. Conversely "Date Milestone Achieved" is not a field option on the registration reports. 

My work-around for this is to update a constituent field with the shirt size during registration and then pull that in during the Milestone report. This is a little clunky and also adds a constituent field that may not get updated at any other time.

  • Sally Riddle
  • May 2 2017
  • Reviewed: Voting Open
Area of the Product TeamRaiser
Org/Company Name Carry The Load
  • Attach files
  • Brian Mucha commented
    May 04, 2017 17:40

    You could also pull a milestone report, and a registration report into two worksheets in Excel. Then use a formula in a column on the milestone report to lookup the t-shirt size in the registration using the consId. (Search Google for "Excel Index Match" for more.)