Charles, I don't know what I'm doing wrong, but I can't get it to work. When I go to the Derived Fields panel, there are pull downs on the different menus. I don't know which one to choose to input the information. For example, the first column is the Data Fields. I understand it. It...
Thanks Charles, I went to the Derived Fields panel. I double clicked Address, City, State, Zip. The report said Derived Field okay. When I ran the report, the following is what showed up on the report:
'PS_EMPLOYEES.STREET1'PS_EMPLOYEES.CITY''PS_EMPLOYEES.CITY'
PS_EMPLOYEES.STATE'
Donna
Can someone tell me how to take separate columns of address, city, state and zip and combine them into one column?
I thought I could do it by Merge, but I only see instructions for Merge Reports.
Thank you, Donna
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.