04-11-2013 09:42 AM
I know I have done this before, but I am trying to combine fields in the report designer. For Example I want City State and Zip all together. In the past I remember adding a field and having the option to add a custom field but now I do not see it. I did something like"
City1&", "&State1&" "&Zip1
I am using ACT! by Sage 2010 Version 12.1.181.0, Hot Fix 1
04-11-2013 09:59 AM
That's the basic script that you would use with a custom field. Remember you need to add and hide the source fields for the script.
There is a third party book with comprehensive training information on the ACT! reports, here is the link.
https://www.packtpub.com/sage-act-2011-dashboard-and-report-cookbook/book
Full disclusure I wrote the reports chapters of the book. The report chapters work for all version of the ACT! program since ACT! 2007.
04-11-2013 11:46 AM
Thanks,
It sort of came back to me. It is like they describe how to eliminate spaces on labels. I had not done it for a few years so I couldn't remember, but now that you mention this I went back and found an old knowledgebase article on removing spaces from City - State - Zip on labels and I got it to work the way I want.