Family Historian User Group

I made the changes to the following and also changed tblSurname to tblCemetery . That was a naming error. Now how do I eliminate the null result and null count in the final Result Set ? --[[ @Title: Cemetery Summary Report @Author: Gary Carson @LastUpdated: April 2016 @Description: Counts and Lists ...

I did the query in the manner suggested and it also worked fine.

I did create a plug in that seems to work. It gets the list I need, --[[ @Title: Cemetery Summary Report @Author: Gary Carson @LastUpdated: April 2016 @Description: Counts and Lists All Burial Places in the File ]] tblCemeteries = {} -- Define array for Burial Places pi = fhNewItemPtr() -- declare p...

I wish to create a query that list all unique burial locations.

My format for burial Place is Cemetery, City, County, State, Country with the number of links.

I already have a query that list all burials by individual.

Please advise.

Many thanks. That did it.

Did as you suggested. Still get a pop up window asking for a starting person.

Having made the following changes: Descendant %INDI% Record Id =RecordId(%INDI%) Generation =RelationCode(Record(977,"I"),%INDI%,GENERATION,1) Relationship =Relationship(Record(977,"I"),%INDI%,TEXT,1) Where in the Row tab do I add Add if =IsDescendantOf(%INDI%,Record(977,"I")) is true ? General or R...

Ignore previous post. When I use the following The individuals included are correct the relation to the root record are in inverse relationships, ie son is now listed as father, etc Also when running the query, a pop up window asks for the root person. I want Record person 977 to always be the root....

Yes I did select the all the entire rows in the Result Set ? I see now that if I only selected the first column of the Result Set I would have gotten the desired result. I also discovered when using the Query Menu > Set Flag on row Records I would also get the desired result. Your comment on use of ...

I ran query using the standard Descendants query. The results came out as expected. I then performed Edit > Add to Named List after selecting all names in the Result Set of the query. What got sent to the Named List was the descendants and their spouses . I do no want the spouses, as I am trying to ...

That did the job. Thanks.

When performing a query one of the columns I want is the woman's husband' surname. The expression I currently use is %INDI.FAMS[1]>HUSB[1]>NAME[1]:SURNAME% What I get is not only a value for the married women (which I want) but I also get a value for the men that are married. "William CAULK" results...

I closed the project in question and retried. All worked when saving report as.

Has not re-occurred. Will let customer service know it occurs again.

When attempting to Save Report As... I get an error message that "Some of data may have changed...click the (Rebuild the report button)".

I did and still could not save the report.

Does anyone know what may have happened?

Have not written a plugin but this looks like a good challenge to try.

Your second option gave me the desired results.

Many thanks.

When sorting, is it possible to sort on multiple columns rather than one column at a time. When sorting my Place parts I would like to sort on Place 4 (State), then Place 3 (County), then Place 2 (City). With results looking like Town A, County A, State A Town B, County A, State A Town A, County B, ...

I have an imported file (very large) that has a large number of place name in the following format Neuwedell, Arnswalde, Prussia (Drawno, Brandenburg, Poland) I would like to manipulate those place names so that the Place Name is Neuwedell, Arnswalde, Prussia And the Standardized name is Drawno, Bra...

Rebooting solved the problem.

By the way using W7 P"rofessional

Also being American and new to FH after migrating from TMG I like that this program seems to bridge both British and American needs. This broad approach should be good for all. Hope the developers keep making a broad approach since family research for us Americans often reverts back to the Continent.

When attempting a Small Backup get the following error "Error reading file. Cannot perform backup" I could backup the other two methods - Medium and Full without errors. Validated without errors and still got the same error message. Used default file name for saving the Small Backup. Had made numero...

"Did you try the Knowledge Base > Query:Individual ~ Occupations Report Query which lists all the Occupations and the Records that use them, which you can click on to open their Propery Box and edit, whilst still retaining the Query Result Set." The suggestion above did exactly what I wanted. I just...

I just tried that procedure along with the Rearrange plug in. Worked just as expected and as I hoped. This now opens up a large number of options for cleaning up my imported TMG data.

Thanks a milliom

Sounds like a great work around. I will try that.

I want to do more than view the expanded record. I want to edit part or parts of the record. I can only edit the record by selecting the record and then clicking "Go To". Once I have then viewed/edited the record, I wish to return to "Records using..."