Showing results for 
Search instead for 
Do you mean 

Custom Reports Syntax for custom fields

Copper Contributor
Posts: 12
Country: New_Zealand

Custom Reports Syntax for custom fields

I am trying to define some custom fields in a report but cannot find a listing anywhere of allowed syntax in custom fields.


For example I have a report where I am trying to return the count of each type of answer to a specific field, something like:


if([C:ETSA Status 0]="8 Approved",1)


but this and many variants I've tried don't seem to work.


Any suggestions on where I might find a syntax guide or answer to this question would be appreciated.




Rob Spijkerman
Infosystems Technologies Ltd
Phone: 0064 3 3296444
Platinum Elite Contributor
Posts: 6,712
Country: USA

Re: Custom Reports Syntax for custom fields

The ACT! reports use Visual Basic script programming for that.


There is a third party book with comprehensive training information on the ACT! reports, here is the link.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer