* Individual Summary report relationship Capitalisation

Questions about the various ways of sharing your research with others
Post Reply
avatar
bbottomley
Diamond
Posts: 50
Joined: 23 Aug 2015 19:39
Family Historian: V7

Individual Summary report relationship Capitalisation

Post by bbottomley »

I admit this is picky as I've managed to achieve the main object of my goal i.e. to show the relationship of an individual to the root in an Individual Summary report by adding an expression in the Main section =Relationship(Fileroot()) . However I was a little disappointed that instead of displaying Great great uncle it displayed great great uncle.
Relationship.JPG
Relationship.JPG (76.52 KiB) Viewed 258 times
Not a deal breaker I admit, but as FH can achieve the correct capitalisation in the Focus Window I had expected it to do the same with my expression. I can't find anything in the report options to force the capitalisation. How can I achieve the desired result?

Many thanks in advance
Brian
User avatar
tatewise
Megastar
Posts: 28519
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Individual Summary report relationship Capitalisation

Post by tatewise »

Yes, it is a little inconsistent and could be reported to CP if you felt strongly.
However, there is a slightly awkward workaround using the ToUpper(...) function with LeftText(...) and MidText(...):
=ToUpper( LeftText( Relationship( Fileroot() ), 1 ) )=MidText( Relationship( Fileroot() ), 2 )
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
avatar
bbottomley
Diamond
Posts: 50
Joined: 23 Aug 2015 19:39
Family Historian: V7

Re: Individual Summary report relationship Capitalisation

Post by bbottomley »

Wonderful!

Thanks Mike, I'd never have come up with that solution by myself, and yes I'll get onto CP.

Greatly appreciate your knowledge and assistance.

Regards
Brian
Post Reply