Our Family History: TNG Admin (Add New Report)

Reports >> Add New Report

Report Name:
Description:
Rank/Priority:
Active:	Yes No

Instructions: Drag or double-click items at left into lists at right. Drag up and down to re-order. Double-click again to remove.

Choose Fields to Display:

Person IDpersonID
Full Namefullname
Last Name, First Namelastfirst
First Namefirstname
Last Namelastname
Nicknamenickname
Birth Datebirthdate
Birth Placebirthplace
Christening Datealtbirthdate
Christening Placealtbirthplace
Marriage Datemarrdate
Marriage Placemarrplace
Divorce Datedivdate
Divorce Placedivplace
Spouse IDspouseid
Spouse Namespousename
Death Datedeathdate
Death Placedeathplace
Burial Dateburialdate
Burial Placeburialplace
Last Modifiedchangedate
Gendersex
Titletitle
Prefixprefix
Suffixsuffix
Treegedcom
LDS Baptism Datebaptdate
LDS Baptism Placebaptplace
LDS Confirmation Dateconfdate
LDS Confirmation Placeconfplace
LDS Initiatory Dateinitdate
LDS Initiatory Placeinitplace
LDS Endowment Dateendldate
LDS Endowment Placeendlplace
LDS Seal/Spouse Datessealdate
LDS Seal/Spouse Placessealplace
LDS Seal/Parents Datepsealdate
LDS Seal/Parents Placepsealplace

Choose Criteria:

Person IDpersonID First Namefirstname Last Namelastname Surname Prefixlnprefix Nicknamenickname Month Only Frommonthonly Year Only Fromyearonly Day Only Fromdayonly Birth Datebirthdate Birth Date (True)birthdatetr Birth Placebirthplace Christening Datealtbirthdate Christening Date (True)altbirthdatetr Christening Placealtbirthplace Marriage Datemarrdate Marriage Date (True)marrdatetr Marriage Placemarrplace Divorce Datedivdate Divorce Date (True)divdatetr Divorce Placedivplace Death Datedeathdate Death Date (True)deathdatetr Death Placedeathplace Burial Dateburialdate Burial Date (True)burialdatetr Burial Placeburialplace Last Modifiedchangedate Gendersex Titletitle Prefixprefix Suffixsuffix Treegedcom LDS Baptism Datebaptdate LDS Baptism Date (True)baptdatetr LDS Baptism Placebaptplace LDS Confirmation Dateconfdate LDS Confirmation Date (True)confdatetr LDS Confirmation Placeconfplace LDS Initiatory Dateinitdate LDS Initiatory Date (True)inittdatetr LDS Initiatory Placeinitplace LDS Endowment Dateendldate LDS Endowment Date (True)endldatetr LDS Endowment Placeendlplace LDS Seal/Spouse Datessealdate LDS Seal/Spouse Date (True)ssealdatetr LDS Seal/Spouse Placessealplace LDS Seal/Parents Datepsealdate LDS Seal/Parents Date (True)psealdatetr LDS Seal/Parents Placepsealplace Living = yesliving Living = nodead Private = yesprivate Private = noopen
Operators: =eq !=neq >gt >=gte <lt <=lte containscontains starts withstarts with ends withends with OROR ANDAND Current Monthcurrmonth Current Month Numbercurrmonthnum Current Yearcurryear Current Daycurrday Today (true date)today Convert to Daysto_days (( )) ++ --
Constant String:*
Constant Value:

*For an empty string, leave this field blank and click >>

Choose Sort Fields:

Person IDpersonID
First Namefirstname
Last Namelastname
Surname Prefixlnprefix
Nicknamenickname
Month Only Frommonthonly
Year Only Fromyearonly
Day Only Fromdayonly
Descending (Prev)desc
Birth Datebirthdate
Birth Date (True)birthdatetr
Birth Placebirthplace
Christening Datealtbirthdate
Christening Date (True)altbirthdatetr
Christening Placealtbirthplace
Marriage Datemarrdate
Marriage Date (True)marrdatetr
Marriage Placemarrplace
Divorce Datedivdate
Divorce Date (True)divdatetr
Divorce Placedivplace
Death Datedeathdate
Death Date (True)deathdatetr
Death Placedeathplace
Burial Dateburialdate
Burial Date (True)burialdatetr
Burial Placeburialplace
Last Modifiedchangedate
Gendersex
Titletitle
Prefixprefix
Suffixsuffix
Treegedcom
LDS Baptism Datebaptdate
LDS Baptism Date (True)baptdatetr
LDS Baptism Placebaptplace
LDS Confirmation Dateconfdate
LDS Confirmation Date (True)confdatetr
LDS Confirmation Placeconfplace
LDS Initiatory Dateinitdate
LDS Initiatory Date (True)inittdatetr
LDS Initiatory Placeinitplace
LDS Endowment Dateendldate
LDS Endowment Date (True)endldatetr
LDS Endowment Placeendlplace
LDS Seal/Spouse Datessealdate
LDS Seal/Spouse Date (True)ssealdatetr
LDS Seal/Spouse Placessealplace
LDS Seal/Parents Datepsealdate
LDS Seal/Parents Date (True)psealdatetr
LDS Seal/Parents Placepsealplace

OR Leave Display, Criteria and Sort fields blank and enter direct SQL SELECT statement here: