Search the Community

I am wondering if the results displayed when I "Search People", under TNG's, FIND menu item, can be modified. I was curious as to who died after a certain year and would like to add and AGE column. Age is calculated on an individuals page, so it would a matter of adding that field to the data displayed. Thanks, Jim

In the Whats New- report I would like to implement an extra section of ACTIVE (PUBLIC) reports. Can someone realize that for me ?? (I am not able to code it myself) Thanks, Jan

Hi all, A general query - Why is it so common that admin_addreport.php gives a 403? Is it quite picky or is my SQL that bad? I'm really struggling with it and only the simplest queries are accepted. For example I'm trying to weed out invalid dates Thanks Thanks Simon

Hello all, maybe someone can help me further. I am using TNG 13.1.2 and wanted to create a report. So far so good, but every time I call the report, I get the person displayed, but I also get the following error message. SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,firstname, lastname,firstname, tng_people. personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (lastname = "Klatte" ) AND tng_people.gedcom = "tree1" ORDER BY lastname I have attached a screenshot of how the report looks like. Thank you very much for your help. Many greetings Huber

Good morning, Under a new law, in Quebec, we should no longer publish data on people who died less than 30 years ago. Is there a utility option or program that a user would have developed for TNG to hide this data? Our base file contains this information. We would like to hide them except for the site administrators. Any help will really be accepted with great gratitude. Jean-Pierre Levasseur

I have just installed this mod and imported my first DOM file. It worked great! However when I click in the view Image tab I get a message that it can't find the server because the Url created looks like this: https://www.ancestry.ancestry.com/imageviewer/collections/62308/images/43290879-Nevada-088197-0005 Notice that ancestry is in the URL twice. If I manually delete one of them I an take directly to the image. What have I done to make ancestry show up twice? Thanks. Marc

