Family Historian User Group

Is it possible to include details such as birth dates in a fact query.
I can select and display individuals attached to a fact but I can not include individual data in the report.
Does anyone know how to do this?

ID:5887

Yes, but you need to use the =GetField() function, so for example

=GetField(FactOwner(%FACT%,1,MALES_FIRST),"%INDI.BIRT[1].DATE%")
will give you the Birth date of the first fact owner.

In the Fact Query simply add Columns such as:

Heading Expression
Owner =GetRecord(%FACT%)
Fact %FACT%
Date %FACT.DATE%
Place %FACT.PLAC%

Then on the Rows tab add a Filter such as:

Condition: Add if
Expression: =FactLabel(%FACT%)
Operator: matches
Value: Birth
Tick the Parameter option and enter a Label: such as Fact Name

Thank you Jane. That is exactly what I was looking for.