Member
|
I would like to know this as well. I'm looking for what I am missing- if there's a timer, and even the phone notes feature- there is then a corresponding way to see a tabulation/summary/graph/report of the results of the note-taking or timing- for a day, a week, a month, or a year- but how? i.e. how many notes per week? how many calls per day? month? total time of all calls for the week? etc. is it accessed through the graphing or reports better?
|
| |
|
Member
|
It seems there's not really much on this, Feejo. I'm trying to figure out why you would have a timer function, and then not be able to report on it, or graph it...
|
| |
|
Master

|
I switch to Max 9. There is Crytal Report. I woulder if into note or something else there is the data we are looking for into DatabaseExpert? Ultimatly I would do a report for a particular opportunity that will calculate all timed + all phone time for a customer. That will tell me total time passed on a customer, maby after I would be able to tell how much time I have pass over the phone into a year, how much time on working on customer for sale, for service. 
Running maximizer 9 since February 17, 2006, with QB link.
|
| |
| Posts: 132 | Location: Montreal Canada. | Registered: December 24, 2005 |    |
|
Master

|
Here's a sample to get you started: The following Crystal Reports formula field (Basic syntax) will extract the duration (hours, minutes, seconds) from a timed note and convert it to seconds. Dim a, i, j, hh, nn, ss
a = "Duration: "
i = InStr({NOTES.Text}, a) + Len(a)
j = InStr(i, {NOTES.Text}, ":")
hh = Mid({NOTES.Text}, i, j - i)
i = j + 1
nn = Mid({NOTES.Text}, i, 2)
i = i + 3
ss = Mid({NOTES.Text}, i, 2)
formula = (Val(hh)*3600) + (Val(nn)*60) + Val(ss)
|
| |
| Posts: 725 | Location: Canada | Registered: July 14, 2000 |    |
|
Master

|
>but when I enter that formula? In the Crystal Report. Search the CR help for details on formula fields, or check out http://www.e-reporting.cafor information about CR training.
|
| |
| Posts: 725 | Location: Canada | Registered: July 14, 2000 |    |
|
New Member
|
Gord, that looks like VB. Is it actually VB . NET or a derivative of it?
|
| |
|