Community
Showing results for 
Search instead for 
Do you mean 
Reply

How do I Combine Fields in the Report Designer?

Astute Commentator
Posts: 77
Country: USA

How do I Combine Fields in the Report Designer?

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

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: How do I Combine Fields in the Report Designer?

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.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Astute Commentator
Posts: 77
Country: USA

Re: How do I Combine Fields in the Report Designer?

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.