Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by donodm

  1. donodm

    Running Total

    Thanks Ken, I appreciate it. Dave
  2. donodm

    Running Total

    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...
  3. donodm

    Running Total

    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...
  4. donodm

    Running Total

    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
  5. donodm

    Running Total

    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
  6. donodm

    Running Total

    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...
  7. donodm

    Sort By Month

    This is great too. Thanks. donodm
  8. donodm

    Sort By Month

    Works great. Thanks Ibass. donodm
  9. donodm

    Sort By Month

    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...
See more

Part and Inventory Search

Back
Top