Search results for query: *

Thanks Ken, I appreciate it. Dave

Hi Ken, Sorry for the delayed response--I was out of town for a week. I actually think that I may want the same answer as for ms1746. I need a running total for hours per activity, so we can get the total hours per month spent on an activity. Could you send me the response that you sent to...

Hi Ken, This is what I have so far to convert it to a number: Val ({CONTHIST.DURATION}) if isnull ({CONTHIST.DURATION}) then &quot;<null>&quot; else if {CONTHIST.DURATION} = &quot;&quot; then &quot;<blank>&quot; else {CONTHIST.DURATION} if {CONTHIST.DURATION} like &quot;*:*:*&quot; then...

Hi Ken, Wasn't sure how to use the VAL function--never done it before. I just went in and saw that all the data is inconsistent. It is in **:**:** format but some people were using the two right colums for seconds and others were using them for minutes, and others were typing things in. Dave

Thanks Ken, I am now running into two problems: 1. The data is not consistent and 2. I'm having problems converting the string to number. Can you help? I'm pretty new at this. Dave

I am using Crystal Reports 8.5 I have a report that uses a cross tab to count the number and types of appointments that our trainers have with our clients within a specified time (usually monthly). So it looks like this: Initial Training: 3 Follow-Up Training: 3 Travel: 5...

This is great too. Thanks. donodm

Works great. Thanks Ibass. donodm

I wrote two formulas to organize the columns of a cross tab report buy quarter and month (Crystal 8.5). Month: if {CONTHIST.ONDATE} in Date (2003, 01, 01) to Date (2003, 01, 31) then 'Jan' else if {CONTHIST.ONDATE} in Date (2003, 02, 01) to Date (2003, 02, 28) then 'Feb' else if...