Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition) » Filter for a report
Post new topic  Reply to topic View previous topic :: View next topic 
Filter for a report
PostPosted: Fri Sep 19, 2014 9:28 am Points: 0 Reply with quote
NeilT
GoldMine Journeyman
Joined: 03 Jan 2011
Posts: 44
Location: GB




HI, I am using GM 2013. One of my activity codes is FMI and I would like to create a report, by cloning one of the standard reports, which shows all of the completed activities with this code. Can anyone help me with the code for the filter please?

This code works for pending activities but I want completed.

cal->rectype>" ".and.cal->rectype<>"H".and.char(cal->accountno,1)<>"Q".and.cal->accountno=contact1->accountno.and.cal->actvcode="FMI"


Thank you in advance for any help or suggestions.
View user's profile Send private message

PostPosted: Tue Oct 28, 2014 7:49 am Points: 0 Reply with quote
DJ
GoldMine Guru
Joined: 29 Jun 2006
Posts: 2055
Location: Fitchburg, MA, USA




I don't see any reason why this wouldn't work:

ContHist->accountno=contact1->accountno.and.ContHist->actvcode="FMI"

_________________
DJ Hunt

Phone: (978)342-3333
Email: DJ@DJHunt.US

GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

Filter for a report
  ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin