We have our Individuals' records setup so that we store their spouse's name as well as their birthday, so we can send birthday cards. For example, Record #01 has [Name] = John Smith, [DOB] = 05/24/1955, [Spouse Name] = Jane Smith, [Spouse DOB] = 11/15/1958 as fields within the record. I already have a summary report grouping records by the month in the [DOB] field, but I want to be able to include the spouse's also.
I need Record #01 to be grouped in the "05 - May" group AND also listed in the "11 - November" group. I can do this with two separate summary reports, but I wanted to know if it was possible to do it in a single report. I don't know if compound reports are possible.