Jump to content


Photo

Custom Reports


  • Please log in to reply
2 replies to this topic

#1 Kevin Thorsteinson

Kevin Thorsteinson

    Member

  • Members
  • PipPip
  • 12 posts

Posted 30 June 2005 - 02:03 AM

I see that I can generate name counts based on Surnames, however I have not yet been able to figure out how to do the same for Given names (including middle names).........has anyone tried this or figured this out ?

Thanks !!!

#2 Alfred

Alfred

    Advanced Member

  • Members
  • PipPipPip
  • 5734 posts

Posted 30 June 2005 - 07:14 AM

Do a custom report.
select only "Given name" and "Surname"
in options, sort by given name and then surname.

Select everyone in the database, or select by data field and:
Given name -- contains -- the name you are interested in.

Send this to a comma deliminated, "CSV" file and import it into a spreadsheet and do the math.
(the spreadsheet in Works wouldn't seem to import a CSV file, but editing the name and giving it a "TXT" extension made it importable, and into seperate columns already.)
Alfred

#3 Kevin Thorsteinson

Kevin Thorsteinson

    Member

  • Members
  • PipPip
  • 12 posts

Posted 02 July 2005 - 05:53 PM

That worked beautiful...........I missed the selection criteria, will keep that in mind for other reports......

Thanks Alfred !!!

Kevin