Jump to content
TNG Community

Search the Community

Showing results for tags 'reports'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • TNG Specific
    • Announcements
    • Questions and Answers
    • TNG Modifications
    • Installation and Configuration
    • New Ideas and Suggestions
    • Code Discussion
    • Templates or Design Questions
    • CMS Integrations
    • TNG Wiki
  • Community
    • Member Webpages
    • Genealogy
    • Chit Chat
    • Questions and Answers
    • Offers And Requests

Blogs

  • Community News
  • TNG News

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Found 47 results

  1. Jan Bastiaanssen

    Whats New

    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
  2. 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..
  3. cardscraps

    Sort by date YYYY MMM DD

    ***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
  4. 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.
  5. uhanke

    Selection Criteria

    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
  6. ^maikl11

    Thumbnails in reports?

    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.
  7. ^maikl11

    cause of death

    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;
  8. 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.
  9. 4lexsharpe

    Data Validation

    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.
  10. 4lexsharpe

    Report Parameter

    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?
  11. ^maikl11

    What's wrong with my report

    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!
  12. 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!!
  13. 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
  14. 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.
  15. Rob Roy

    Sort on Individual Report

    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
  16. ^maikl11

    Report cemeteries

    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....
  17. willquill

    Name report

    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
  18. CarlWGray

    Veterans Buried in Kansas

    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.
  19. nacsaszta

    Hungarian date format

    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? ­čÖĆ
  20. Rob Roy

    Fatal error

    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
  21. Am definitely not great with mysql, I will get there I'm sure.. This report was one of the pack that came off the Wiki page It currently shows length of marriage for those people deceased (both parties) and those divorced (living or deceased) I would like to have the report show ALL marriage lengths both fore living and deceased. Would one of the msql experts be able to point me in the right direction please.. Many Thanks in advance.. select CONCAT('<a href = \"familygroup.php?familyID=', F1.familyID, '&tree=', F1.gedcom, '\" target=\"_blank\" class=\"fam\">', F1.familyID, '</a>') as FamilyID , IF(F1.living=0, "Deceased", "Alive") as Status ,CONCAT(P1.lastname, ', ', P1.firstname) as HusbandName ,CONCAT(P2.lastname, ', ', P2.firstname) as WifeName ,case when YEAR(F1.divdatetr) != 0 then YEAR(F1.divdatetr)-YEAR(F1.marrdatetr) when YEAR(P1.deathdatetr) != 0 and YEAR(P2.deathdatetr) != 0 and YEAR(P1.deathdatetr) <= YEAR(P2.deathdatetr) then YEAR(P1.deathdatetr)-YEAR(F1.marrdatetr) when YEAR(P1.deathdatetr) != 0 and YEAR(P2.deathdatetr) != 0 and YEAR(P1.deathdatetr) > YEAR(P2.deathdatetr) then YEAR(P2.deathdatetr)-YEAR(F1.marrdatetr) else 0 end as YearsMarried ,F1.marrdate ,F1.divdate ,P1.deathdate as HusbandDeathDate ,P2.deathdate as WifeDeathDate ,case when YEAR(F1.divdatetr) != 0 or (YEAR(P1.deathdatetr) != 0 and YEAR(P2.deathdatetr) != 0) then ' ' when YEAR(P1.deathdatetr) = 0 then 'Husband death date not known' when YEAR(P2.deathdatetr) = 0 then 'Wife death date not known' end as Comment from tng_families F1 inner join tng_people P1 on F1.gedcom = P1.gedcom and F1.husband = P1.personID inner join tng_people P2 on F1.gedcom = P2.gedcom and F1.wife = P2.personID where F1.marrdate != '' and UPPER(P1.deathdate) not like 'ABT%' and UPPER(P1.deathdate) not like 'AFT%' and UPPER(P1.deathdate) not like 'BEF%' and UPPER(P1.deathdate) not like 'BET%' and UPPER(P1.deathdate) not like 'CAL%' and UPPER(P1.deathdate) not like 'CIRCA%' and UPPER(P1.deathdate) not like 'EST%' and UPPER(P2.deathdate) not like 'ABT%' and UPPER(P2.deathdate) not like 'AFT%' and UPPER(P2.deathdate) not like 'BEF%' and UPPER(P2.deathdate) not like 'BET%' and UPPER(P2.deathdate) not like 'CAL%' and UPPER(P2.deathdate) not like 'CIRCA%' and UPPER(P2.deathdate) not like 'EST%' and UPPER(F1.marrdate) not like 'ABT%' and UPPER(F1.marrdate) not like 'AFT%' and UPPER(F1.marrdate) not like 'BEF%' and UPPER(F1.marrdate) not like 'BET%' and UPPER(F1.marrdate) not like 'CAL%' and UPPER(F1.marrdate) not like 'CIRCA%' and UPPER(F1.marrdate) not like 'EST%' and UPPER(F1.marrdate) != 'Y' and UPPER(F1.divdate) not like 'ABT%' and UPPER(F1.divdate) not like 'AFT%' and UPPER(F1.divdate) not like 'BEF%' and UPPER(F1.divdate) not like 'BET%' and UPPER(F1.divdate) not like 'CAL%' and UPPER(F1.divdate) not like 'CIRCA%' and UPPER(F1.divdate) not like 'EST%' and UPPER(F1.divdate) != 'Y' and (F1.divdate != '' or P1.deathdate != '' or P2.deathdate != '') and not (YEAR(F1.divdatetr) = 0 and YEAR(P1.deathdatetr) = 0 and YEAR(P2.deathdatetr) = 0) having Comment = '' order by P1.lastname, YearsMarried desc, F1.marrdatetr desc ;
  22. Hi, it is my first time here, even if I work on TNG since many years. I started recently to write SQL reports on my ancestry DB. Now I ask for an help. Now I am trying to obtain a query including all people in the same branch as follows: SELECT bl.branch, p.personID, p.suffix, p.sex, p.lastname, p.firstname, p.birthplace, p.birthdate, f.husband, f.wife, f.marrdate, p.deathplace, p.deathdate FROM tng_branchlinks AS bl INNER JOIN tng_branches AS b ON (bl.branch=b.branch) INNER JOIN tng_people AS p ON (bl.persfamID=p.personID) INNER JOIN tng_families AS f ON(p.personID=f.husband OR p.personID=f.wife) WHERE bl.branch='T1t001' ORDER BY p.birthdatetr DESC, p.lastname; the result is: # Branch Person ID Suffix sex Last Name First Name Birth Place Birth Date husband wife Marriage Date Death Place Death Date 1 T1t001 I2335 1692-1768 M Arduini Francesco Caprino Veronese - Rubiana 27 Apr 1692 I2335 I2403 16 Feb 1713 Caprino Veronese - Rubiana 17 Feb 1768 2 T1t001 I2335 1692-1768 M Arduini Francesco Caprino Veronese - Rubiana 27 Apr 1692 I2335 I2448 1742 Caprino Veronese - Rubiana 17 Feb 1768 3 T1t001 I2489 1670-1732 F S.C. Madalena ┬░┬░Arduini Ventura Caprino Veronese 1670 I2420 I2489 1691 Caprino Veronese - Rubiana 5 Mar 1732 4 T1t001 I2420 ?1662-1742 M Arduini Ventura Caprino Veronese - Rubiana 1662 I2420 I2489 1691 Caprino Veronese - Rubiana 7 Oct 1742 you see husband & wife columns...(in red), I would like to put instead of the code (I2235 etc) the right name: SQL: SELECT p.personID, p.suffix, p.sex, bl.branch, p.lastname, p.firstname, p.birthplace, p.birthdate, f.marrplace, f.marrdate, p2.branch AS CB, p2.lastname AS CLN, p2.firstname AS CFN, p.deathplace, p.deathdate, f.husband, f.wife FROM tng_branchlinks AS bl INNER JOIN tng_branches AS b ON (bl.branch=b.branch) INNER JOIN tng_people AS p ON (bl.persfamID=p.personID) INNER JOIN tng_families AS f ON (p.personID=f.husband) INNER JOIN tng_people AS p2 ON (p2.personID=f.wife) WHERE bl.branch='T1t001' ORDER BY p.birthdatetr DESC, p.lastname # Person ID Suffix sex Branch Last Name First Name Birth Place Birth Date Marriage Place Marriage Date CB CLN CFN Death Place Death Date husband wife 1 I2335 1692-1768 M T1t001 Arduini Francesco Caprino Veronese - Rubiana 27 Apr 1692 Caprino Veronese - chiesa S.Maria Maggiore 16 Feb 1713 T1,T1t002 Dalle Vedove Angela Caprino Veronese - Rubiana 17 Feb 1768 I2335 I2403 2 I2335 1692-1768 M T1t001 Arduini Francesco Caprino Veronese - Rubiana 27 Apr 1692 Caprino Veronese - chiesa S.Maria Maggiore [?] 1742 S.C. Angela ┬░┬░Ardoini F. Caprino Veronese - Rubiana 17 Feb 1768 I2335 I2448 3 I2420 ?1662-1742 M T1t001 Arduini Ventura Caprino Veronese - Rubiana 1662 Caprino Veronese - chiesa S.Maria Maggiore [?] 1691 T1,T1t001 S.C. Madalena ┬░┬░Arduini Ventura Caprino Veronese - Rubiana 7 Oct 1742 I2420 I2489 So the result is OK but only for Males ! The previous #3 record I2489 does not appear. I tried to do an UNION statement joinig a couple of Queris but no result. CAN ANYBODY help me ! Thanks Fabio
  23. Hello all I have been away for several years but have now updated my TNG to version 12.3. My old reports doesn't work anymore. One error I have fixed. The call "mysql_num_rows()." in the file showreport.php I changed tomysqi_num_rows() That was appearantly fine, but now I get another error... Parse error: syntax error, unexpected '$textpart' (T_VARIABLE) in /customers/6/6/5/binatech.se/httpd.www/tng/showreport.php on line 1 FYI, the file showreport.php was upgraded together with everything else to TNG 12.3 (the date on the file) This is my Diagnostic screendump Thanks for any help. // Ove Tegn├ęr
  24. Hi all, I just installed TNG to a test server in my home today so that I can play around with it prior to going live. After my usual pains with getting Linux file permissions correct, I'm up and running. I tried creating a report using a SQL query, but it appears that perhaps not all SQL syntax is supported? I've attached two screenshots which include the SQL queries attempted. This first report properly displays the names and counts. There are 1634 different last names in this file. However, if I try to name the columns as in the following query, it leaves the rows blank (but notice that it does show the correct number of rows). This query works fine from the MySQL command line. Just curious, did TNG ever support naming of columns from the SQL statement using "SELECT column AS 'name'" syntax? I did notice that TNG adds "Limit 50" to the end of the SQL statement for pagination, so I can't really limit it to the top 100 names (at least without some more thought, trial, and error). None of this is a big deal, I'm just trying to learn as much as I can, including any limitations. I'm loving what I'm seeing thus far! And, this will give me an excuse to learn a little PHP along the way. Thanks, Dave
  25. Rob Roy

    Today Criteria

    I have an event called Last Full Review to flag people who records I have reviewed and when. I have several reports that used this event. One shows the records I have reviewed today. To do this, I change the date daily. Is there a string or something so it will always show those records reviewed today. I have attached a JPG of the Choose Criteria.
×