I want to make a report for event attendance based on how many confirms and attendees were obtained by a caller. I made a query where the first column is Name of Caller, the second is Event Name, the third is Attendee Name and fourth and fifth are boolean variables for Confirmed to Attend and Attended. I can run a query using the count function and that gives me only a total number of either confirms or attendees for each caller but not both totals for each caller.
I could solve this if there was a function in the report builder counting the number of TRUEs but I haven’t found one that does this. I could also solve this by replacing the TRUE/FALSE value to a 1 or 0 integer value in the query I made by running another query on this first one as a subquery.
Does anyone know if there is a way to do either of the above?