Figi4 Posted April 1, 2020 Report Share Posted April 1, 2020 Trying to think up some useful reports to add, and curious what your favorite and/or most used report is? Quote Link to comment Share on other sites More sharing options...
Mark R Posted May 17, 2020 Report Share Posted May 17, 2020 i have 3 reports, 1 is for all of the US Census, Locations and people, 2nd is for Outside of the us, 3rd is burial locations. Quote Link to comment Share on other sites More sharing options...
Newfloridian Posted May 17, 2020 Report Share Posted May 17, 2020 Three which have been / still are useful to me: 1. Deaths occurring between 1914 and 1918: 158 matches 2. Born after the death of a parent: 46 matches 3. Cause of death report: 434 matches Alan Quote Link to comment Share on other sites More sharing options...
KevyNC Posted May 31, 2020 Report Share Posted May 31, 2020 I am working on some new ones. I wanted a way to dynamically link user from my Wordpress site to the various charts etc available which are not always oblivious how to use and find to all users. So I came up with a way to add a hyperlink in a column that allows the user to go directly to that page. I have a version with numerous links (columns) but due to the column name (not field ) it does not all fit on screen. If someone can advise on how to make an Alias that would fit (basically add <br> ) in column I probably could all of them to fit on one screen. I have seen reports where is puts large columns name on multiple lines but I am guess there are built-in to the report generator and may not apply to manually entered SQL reports The report can be viewed here : View - Pedigree Chart https://alveslaborefamily.net/tng/showreport.php?reportID=144 It add a column for "Pedigree view" for each person, also makes family ID link to family group page. This also is depended on the user rights and if logged in. Since I have also had issues with having sync issues between FTM and Ancestry I did not want to have to work if I had to restore tree and if ID #'s changed it would not cause issues because they are not hard coded. This example obvious is rather long as it is currently only filtered for individual that are linked to a branch. (Still over 1500) The code looks like this: SELECT concat('<a href="https://alveslaborefamily.net/tng/pedigreetext.php?tree=T1&parentset=0&generations=6&personID=', personID, '">', personID, '</a>' ) AS Pedigree_Chart,lastname,firstname, sex, concat('<a href="https://alveslaborefamily.net/tng/getperson.php?tree=T1&personID=', personID, '">', personID, '</a>' ) AS Individual_Page,birthdate as Birthdate,birthplace, deathdate as Deathdate, deathplace, YEAR(birthdatetr) AS YOB,YEAR(deathdatetr) AS YOD , concat('<a href="https://alveslaborefamily.net/tng/familygroup.php?tree=T1&familyID=', famc, '">', famc, '</a>' ) AS FamilyGroupSheet, branch FROM (tng_people ) WHERE (branch LIKE "b%") ORDER BY lastname,firstname Hopefully, this is helpful. Quote Link to comment Share on other sites More sharing options...
KevyNC Posted May 31, 2020 Report Share Posted May 31, 2020 Okay I have adapted my report -- it had many columns that link directly to many of the various reports. The query filters for only those associated with a branch and have surname Beginning with letter of alphabet.. The purpose of the reports is to help users find what's available and where they are located. All but 3 columns are hyperlinks View - Indvidual Charts - SURNAME - A https://alveslaborefamily.net/tng/showreport.php?reportID=145 Here is the SQL: SELECT concat('<a href="https://alveslaborefamily.net/tng/pedigreetext.php?tree=T1&parentset=0&generations=6&personID=', personID, '">', "Pedigree Chart", '</a>' ) AS Pedigree_Chart, concat('<a href="https://alveslaborefamily.net/tng/ahnentafel.php?tree=T1&parentset=0&generations=8&personID=', "Ahnentafel", '">', "Ahnentafel", '</a>' ) AS Ahnentafel, concat('<a href="https://alveslaborefamily.net/tng/pedigree.php?tree=T1&parentset=0&display=compact&generations=6&personID=', "Ancestor_Compact", '">', "Ancestor Compact", '</a>' ) AS Ancestor_Compact, concat('<a href="https://alveslaborefamily.net/tng/verticalchart.php?tree=T1&parentset=0&display=vertical&generations=6&personID=', personID, '">', "Ancestor Vertical", '</a>' ) AS Ancestor_Vertical, concat('<a href="https://alveslaborefamily.net/tng/fan.php?tree=T1&parentset=0&generations=6&personID=', personID, '">', "Ancestor_Fan", '</a>' ) AS Ancestor_Fan, concat('<a href="https://alveslaborefamily.net/tng/descend.php?tree=T1&display=compact&generations=6&personID=', personID, '">', "Descendant Compact", '</a>' ) AS Descendant_Compact, concat('<a href="https://alveslaborefamily.net/tng/descendtext.php?tree=T1&generations=12&personID=', personID, '">', "Descendant_List", '</a>' ) AS Descendant_List, concat('<a href="https://alveslaborefamily.net/tng/register.php?tree=T1&generations=12&personID=', personID, '">', "Descendant_Register", '</a>' ) AS Descendant_Register, concat('<a href="https://alveslaborefamily.net/tng/descendtables.php?tree=T1&generations=12&personID=', personID, '">', "Descendant_Tables", '</a>' ) AS Descendant_Tables, personID, birthdate as Birthdate, deathdate as Deathdate, concat('<a href="https://alveslaborefamily.net/tng/getperson.php?tree=T1&personID=', personid,'">', concat (lastname,", ", firstname), '</a>' ) as Individual_Page, concat('<a href="https://alveslaborefamily.net/tng/familygroup.php?tree=T1&familyID=', famc, '">', famc, '</a>' ) AS FamilyGroupSheet FROM (tng_people ) WHERE (branch LIKE "b%" and lastname LIKE "A%") ORDER BY lastname,firstname Quote Link to comment Share on other sites More sharing options...
Figi4 Posted June 11, 2020 Author Report Share Posted June 11, 2020 Thank you all! I'm adding a good deal of them to my reports now. Does anyone know what the "Associations Between People" does exactly? @KevyNC I really like your idea, I'm going to add it to my to-do list! Can I ask, how you added the people and media counters? Quote Link to comment Share on other sites More sharing options...
bhemph Posted June 11, 2020 Report Share Posted June 11, 2020 https://tng.lythgoes.net/wiki/index.php?title=Custom_Counters_Mod is the mod to add the people and media counters. Quote Link to comment Share on other sites More sharing options...
KevyNC Posted June 11, 2020 Report Share Posted June 11, 2020 @Figi4 I am working on some modification. I have also added images using some basic html code in the description field. Which works quite nicely when viewing from the report app/view. https://alveslaborefamily.net/tng/reports.php What I am also working is a filtered view of a group of reports using query such as: Quote SELECT concat('<a href="https://alveslaborefamily.net/tng/showreport.php?reportID=', reportid, '">', reportname, '</a>' ) AS Report_Name FROM tng_reports WHERE reportname LIKE "%Calendar /%" ORDER BY reportname The above pulls all reports with "Calendar /" in the report name and display them with hyperlinks. The main reason for this approach is so I can add links in my WordPress site to link back to TNG. However, the issue I have experienced is the images are not shown when viewing "ShowReport". Maybe someone call explain if this is because it is only display text, or if the HTML code/tags are being stripped out before displaying. (see https://alveslaborefamily.net/tng/showreport.php?reportID=287 ) for example of this.... note it is displaying as expected from the main reports screen. The use of building hyperlinks in reports can be quite useful -- and has potential for many variations. Kevin Quote Link to comment Share on other sites More sharing options...
KevyNC Posted June 11, 2020 Report Share Posted June 11, 2020 10 hours ago, Figi4 said: Does anyone know what the "Associations Between People" does exactly? I am not sure if that was a table of previous version(s) or was due a MOD, but it does not appear to be a regular table in the current DB. Possibly similar to the cousin marriages table with that mod which was not part of the regular install. There were a couple relationships but I am not sure what mod has the table (or what previous versions of TNG if applicable) Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted June 11, 2020 Report Share Posted June 11, 2020 The top of the report page on the TNG Wiki indicates that you must change the SQL query Quote This report failed in TNG v8.1.1, due to a different table name. To correct, change 'tng_ass' to 'tng_associations' in the below SQL statement. to match the new table name since TNG v8.1 Quote Link to comment Share on other sites More sharing options...
Figi4 Posted June 11, 2020 Author Report Share Posted June 11, 2020 Yes, I saw that. I also found where to add the Associations. Im mostly curious what people use "associations" for in their tree. Quote Link to comment Share on other sites More sharing options...
mcm Posted June 20, 2020 Report Share Posted June 20, 2020 I have only three, though I keep meaning to create a few more. 1. Born in Ireland 2. Died in infancy or early childhood (died before the age of 5) 3. Died of tuberculosis (those whose cause of death was recorded as "tuberculosis," "pulmonary tuberculosis," or "consumption") Quote Link to comment Share on other sites More sharing options...
Newfloridian Posted June 20, 2020 Report Share Posted June 20, 2020 To your list No.3 "Died of tuberculosis" you should add the other commonly used Victorian diagnosis Phthisis Alan Quote Link to comment Share on other sites More sharing options...
mcm Posted June 21, 2020 Report Share Posted June 21, 2020 16 hours ago, Newfloridian said: To your list No.3 "Died of tuberculosis" you should add the other commonly used Victorian diagnosis Phthisis Alan Thank you! Will add Phthisis to the "Died of tuberculosis" report... And, inspired by this thread, I've added 6 more reports to my site: Born at Ballymacegan, Lorrha, Tipperary Born at Curraghafoil, Doon, Limerick Born at Forkill, Armagh Death by Drowning Died in Childbirth Killed by the Fall of a Tree [an occupational hazard for early settlers to Upper Canada!] And I'm really not very imaginative, I'm afraid: all of my reports have to do with birth and death. Quote Link to comment Share on other sites More sharing options...
RickM Posted October 29, 2020 Report Share Posted October 29, 2020 My Fav report is the top 20 living folk as of today.. Oldest is 101 years 312 days (My Dads sister) followed by the next known living person (I cannot be sure of those between) 8th down the list at 88 years 294 days (my Dad) 9th is my My Mums sister then my Mum 84 years 187 days The ages seem a little out in the days, but def the years are correct. Quote Link to comment Share on other sites More sharing options...
fluffy82 Posted October 30, 2020 Report Share Posted October 30, 2020 On 6/21/2020 at 3:19 AM, mcm said: Born at Ballymacegan, Lorrha, Tipperary Born at Curraghafoil, Doon, Limerick Born at Forkill, Armagh You don't really need to make a new report for these, just use the search form. No? Quote Link to comment Share on other sites More sharing options...
MichaelM Posted November 1, 2020 Report Share Posted November 1, 2020 It's funny... some reports "beautifulized" with some HTML-Code 1. I created a report with all persons having the same name than mine (Michael M...), with relationships between them and me. ( up to now I found 23 of them in my Database). 2. Another one is for emigrants from my hometown shows name, Birth, death, emigration date, emigration target, relationship of them and descendants to my family 3. People, who have DNA-Matches to me and my wife, shows Name, Birth Date, Birth location, Screenshot of DNA-Match, relationship Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.