Jennerations: 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
Arrival: Datece_dt_99
Arrival: Placece_pl_99
Arrival: Factce_fa_99
Campaign Medal: Datece_dt_102
Campaign Medal: Placece_pl_102
Campaign Medal: Factce_fa_102
Chest Size: Datece_dt_92
Chest Size: Placece_pl_92
Chest Size: Factce_fa_92
Complexion: Datece_dt_91
Complexion: Placece_pl_91
Complexion: Factce_fa_91
Departure: Datece_dt_98
Departure: Placece_pl_98
Departure: Factce_fa_98
Employment: Datece_dt_81
Employment: Placece_pl_81
Employment: Factce_fa_81
Eyes: Datece_dt_89
Eyes: Placece_pl_89
Eyes: Factce_fa_89
Grave Location: Datece_dt_100
Grave Location: Placece_pl_100
Grave Location: Factce_fa_100
Hair: Datece_dt_90
Hair: Placece_pl_90
Hair: Factce_fa_90
Height: Datece_dt_86
Height: Placece_pl_86
Height: Factce_fa_86
Interest: Datece_dt_84
Interest: Placece_pl_84
Interest: Factce_fa_84
Medal: Datece_dt_95
Medal: Placece_pl_95
Medal: Factce_fa_95
Memorial: Datece_dt_101
Memorial: Placece_pl_101
Memorial: Factce_fa_101
Military ID: Datece_dt_96
Military ID: Placece_pl_96
Military ID: Factce_fa_96
Rank: Datece_dt_83
Rank: Placece_pl_83
Rank: Factce_fa_83
Regiment: Datece_dt_87
Regiment: Placece_pl_87
Regiment: Factce_fa_87
Service: Datece_dt_82
Service: Placece_pl_82
Service: Factce_fa_82
Service No.: Datece_dt_88
Service No.: Placece_pl_88
Service No.: Factce_fa_88
Theatre of War: Datece_dt_94
Theatre of War: Placece_pl_94
Theatre of War: Factce_fa_94
Trade/Skill: Datece_dt_93
Trade/Skill: Placece_pl_93
Trade/Skill: Factce_fa_93
Visa: Datece_dt_97
Visa: Placece_pl_97
Visa: Factce_fa_97
_USED: Datece_dt_85
_USED: Placece_pl_85
_USED: Factce_fa_85

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 Arrival: Datece_dt_99 Arrival: Date (True)ce_tr_99 Arrival: Placece_pl_99 Arrival: Factce_fa_99 Campaign Medal: Datece_dt_102 Campaign Medal: Date (True)ce_tr_102 Campaign Medal: Placece_pl_102 Campaign Medal: Factce_fa_102 Chest Size: Datece_dt_92 Chest Size: Date (True)ce_tr_92 Chest Size: Placece_pl_92 Chest Size: Factce_fa_92 Complexion: Datece_dt_91 Complexion: Date (True)ce_tr_91 Complexion: Placece_pl_91 Complexion: Factce_fa_91 Departure: Datece_dt_98 Departure: Date (True)ce_tr_98 Departure: Placece_pl_98 Departure: Factce_fa_98 Employment: Datece_dt_81 Employment: Date (True)ce_tr_81 Employment: Placece_pl_81 Employment: Factce_fa_81 Eyes: Datece_dt_89 Eyes: Date (True)ce_tr_89 Eyes: Placece_pl_89 Eyes: Factce_fa_89 Grave Location: Datece_dt_100 Grave Location: Date (True)ce_tr_100 Grave Location: Placece_pl_100 Grave Location: Factce_fa_100 Hair: Datece_dt_90 Hair: Date (True)ce_tr_90 Hair: Placece_pl_90 Hair: Factce_fa_90 Height: Datece_dt_86 Height: Date (True)ce_tr_86 Height: Placece_pl_86 Height: Factce_fa_86 Interest: Datece_dt_84 Interest: Date (True)ce_tr_84 Interest: Placece_pl_84 Interest: Factce_fa_84 Medal: Datece_dt_95 Medal: Date (True)ce_tr_95 Medal: Placece_pl_95 Medal: Factce_fa_95 Memorial: Datece_dt_101 Memorial: Date (True)ce_tr_101 Memorial: Placece_pl_101 Memorial: Factce_fa_101 Military ID: Datece_dt_96 Military ID: Date (True)ce_tr_96 Military ID: Placece_pl_96 Military ID: Factce_fa_96 Rank: Datece_dt_83 Rank: Date (True)ce_tr_83 Rank: Placece_pl_83 Rank: Factce_fa_83 Regiment: Datece_dt_87 Regiment: Date (True)ce_tr_87 Regiment: Placece_pl_87 Regiment: Factce_fa_87 Service: Datece_dt_82 Service: Date (True)ce_tr_82 Service: Placece_pl_82 Service: Factce_fa_82 Service No.: Datece_dt_88 Service No.: Date (True)ce_tr_88 Service No.: Placece_pl_88 Service No.: Factce_fa_88 Theatre of War: Datece_dt_94 Theatre of War: Date (True)ce_tr_94 Theatre of War: Placece_pl_94 Theatre of War: Factce_fa_94 Trade/Skill: Datece_dt_93 Trade/Skill: Date (True)ce_tr_93 Trade/Skill: Placece_pl_93 Trade/Skill: Factce_fa_93 Visa: Datece_dt_97 Visa: Date (True)ce_tr_97 Visa: Placece_pl_97 Visa: Factce_fa_97 _USED: Datece_dt_85 _USED: Date (True)ce_tr_85 _USED: Placece_pl_85 _USED: Factce_fa_85
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
Arrival: Datece_dt_99
Arrival: Date (True)ce_tr_99
Arrival: Placece_pl_99
Arrival: Factce_fa_99
Campaign Medal: Datece_dt_102
Campaign Medal: Date (True)ce_tr_102
Campaign Medal: Placece_pl_102
Campaign Medal: Factce_fa_102
Chest Size: Datece_dt_92
Chest Size: Date (True)ce_tr_92
Chest Size: Placece_pl_92
Chest Size: Factce_fa_92
Complexion: Datece_dt_91
Complexion: Date (True)ce_tr_91
Complexion: Placece_pl_91
Complexion: Factce_fa_91
Departure: Datece_dt_98
Departure: Date (True)ce_tr_98
Departure: Placece_pl_98
Departure: Factce_fa_98
Employment: Datece_dt_81
Employment: Date (True)ce_tr_81
Employment: Placece_pl_81
Employment: Factce_fa_81
Eyes: Datece_dt_89
Eyes: Date (True)ce_tr_89
Eyes: Placece_pl_89
Eyes: Factce_fa_89
Grave Location: Datece_dt_100
Grave Location: Date (True)ce_tr_100
Grave Location: Placece_pl_100
Grave Location: Factce_fa_100
Hair: Datece_dt_90
Hair: Date (True)ce_tr_90
Hair: Placece_pl_90
Hair: Factce_fa_90
Height: Datece_dt_86
Height: Date (True)ce_tr_86
Height: Placece_pl_86
Height: Factce_fa_86
Interest: Datece_dt_84
Interest: Date (True)ce_tr_84
Interest: Placece_pl_84
Interest: Factce_fa_84
Medal: Datece_dt_95
Medal: Date (True)ce_tr_95
Medal: Placece_pl_95
Medal: Factce_fa_95
Memorial: Datece_dt_101
Memorial: Date (True)ce_tr_101
Memorial: Placece_pl_101
Memorial: Factce_fa_101
Military ID: Datece_dt_96
Military ID: Date (True)ce_tr_96
Military ID: Placece_pl_96
Military ID: Factce_fa_96
Rank: Datece_dt_83
Rank: Date (True)ce_tr_83
Rank: Placece_pl_83
Rank: Factce_fa_83
Regiment: Datece_dt_87
Regiment: Date (True)ce_tr_87
Regiment: Placece_pl_87
Regiment: Factce_fa_87
Service: Datece_dt_82
Service: Date (True)ce_tr_82
Service: Placece_pl_82
Service: Factce_fa_82
Service No.: Datece_dt_88
Service No.: Date (True)ce_tr_88
Service No.: Placece_pl_88
Service No.: Factce_fa_88
Theatre of War: Datece_dt_94
Theatre of War: Date (True)ce_tr_94
Theatre of War: Placece_pl_94
Theatre of War: Factce_fa_94
Trade/Skill: Datece_dt_93
Trade/Skill: Date (True)ce_tr_93
Trade/Skill: Placece_pl_93
Trade/Skill: Factce_fa_93
Visa: Datece_dt_97
Visa: Date (True)ce_tr_97
Visa: Placece_pl_97
Visa: Factce_fa_97
_USED: Datece_dt_85
_USED: Date (True)ce_tr_85
_USED: Placece_pl_85
_USED: Factce_fa_85

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