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!

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

Search results for query: *

  1. christinetjx

    Help create If/then formula (i think!) in Crystal 8.5

    I am using Crystal 8.5 and need assistance with a formula. I am trying to create a report that displays helpdesk calls grouped by assignment. There are many assignment groups in this company, but I only want to see 3 groups: Calls closed on Initial (in other words, calls not escalated) Calls...
  2. christinetjx

    Crystal 8.5 - Need help with formula that add/subracts

    I have a report that displays total calls logged by a Hotline, grouped first by Month, then Assignment (where the calls were escalated to). The first assignment group listed is 'Closed on Initial' (calls closed right away). The remainder assignment groups display below that. So it looks like...
  3. christinetjx

    Crystal 8.5 - Need help creating formula to hide data

    I have created a report displaying calls logged to a Helpcenter. The calls are grouped by assignment. Calls closed immediately by the Helpcenter are listed first as 'Closed on Initial'. I use the following formula (from lbass) to get this info: If isnull ({incidentsa3.assignment}) or...
  4. christinetjx

    Crystal 8.5 - Need help modifying date/time formula

    I would like to display the amt of time passed between a call being opened, then closed. I would like this displayed in days, hrs, minutes: (i.e., 2 days, 3 hrs 10 mins) i found the (wonderful!) formula posted in faq767-3543, so i'm halfway there; i just need help fine-tuning. Below is that...
  5. christinetjx

    Cystal 8.5 - Need help wi/formula (or Running Total) - Not sure which!

    I would appreciate any help with the following: i have created a report that displays the # of calls logged each day, by the hour. For example: 1/2/05 6am 4 calls 7am 8 8am 10 9am 6 1/3/05 6am 2 calls 7am 4 8am 2 9am 1 i am trying to create a formula...
  6. christinetjx

    Crystal 8.5 Grouping calls by the Hour

    Somewhere in this forum, i did find a similar question and that is where i got pieces of the formula i have posted below. I work in a call center and would like to create a report that displays the number of calls logged by the hour. So total calls on 12/1/04 between 6am - 7am would display...
  7. christinetjx

    Crystal 8.5 - problem using Null in formula

    I have only run into this problem since upgrading to 8.5. I run a report that displays closed hotline tickets sorted by assigned groups, i.e.: Desktop 18 Remote Support 23 Infrastructure 14 My problem: Sometimes tickets are closed without being assigned to...

Part and Inventory Search

Back
Top