When attempting to run a report such as a modified version of Contact Report which now includes secondary contact fields, the data that appears in the report is actually creating duplicate reports.
The Secondary contact tab window displays secondary contacts in a table format which allows you to enter multiple secondary contacts. When merging the data into a report, if there is more than one secondary contact listed a second copy of the report is created and the only thing that changes is the person listed in the secondary contact field.
I thought that if multiple secondary contacts were listed in the Secondary contacts table that I would be able to merge that data by using the Secondary Contact SC:3rdContact and SC:4thContact fields, but it is not working. My question is, is it suppose to and if so how can I fix the report being generated?