Solved for me... I`ve installed an older Version (v13.1) of showreport.php The only difference is in line 591 v13.1: v13.1.1: The older version works well ! _______________________________________________________________________________________________________________________________________________________________________ I recognized yesterday, that some of my reports do not work anymore. Especially, when I want to display persons with their partner (spouse or husband), marriage date, etc ... (Reports were o.K. in TNG v13.1) For example a simple report with Name and birthday of all "Michael"s is working... but, when I add Name of Spouse, it will not work anymore: Count of records seems to be o.K. (could be higher, because some of the Michaels were married twice or more) ... but unfortunately no results in the table..

***SOLVED by using E31.EVENTDATETR field which is a date format I have a report created using an event from Family Tree Maker. It looks like the event (which has a date) is showing as a string field as the date is not sorting. Some dates are just years e.g. 1843 and some are full dates e.g. 11 April 1930. I have tried numerous SQL sorts and it just bombs out. Can someone help with what I need for the ORDER BY statement to show in YYYY MMM DD order. The e31.eventdate is the thing I am wanting to fix. SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,lastname, firstname,e31.eventdate as eventdate31,e31.eventplace as eventplace31,e31.info as info31, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_events e31 ON tng_people.personID = e31.persfamID AND tng_people.gedcom = e31.gedcom AND e31.eventtypeID = "31" WHERE (e31.eventdatetr AND e31.eventplace LIKE "%Australia%") AND tng_people.gedcom = "tree1" ORDER BY e31.eventdate

I would love to have a report that shows the number of years married for 'families' where both parents are stilling living and either or both are deceased. Me and mysql are not compatible. I have found this, could it be modified to suit?? Is someone able to help please? Thanks in advance.

I am working already some time with persondata. Now i want to generate reports of persons. When i input the lastname in criteria it works fine. Now i would like to have a universal report where i will be asked for the lastname. When i insert just the field lastname i get the header of the report but no box asking me to input the name. Is it possible to input a operator and a string and what might be syntax? Edit: Maybe my engish is not good enough to explain what i like to get: i like to have a namelist which asks me which name of persons in database should be listed. The name should be a variable in criteria. The fields to be displayed and the fields to be sorted should be inserted into reportgenerator. As i am not familar with SQL-Sintax i cannot write a complete sqlrequest in the lower box of reportgenerator. I have some experience in programming so i would be able to customize values. Uli

Hello, everyone I would like to include a thumbnail of the person in my reports. But how do I do that? Is that even possible? I can't do that with the "direct SQL SELECT statement". Who can help me? Thanks in advance.

Hello everyone, I want to make a report with a specific cause of death! Only people should be listed who have "Fallen (in german: Gefallen)" the cause of death and where they died. How do I do it? I've already prepared something, but all causes of death are listed! SELECT cause AS cause_of_death, personID, p.lastname, p.firstname, p.birthdate, p.deathdate, YEAR(p.deathdatetr)-YEAR(p.birthdatetr) AS age, p.gedcom FROM tng_events AS e INNER JOIN tng_people AS p ON (e.persfamID=p.personID AND e.gedcom=p.gedcom) WHERE cause<>"" AND parenttag="DEAT" AND YEAR(p.deathdatetr)<1910 ORDER BY cause_of_death, p.lastname;

Don't know whether this will be of interest to anyone but for people with UK ancestors the 1921 Census is due out in Jan 2022 (I know that's not news). I have written a report to identify eligible personnel. If you are interested I used this method: Select (anyone who had a 1911 census & died after 1921 ) or (were born between 1911 and died after 1921 ) It will bring back people who its still not applicable to i.e. not in the UK so I created a custom event e.g. 'Not applicable' & used a value of No for any returned who this applied to (the event can be hidden from the person page using a MOD) . It will still return those records but using the 'Sort' they can be displayed at the end of the report. At least I will know which records to target when looking for their census. The custom event can also be used to indicate in the report that you have got their census details.

Hi, I'm looking for a report that will help with the validation of the database data. I attach a B/M/D document to individual records and the thumbnail is displayed on their individual page. Does anyone know whether there is a report which displays the id, name , and image thumbnail (s) for the event (birth / marriage / death) for all records? Preferably run as 3 separate reports for each event. I can then easily see where there are missing documents.

Does TNG support the user entering a value to run a report e.g. I f I want to list all entries for a census year, rather than writing a query for each census year, can the user be prompted for a value and the report returns all census for that year?

Hello everybody I want to create a report with the religion and the date and place of baptism! Unfortunately nothing is shown to me. What I have done wrong? Please help me... thank you!

Hello everybody I would like to create a report for all people whose birthday is "Today". I've already tried all possible variations, but nothing is displayed to me - or, I have an error in the SQL syntax! Here is the error message: Abfrage: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,lastname, firstname,birthdate,birthplace, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (LPAD(SUBSTRING_INDEX(=, ' ', 1),2,'0') SUBSTRING(NOW(), 1, 10)) AND tng_people.gedcom = "KLERC" ORDER BY lastname LIMIT 50You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=, ' ', 1),2,'0') SUBSTRING(NOW(), 1, 10)) AND tng_people.gedcom = "KLERC" ORDER' at line 1 Can someone help me with this? Thank you in advance!!

I found Ken Roy's Report Footer Mod, which is indispensable, but not what I had in mind: it turned out to be more a Table Caption Duptication mod in my eyes (but hey, I am not Anglophone...). The Description field under the title is good, but that must to be just a few lines. A small image in that box could be handy. (And the word "Description: " should not be IN the text.) For a few of my reports, in a text after the table I would like to give some background info. It could easily be half a page. Sometimes a beatyfull photo asks for inclusion, max half a page as well. Anyone who could build that? Leo

It would be useful if there were a couple of un displayed blank fields on the individual. These could be populated by admins only and used to create a query in the reports page.

I just noticed that on the Individual Report the sort is by event rather than by date. Have absolutely no idea how long this has occurred as I normally don't use this report. I've look and can find no set sort field. I have attached a copy of an Individual Report which shows this odd sort. Regards, Rob Roy Woodman - Herbert J.pdf

I want to create a report that shows me all the cemeteries in my database. I entered that here: SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr, burialdate, burialplace, lastname, firstname, deathpersondate, deathplace, tng_people.ID., Deathplace, tng_people , tng_people.gedcom, nameorder FROM (tng_people) WHERE (burialplace LIKE "% Friedhof%" OR "Memorial" OR "Cemetery") AND tng_people.gedcom = "KLERC" ORDER BY burialplace But only places that contain the word "Friedhof" are shown to me: Cemetries and memorials are not displayed! Where am I making the mistake? Thank you for your help in advance....

Has anyone created a report that seperates First Name & Middle name or a report so that I could search for a middle Name and the occurrences of the same? Thank you, Willquill

Hello, I'm trying to build a report that shows Veterans buried in Kansas but does NOT show Veterans buried in Arkansas. I know how to display those buried in Kansas, but I don't know how to exclude this buried in Arkansas. Thanks in advance.

The usability of the program would be greatly increased if the date format could be selected in this format and enforced in the impressions: "YYYY. MM.dd" or "YYYY. MM. Dd". Four-digit year, separator, two-digit month, separator two-digit day (example: 2020.11.30.). The divider is a point. As in TNG Admin under Setup - > Configurations - > General Settings - > Miscellaneous - > Numeric Date Preference. I see the Java code in the "datevalidation.js" file parseDate function can handle this, only Darrin Lythgoe's 2006 amendment does not cover this. Suggestion, idea? 🙏

When creating the individual report (PDF) for an individual, I get the following: Fatal error: Uncaught Exception: FPDF error: Undefined font: dejavusans in /homepages/40/d127839664/htdocs/roygen/tfpdf.php:274 Stack trace: #0 /homepages/40/d127839664/htdocs/roygen/tfpdf.php(603): tFPDF->Error('Undefined font:...') #1 /homepages/40/d127839664/htdocs/roygen/tngpdf.php(333): tFPDF->SetFont('dejavusans') #2 /homepages/40/d127839664/htdocs/roygen/rpt_ind.php(27): TNGPDF->GetFontSize('DejaVuSans', '10') #3 {main} thrown in /homepages/40/d127839664/htdocs/roygen/tfpdf.php on line 274 This occurs in both databases (both licensed) this is the form: Just checked further, and this occurs for all PDF reports. Rob Roy