Hi Simone Toit,
This could be done in Revenue Cycle Analytics very easily. See screenshot below, you would just have to make your field for number of guest visible to it as well. Do you have it as part of your licence?
For the other way which you could do within the standard program you will need to create a smart list with the set up below. In the people tab you would edit the view to show the fields you want. This does not allow you to add program name to the view though. As a way around it you could create a new field and when someone signs up for an event you could have a flow step that writes the name of that event in the field and then pull that field into the view.
The only thing with this is that if they sign up for two or more events in 24 hours they would only show up once in the list.
Thanks Gerard, this works a treat.