Hello:
Many Tessitura reports use the FT_CONSTITUENT_DISPLAY_NAME function to return a constituent's name as it appears on their record (vs how it appears on an envelope).
I would like to have display_name as an output set element! But it doesn't seem to be straightforward to dump this function into TR_QUERY_ELEMENT.
Has anyone created a display name output set element? Can you share it? Thanks!
-- Mike
PS: FT_CONSTITUENT_DISPLAY_NAME can output in three ways: normal ("Mr. John H. Appleseed, Jr."), short ("John Appleseed, Jr."), and tiny ("japplese"). I don't think I've ever seen these last two in the wild!
Hi Michael
Try this:
----------------------------------------------------------
Description: Display Name
Category: Constituent
Data Select: !.display_name
Data From: (SELECT customer_no ,display_name FROM dbo.FT_CONSTITUENT_DISPLAY_NAME ())
Control Group: Default Control Group, or whatever works for you
Single Row: Ticked
---------------------------------------------------
Ken
This worked perfectly. Thanks so much, Ken!