Community
Showing results for 
Search instead for 
Do you mean 
Reply

Dynamic Add / Remove formats

New Member
Posts: 8
Country: United States

Dynamic Add / Remove formats

When using the Dynamic Members feature for a group, is it possible to set the criteria for multiple field options in one line (i.e. City = city1,city2,city3)?  as apposed to adding each city separately with an AND or OR connecting them.  My search criteria ends up being unbelievably long because I have to list each city separately.  The condition is that the account is "active" and is in a certain "city".  The only way I know is to write condition 1, connected with an AND with condition 2 for each city connected with OR.  This becomes a very lengthy and confusing process.  Hopefully someone can share the shortcuts for merging the conditions.

 

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Dynamic Add / Remove formats

To answer your question, no you can't make a single statement like that. However, you also don't need to pair each city with the condition if the condition is the same. List all the city statements and group then with parenthesis and then you need to list the condition statement only once.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129