Hi everyone,
I've built a list in List Manager, and now need to export that list in Excel. I've attempted through the usual User Defined Format from a List report, as well as Executing an Output Set after creating an output set of the fields I need in Output Set Builder. The issue I'm running into is that in the lname fields (where I need last name only) my household accounts now say, for instance, "Jack and Jill Smith Household" instead of simply "Smith." Does anyone have any good tips to have the last name only appear in the last name field? I hope that makes sense; thanks in advance!
Hi Jennifer,
Good day.
you can use the function I post there.
http://www.tessituranetwork.com/Community/forums/t/7850.aspx
you can create a view with this selection
SELECT customer_no, ISNULL(dbo.LF_ReturnName(customer_no, 'last name', 'name1'), lname) AS A1_lname, lnameFROM dbo.T_CUSTOMERORDER BY customer_no
then a1_lname will return lname of customer or A1 of household last name.
if make a1_lname as a new output set, you will get what you are looking for.
Thank you for your time.
have ffun
Ben