Is there a report for events with missing sources? I can't seem to find it.

Report for events with missing sources
#1
Posted 26 November 2014 - 08:15 PM
#2
Posted 26 November 2014 - 08:35 PM
Reports > Lists > Fact List
From the dropdown listbox labelled "Create a list of", select "Facts without sources".
Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
#3
Posted 26 November 2014 - 09:31 PM
Thanks now if only I could figure out a way to ignore the reference number or other sources that are there for more bookkeeping reasons.
#4
Posted 26 November 2014 - 09:43 PM
I thought there was an easy answer to that:
Lists > Fact Type List
-- edit the Reference # fact type to uncheck the box "Include when: Printed lists"
However the Fact List report seems to be exempted from this control.
Another idea is to use a SQLite query to set all instances of the Ref# fact to Private and uncheck the box "Print private facts" in the report settings. I have not tried it in RM7 though so I cannot vouch that it works.
Finally, you can save the Fact List report to a text file, open it with Excel and use sort/filter to view your results.
Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
#5
Posted 26 November 2014 - 09:59 PM
Another idea is to use a SQLite query to set all instances of the Ref# fact to Private and uncheck the box "Print private facts" in the report settings.
This works:
UPDATE EventTable SET IsPrivate = 1 WHERE EventType = 35 ;
Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.