Need to report on both program event revenue & attendance on one report
We had a large event on Friday the 13th and I need to pull a report that shows program attendance (for all programs of the day) along with Revenue. Some people pre-paid for the program. However, all the reports I'm looking at will only show those who paid on that day, which is rarely used, whereas ACTUAL attendance and ACTUAL revenue is used constantly. If every single report only pulls based on who paid that day rather than who actually attended and the actual revenue those programs pulled in for that day then the reports featured are essentially useless.
Does anyone know where the accurate report that will pull all Revenue generated from that day and all attendance generated from that day, not just those who paid that day? Or do I need to create a query every single day to create a basic report?