Tuesday, October 18, 2016

TUESDAY’S TIP ~ The Surname Summary Report in Legacy 8–Creating a sortable and searchable file from this report


This is a report I had never used before.  There are a LOT of report options in Legacy 8 and I don’t know if I’ll ever learn them all.
 
I heard about this report in a post on the Legacy User Group on Facebook.  It’s an excellent group where we all help one another and share tips and tricks for using Legacy.  Thanks to Cathy Pinner for reminding us about this feature.

To create this report go to Reports > Other Reports > Surname Summary

You then have several options as seen below:

Legacy surname summary
Screenshot of Options
I always want to see what the report looks like first, so I chose “Preview.”

My report is 20 pages long in PDF format.

Here is what the first page looks like:

Legacy_Surname Summary report_created 17 Oct 2016_annotated

These are the things this one page tells me.
  • I have 33 individuals that have No Surname
  • I have one surname that I apparently put parenthesis around (MEIER).  Why?
  • For this first page of the report ARMSTRONG has the most entries – 26
  • On entry #36 is just the letter “B”  Again, my question is Why?
I’ll be going through the report one page at a time and finding anything that appears to be something that needs correcting.

How can I make better use of this list?

Legacy gives several options to you when you are preparing to view the report (see screenshot above)
  • You can just view the report by using Preview
  • You can create a PDF file (this option is also available to you from the preview screen)
  • You can create a CSV file
I like the idea of creating a CSV file, which is a spreadsheet file.  CSV stands for “comma separated values.”
 
WHY WOULD A SPREADSHEET FILE BE VALUABLE?
  • You can sort the names in different order
  • You can sort the columns in a different order
  • You could add more information in other columns
  • You can add notes
  • You could separate the names by alphabet and put them on a different sheet
  • You could color code names or any other item
What other ways can you think of to use a surname spreadsheet?

Have you used this report before?  If so, how?  I’d love to hear about it.

PLEASE SEE THE LEGACY 8 TIPS TAB UNDER THE BLOG HEADER.  YOU WILL FIND 12 DIFFERENT POSTS ABOUT MAKING THE MOST OF YOUR LEGACY DATABASE – FROM CHANGING COLORS TO STEP BY STEP INSTRUCTIONS FOR ADDING A RECORD.

Happy hunting,
Michigan Girl

Copyright ©  2010-2016   Diane Gould Hall
ALL RIGHTS RESERVED.  NO USE WITHOUT PERMISSION

4 comments:

  1. Oh Diane, you are light years ahead of me on Legacy! I do use reports, but I mainly use them for sharing information with others. I always love it when you share things about it here though because you explain things in a way I can understand.

    (Life has taken my focus elsewhere for awhile, so sorry I have been AWOL---love your blog!)

    ReplyDelete
    Replies
    1. Thanks Michelle. That's always my goal. Seems like I'm frequently mentoring someone on how to use Legacy, Blogger, Ancestry, etc. etc. I enjoy it. Good luck with all the "other" stuff.

      Delete
  2. Wow! I never noticed that surnames summary report before and how handy it will be for One Name Studies. I wonder if there is a way to add a location column? I am going to use the notes part to write in DNA information

    ReplyDelete
    Replies
    1. Magda - that's why I suggested saving the report in CSV format. That way, in the spreadsheet you can add as many columns as you want and sort them and do all sorts of things.
      Thanks for stopping by.

      Delete

I look forward to reading your comments. If you have any connection to the people mentioned in this blog, please let me know. I write about mine and my husband's ancestors and would welcome new information or meeting a new cousin or two. Thanks for visiting and come back soon.