I would like to create a report with this report filter to obtain data.
ucfreqcode <> contains information detailing how often to contact a client either by a phone call or setup a meeting.
(e.g. S1M__C__M__C translates to semi-annual meetings for Jan, Jul and calls on Apr, Oct)
month1 <> the month I want to process (e.g. 3 March)
.if.char(contact2->ucfreqcode,(2+(int(word(dlg->month1,1)))))
="C".or.char(contact2->ucfreqcode,(2+(int(word(dlg->month1,1)))
))="M"
The above filter works but when I wish to add
.else..if.month(Cal->Ondate) = int(word(dlg->month1,1))
it fails, saying "too many field nanes, operators or functions".
I wish to add this logic so that I can also add to the report any schecduled calls for the month.
It appears that I can code the logic as individual reports but GoldMine can not handle them combined. My user desires only one report to work with, any suggestions.
ucfreqcode <> contains information detailing how often to contact a client either by a phone call or setup a meeting.
(e.g. S1M__C__M__C translates to semi-annual meetings for Jan, Jul and calls on Apr, Oct)
month1 <> the month I want to process (e.g. 3 March)
.if.char(contact2->ucfreqcode,(2+(int(word(dlg->month1,1)))))
="C".or.char(contact2->ucfreqcode,(2+(int(word(dlg->month1,1)))
))="M"
The above filter works but when I wish to add
.else..if.month(Cal->Ondate) = int(word(dlg->month1,1))
it fails, saying "too many field nanes, operators or functions".
I wish to add this logic so that I can also add to the report any schecduled calls for the month.
It appears that I can code the logic as individual reports but GoldMine can not handle them combined. My user desires only one report to work with, any suggestions.