[LegacyUG] Settings for report options to sort data

2008-03-24 Thread Angela Gabbard
I need help generating a report and have it sort by date of birth. I have tagged all of my individuals and gone to list report options and set all of my columns. ( I have the individual's name, father , mother and date of birth) At this point I am stuck. the report is alphabetically per

Re: [LegacyUG] Settings for report options to sort data

2008-03-24 Thread RICHARD SCHULTHIES
You are accurate in your note. Legacy does not currently sort by date, so your move to Excel was the way to go. I have done it in the past, but I don't understand part of what you wrote. How I do it is, Go to Search, using search list, create the various columns (as you seem to have done), go to

Re: [LegacyUG] Settings for report options to sort data

2008-03-24 Thread Gene Young
Angela Gabbard wrote: I need help generating a report and have it sort by date of birth. The easiest way is to go to http://www.gedmagic.com/GEDxlate.htm and download GEDxlate. Then export a gedcom from Legacy and import it into GEDxlate. You can include any data you wish and then

Re: [LegacyUG] Settings for report options to sort data

2008-03-24 Thread Gene Young
Gene Young wrote: Angela Gabbard wrote: I need help generating a report and have it sort by date of birth. The easiest way is to go to http://www.gedmagic.com/GEDxlate.htm and download GEDxlate. Then export a gedcom from Legacy and import it into GEDxlate. You can include any data you

Re: [LegacyUG] Settings for report options to sort data

2008-03-24 Thread JLB
Sorry I lost the thread - overly zealous with emptying the Trash. Legacy does not seem to sort by Month, Days and Years separately, but once you've imported a csv file into a spreadsheet you can sort it there with more choice. At least it works in OpenOffice, sort of. If I import a date

Re: [LegacyUG] Settings for report options to sort data

2008-03-24 Thread Elizabeth Richardson
I don't know Open Office, but in Excel go to Format Cells and set date to show 4 digit years. It will then display correctly. Elizabeth researching the descendants of William and Sarah (Patterson) Thompson Legacy does not seem to sort by Month, Days and Years separately, but once you've

Re: [LegacyUG] Settings for report options to sort data

2008-03-24 Thread Robert Carneal USA
Please do not forget that Mudcreek's GenViewer will do this also. You can open a Legacy file in GenViewer, and convert that file to a CVS. Then, you can open that file from Excel, OpenOffice Calc, Lotus, Quattro Pro, Boeing Calc (Discontinued, I believe), MultiPlan (eBay?), SuperCalc that I am

Re: [LegacyUG] Settings for report options to sort data

2008-03-24 Thread JLB
Not a problem, had just chosen the wrong text delimiter for the csv. First, change your date customization in Legacy to 2001-09-25, ie, year-mth-day. Save your list as csv. Import into a spreadsheet, sort the birth date column ascending or descending. It will still put abt, bef, btw etc

Re: [LegacyUG] Settings for report options to sort data

2008-03-24 Thread JLB
How to display 4 digit years is OK now. Working on how to separate the 'abt's, 'bef's, 'aft's from the main date. Using Replace on the csv to change, for instance, abt 1917 to abt,1917 by adding , to the original to create an additional column with 'abt' in it. Leaves it mixed up though as

RE: [LegacyUG] Settings for report options to sort data

2008-03-24 Thread Angela Gabbard
To: LegacyUserGroup@legacyfamilytree.com Subject: Re: [LegacyUG] Settings for report options to sort data Please do not forget that Mudcreek's GenViewer will do this also. You can open a Legacy file in GenViewer, and convert that file to a CVS. Then, you can open that file from Excel, OpenOffice