Why do some of the names entered show up as firstnamelastname and others as last name, first name on my reports?


  • It would help if you add the CMS you are using and which version of CiviCRM you are using? – ErikH - CiviCooP Aug 3 '17 at 8:21

Can you provide on which reports you getting them different? Normally the contacts sort name is used to display on all reports. The way it need to be stored is defined in Administer -> Customize Data and Screens -> Display Preference.

| improve this answer | |

They will appear in your report in the way the data is stored in the database. You may need to clarify what you have to get a better answer. But I would expect that if in your report you have

  • peterdavis and
  • Jones, Mary

showing, then that suggests your data itself needs sorting, maybe someone did a strange import?

| improve this answer | |
  • It was strange. We entered the names manually as a test - we thought all the same way. Then, in the same report (didn't matter which report) the names would appear in all mixed formats. Anyhow - we have resolved it by adjusting the "formula" in the admin section and re-setting all the names. Thanks for the feedback though! – Ann Jul 24 '17 at 17:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.