I would like to have a field to choose on my custom reports that shows the relationship to the root person (or other selected person, for that matter).
I have designated a group of family members that are buried in a particular cemetery. I made a nice custom report to take with me to the cemetery that includes the burial place description which gives me the plot location.
At first, I selected only the closest relatives for this group. However, after visiting the cemetery, I noticed many distant relatives nearby and wanted to include those names in my group as well. Without having my database handy during a cemetery visit, It would be really helpful to include a field in my report that shows my relationship to each name in the group.
Roots Magic has relationship information, but there seems to be no way to access it for my report. Or, is there? Any ideas for me?
You are correct that there is no way from within RM to access the relationship information except to eyeball one person at a time on the RM screen. Relationship is not a field in Custom Reports nor on People List View. Relationship is not available for searching or for making groups or for color coding. Unless these sort of things appear as future enhancements, the only real possibility for what you need is to produce reports with SQLite.
For example, I have recently written an SQLite query for my own use that color codes everyone in my database depending on certain relationships. My particular query is more generic than what you need. For example, everyone in my database to whom I’m related is color coded red and you need more detail than that. For example, you need to know about second cousins once removed vs. granduncles. But the concept is the same in that you need better access to relationship information in RM.
I go on to color code spouses of red people as green if they are not already color coded, spouses of green people as blue if they are not already color coded, parents of green people as purple if they are not already color coded, children of purple people as brown if they are not already color coded, and spouses of purple people as aqua if they are not already color coded. Everybody else is color coded yellow. It may sound like an overly convoluted scheme, but it meets my needs very well. And notice how important to my query is the condition “if they are not already color coded”. If that condition is not included at every step, the color codes step on each other.
I would love to be able to accomplish this color coding from within RM, but it’s simply not possible. In addition to not being able to test for relationship like third cousin twice removed from within RM, it’s also not possible to test for spouse of, parent of, or child of from within RM. It’s pretty easy to test for all these things from SQLite.
I’m not at the RM computer but the Kinship List report may give you the relationships to the reference person in Set Relationships and filtered for a named group.
Thanks for verifying there is no field that will help me, Jerry. Using SQLite is a bit beyond me at the moment. I’ll have to make of study of it soon.
Tom, I was ever so hopeful that an additional report would be just the thing. Unfortunately, I cannot figure out how to filter for a group. Printing everyone in the database is just overkill.
Am I missing something?
Right. I’d forgotten that it is one of the List reports that offers no Select people dialog. Other than SQLite or exporting to some other software that can give you the info you want, a workaround with RM might be to export your group (or supergroup) to another RM database and run the Kinship List from it. You could combine it with your custom report in Excel or other spreadsheet software if you have structured the Name fields in both the same way and with the RIN option. On your custom report sheet, add a column for Relationship and use the VLOOKUP() function to populate it from the Kinship sheet.
Thanks, Tom. I just started working on the Excel option. Fingers crossed.
I am in the process of moving programs and interestingly enough this query took about 2 minutes to write. About another minute or so and I could tweak it to allow me to pick a specific cemetery and probably restrict how deep the cousinships go…and it can’t be done in RM.
It is my opinion that bit likes this would have gained far more favor with their users than screwing with the UI and making it a pain to use.
Oh dear. In combining my Kinship Report in Excel with an Excel list of everyone in my tree, I have hit a big problem.
I have an unequal number of “everyone” on the Kinship Report (954) and “everyone” on my custom report (1010). When I do a “Count Trees”, I have only one tree and the number of records is 1010 like on my custom report.
Why the difference? What is the Kinship Report not picking up?
Did you eyeball the two lists to see who is missing? Knowing that might allow you to figure out why. For example, are some of them missing persons actually second spouses? If so, they really aren’t kin. Do you maybe have some people such as parents of a spouse that would not be kin? For example, my wife’s parents wouldn’t show up.