Answers.Body: <p>Yes you can do this in a Drupal View but it will require some config (both to tell Drupal about your CiviCRM tables as well as the Views config itself); </p>
  
  <p>The goto solution for this within CiviCRM itself is:</p>
  
  <p>Install: Extended Report Extension: 
  Got to your Adminster -> System -> Settings -> Manage Extensions -> Add New -> ExtendedReport (nz.co.fuzion.extendedreport)</p>
  
  <p>After you've installed it -> go Administer -> CiviReport -> Create New Report from Template and select e.g. Extended Report - Contributions with Price Set data</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-18T12:19:50.857Z
Answers.LastActivityDate: 2017-10-18T12:19:50.857Z
Answers.UserDisplayName: KarinG - Semper IT
Body: <p>We use CiviCRM to sell event tickets and I was wondering if it's possible to pull the list of current events and confirmed participant number in to a simple Drupal View restricted to logged in users so we can keep track of ticket sales more easily?</p>
  
  <p>I've looked at the built in options for creating the views but can't see a way of pulling that data across. </p>
  
  <p>If there's an easier way of doing this directly in Civi then all ears for that as well but we're finding it a bit clunky to have to find each individual event each time and check the registered participant number and just want an overview.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-10-18T17:50:13.553Z
Comments.Text: Do you want to clarify what it is about the Event Dashboard that does not provide the overview you want? Too many current events? eg http://dmaster.demo.civicrm.org/civicrm/event?reset=1 - otherwise concur with Karin - a view based on Participants using Aggregation i think would give you the summary counts if you need to go via Views
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-11-29T22:55:45.680Z
Comments.Text: We've done this with Views and Aggregator Plus, exactly as Pete says. This lists all upcoming events, with their current bookings and links to their participant lists. I can send you screen shots or a view export if that's helpful. J
Comments.UserDisplayName: Andyg8
Tags: <civievent><drupal><drupal-views>
Title: Create a Drupal View of current event participant numbers
ThreadText: # Create a Drupal View of current event participant numbers
  
  (Asked by: username_0 on 2017-10-18)
  
  We use CiviCRM to sell event tickets and I was wondering if it's possible to pull the list of current events and confirmed participant number in to a simple Drupal View restricted to logged in users so we can keep track of ticket sales more easily?
  
  I've looked at the built in options for creating the views but can't see a way of pulling that data across.
  
  If there's an easier way of doing this directly in Civi then all ears for that as well but we're finding it a bit clunky to have to find each individual event each time and check the registered participant number and just want an overview.
  
  **Tags:** civievent, drupal, drupal-views
  
  > **Comments:**
  > **username_1**: Do you want to clarify what it is about the Event Dashboard that does not provide the overview you want? Too many current events? eg http://dmaster.demo.civicrm.org/civicrm/event?reset=1 - otherwise concur with Karin - a view based on Participants using Aggregation i think would give you the summary counts if you need to go via Views  
  > **username_2**: We've done this with Views and Aggregator Plus, exactly as Pete says. This lists all upcoming events, with their current bookings and links to their participant lists. I can send you screen shots or a view export if that's helpful. J  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2017-10-18. Score: 1
  
  Yes you can do this in a Drupal View but it will require some config (both to tell Drupal about your CiviCRM tables as well as the Views config itself);
  
  The goto solution for this within CiviCRM itself is:
  
  Install: Extended Report Extension:
  Got to your Adminster -> System -> Settings -> Manage Extensions -> Add New -> ExtendedReport (nz.co.username_1.extendedreport)
  
  After you've installed it -> go Administer -> CiviReport -> Create New Report from Template and select e.g. Extended Report - Contributions with Price Set data
  
  
  ---
  
  