I'm having a horrible time with individual contact suffixes, Struggling with input, display and reports having to do with suffixes. I'm about to create a new custom text field for suffix(2) and abandon the original suffix field. Whether I can modify the standard displays to accommodate change field change, I don't know. In the old days there would quickly be a discussion about something like this on this board, frequently ending up with discovering the system was just fine and I needed to look at the issue a different way.
Relevant previous thread - found others with this unresolved issue on this forum, but could not post a general reply, seems to be blocked: https://forum.civicrm.org/index.php?topic=10948.msg47111#msg47111
My specific issue is that for activists that they may have multiple suffixes. John Smith II may be an RN and also MSW. So there are many many possible combinations. In our case a text field may work better. However, I entered all the combinations we've run across so far, afraid of the data coming in from spreadsheets, so changed the values to the same as the dropdown display. The Suffix appears OK on the view / edit, but on reports just shows up as a 0.
Have others run into this issue - suggestions?