Getting a Quick Event Instance Fee Analysis

The Problem An event coordinator needs to be able to see the fee breakdown of event registrations for any particular event. A VBS coordinator needs to be able to see, at a glance, the number of each size t-shirt that was ordered and the number of CD ad-ons that were ordered in order to place an order for materials. Currently, in Rock, an excel export can get to some of this information, but it does not give the options of any single fee. The SolutionCreate A dynamic data block on the event instance page that receives the event registration instance page parameter and runs an sql query for that event and gives the breakdown of all fees collected for that event. The output is grouped by option.  The two images below is the same content block on two different events. Here is the SQ...

Read More