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

  1. 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
  2. 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.
  3. 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.
  4. 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? ­čÖĆ
  5. 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
  6. 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 ;
  7. 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
  8. 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
  9. 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
  10. 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.
  11. 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.
  12. 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:
  13. 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.
  14. 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.
  15. 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
  16. How can I change from numerical birth/death dates to " month word" birth/death dates, such as 1 Jan 2018"?
  17. 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;
  18. 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...
  19. 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.
  20. 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.
  21. Is there a way to show all media links that are attached to an individual? Can't find any media links when I open a person for editing although the person has a link in the Photos collection. Conversely, I can't find a way of filtering the Photos media list on linked individuals.
  22. Would love to create a report with marriage places added column in the reports cagetory since there are no reports for marriage places, only couples with their marriage dates. It is pretty time consuming to open each individual to see their marriage places.
  23. Would like to create a report with Individual with missing places (birth, marriage, death and burial places). I cant use "Henny Savenije - Reports" due to problems with SQL or something like that.
  24. After a long time, I have 'flipped' my main data entry process from desktop software (RootsMagic) to direct input into TNG. That is all going well. From time to time, I like to export a Gedcom and import into RootsMagic. That's not just for additional file safe-keeping but because I can generate a variety of reports to please family members who are offline/older/whatever. Overall I am happy with the outcome. I exported a small tree from TNG to RM and ran an Ancestor report and the basics are there as expected. But I have a problem with sentence definition when exporting a tree from TNG into RootsMagic then creating such reports. I think it is part of the limitation of Gedcom which is well documented but still . . . Many facts need sentence correction - imbedded in report is warning: [NEED TO DEFINE SENTENCE etc]. . . . etc I do not know where those sentences can be defined. I know I could use a note editor to clean up the file but for bigger reports (this one is only a few hundred people) that would be tedious. Any suggestions for fixing this? Another way to export the data from TNG? Correction in RootsMagic (if anyone has dealt with this)? Have you had success importing a TNG Gedcom into other software . . . Legacy? Heredis? etc. How do you create such reports (if you do)? Is there a Mod for traditional ancestral/descendant reports I haven't found? I realize there is a report function in TNG - and I have used that - but that doesn't apply to the type of report I am mentioning here. Welcome any help with this issue. Thanks in advance! MSB
  25. Marla

    Missing dates Reports

    I am looking for creating reports for people with their missing birth dates, marriage dates and death dates. Anyone has this kind of reports?
×