CiviCRM Community Forums (archive)

I have an event set up using price sets.  One of the price set fields is called "session slot", which uses check boxes.   So the person registering for the event can choose one  or more of 6 "session slots":  "session A" , "session B", "session C', "session D", "session E" and "session F"
 
After a lot of people have registered, how can I get a report/search results showing how many people are coming to each session slot? ie how many are coming to session A, how many are coming to session B, etc.

When I use the "Event Participant Report(List)", I have adjusted the report criteria so that it includes the columns for "Fee Level" and "Fee Amount".  However, the report jams all the sessions someone has signed up for into a single table cell. Also the "Fee Level" and "Fee Amount" fields are not available in the "Set Filters" area.

Any ideas?

This works  for this situation. Thanks for the tip.

Made some progress:
The issue is occuring because the API call:
 require_once 'CRM/Price/BAO/Set.php';
 $priceSet = CRM_Price_BAO_Set::getSetDetail( $dao->price_set_id );

only returns checkbox options that are currently enabled, even though there is data for participants who previously registered using a check box option that was enabled at the time.    If I re-enable the checkbox value, then the downstream SQL works.

Seems like the API should be changed to return all possible options, even those that are disabled.

I changed some API code, but am not sure the of the implications.

I updated the file "CRM/Price/BAO/Field.php"

In the section:
public static function getOptions( $fieldId, $inactiveNeeded = false, $reset = false )
    {
        static $options = array();
       
        if ( $reset || empty( $options[$fieldId] ) ) {
            $values = array( );
            require_once 'CRM/Price/BAO/FieldValue.php';
          CRM_Price_BAO_FieldValue::getValues( $fieldId, $values, 'weight',  $inactiveNeeded );
            $options[$fieldId] = $values;
        }


I changed the following line of code, the original line:
  CRM_Price_BAO_FieldValue::getValues( $fieldId, $values, 'weight', ! $inactiveNeeded );

The new line of code:
  CRM_Price_BAO_FieldValue::getValues( $fieldId, $values, 'weight',  $inactiveNeeded );