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 37 results

  1. ^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!
  2. 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!!
  3. 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
  4. 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.
  5. 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
  6. ^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....
  7. 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
  8. 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.
  9. 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? ­čÖĆ
  10. 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
  11. 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 ;
  12. 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
  13. 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
  14. 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
  15. 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.
  16. Hi, Is the Family Chart view somehow able to be controlled via a number of generations or is there a mod that enables this to be done. I am looking to be able to easily locate persons via a chart to ensure that the right person belongs to the right family regardless of genealogical relationship lines. I know that the Family Chart basically does that now but it is limited in what it display's, I'm looking for more generations. The normal Ancestors and Descendants charts follow a genealogy line and exclude siblings, which I understand.
  17. I am trying to create a report similar, or exactly if needed, like the one on the demo site. However I am only getting an error. I'm simply trying to create a report for persons that have been created and/or modified in the last 30-60 days. Thank you. This is what I have entered for the report: This is what I get in return:
  18. Rob Roy

    Modified Date Search

    I decided to make a change in my data entry standards. I need to create a report showing only records modified before 1 March 2020. A list of ID, full name, and birthdate. Been trying this with the Report Builder and failing.
  19. I am new at report building, and could use a bit of help for a simple report. I want a report that will sort places in descending order by a count of the number of burial events associated. The report length can be limited to the top 50 or 100 places. This report could then be used as I prioritize the addition of Cemetery records. If this type of simple report already exists, I apologize for not finding it.
  20. RMPayne

    Source reports

    Is there a way to create a report that shows Source ID and Source Title that can be exported? If so, HOW??? Robin
  21. How can I change from numerical birth/death dates to " month word" birth/death dates, such as 1 Jan 2018"?
  22. This report shows the sources and how often they are referenced to. select x.gedcom, x.sourceid as id, quantity, concat ('<a href="showsource.php?sourceID=',x.sourceid, '&tree=', x.gedcom, '">',shorttitle, '</a>') as source, title from ( SELECT s.gedcom,s.sourceID, COUNT(*) AS quantity FROM tng_sources AS s LEFT JOIN tng_citations AS c ON s.sourceID=c.sourceID and s.gedcom=c.gedcom GROUP BY s.gedcom,s.sourceID ) as x join tng_sources as t on x.gedcom=t.gedcom and x.sourceid = t.sourceid order by gedcom, quantity desc;
  23. select gedcom, concat ('<a href="placesearch.php?psearch=',place, '&tree=', gedcom, '">', place, '</a>') as place, count from ( select gedcom, place, count(place) as count from ( select gedcom, birthplace as place from tng_people where not birthplace is null and not birthplace like "" union all select gedcom, deathplace as place from tng_people where not deathplace is null and not deathplace like "" union all select gedcom, marrplace as place from tng_families where not marrplace is null and not marrplace like "" ) as places group by gedcom, place ) as result where count > 1 order by gedcom, count desc; This report returns a reference count of places. References includes birth, death and marriage. In the last line you can limit the count. As it is now, it will remove from the result all places that only have ONE reference. If you find this useful, please tell me. Every now and then I share code that might be useful to others. but until now I never got any feedback...
  24. I am looking for creating reports for Cemeteries Individuals Buried. I could not find any reports for this. Can anyone help with this reports? Thank you.
  25. RickGleason

    Determining Relationships?

    I want to find out if thereÔÇÖs a connection between the Mays and Caldwell families in my database. Is there an easy way to determine that? Thank you in advance for your time and consideration.
×