I have a report that gathers all trips taken by passengers for a given date range, and summarizes the trips by combining all trips for individual passengers, and then shows totals for all trips, etc.
So if I have passengers A, B, C, D, and F, I use a Sub-summary part on the report that combines all trips taken (rather than showing individual trips) and reports the total trips taken by each passenger. And then I have a Trailing Grand Summary that gives me a total of ALL trips and costs etc.
All is working fine, except that I need to display the total count of how many DIFFERENT passengers we served for the report period at the bottom of the report. So if I have passengers A, B, C, D, and F, each taking 10 trips, I need to show we performed 50 trips for a total of $500 for 5 DIFFERENT passengers. I have set up a Total Passengers field and have tried various summary settings, using the passengerID field which is unique but can not get this to work.
Can someone give me suggestions as to how this can be done?