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 TouchToneTommy 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: *

  • Users: CLKCLK
  • Content: Threads
  • Order by date
  1. CLKCLK

    Group Footer Date Formula

    Hello- I am trying to expand on a report I already have to show how much time Tier2 works on a ticket. There are two action_ids that can happen HD_Close (this means they closed the ticket) & WO_Open (this means they escalated the ticket to Tier3. I have the formula working to get the time the...
  2. CLKCLK

    Suppress fields to Export to Excel

    I have a report that is looking at table.details and showing a starttime or endtime based on criteria in the formula. Here are the formulas. @startime WhilePrintingRecords; DateTimeVar BeginDate; if {table.Details.Action ID} = "HD_FRWD_GROUP" then BeginDate :={table.Details.Date}; @endtime...
  3. CLKCLK

    timedate conversion to time

    I have a timedate field that I just want see the time portion of. Is there a way to convert it. Example. 8:14:56 AM 2/24/2010. I just want the 8:14:56 AM portion. Thanks
  4. CLKCLK

    Timestamp prior to Business Hours, but need to know business hours

    I am working on a report that need to calculate the number of business hours between two dates. The problem that I am running into is the first date is the datestamp of the email or voicemail so that can come in at any time of the day. But the SLA doesn't begin until our business hours start...
  5. CLKCLK

    Sort of Database Fields in Field Explorer

    Is there anyway to sort the database field names in Field Explorer? I am using Crystal Reports Developer version 11. I know in XI R2 you can sort the fields, but I can't find the option in version 11. CK
  6. CLKCLK

    Duplicate records in Count

    I am working with a Magic database used for Help Desk Ticketing. I am trying to get a count of closed tickets by our tier2 help desk without being sent to Tier 3. I say without being sent to Tier3 because when an issue is escalated to Tier 3 a work order is created. After the Work Order is...
  7. CLKCLK

    Calculating Days, Hours, Minutes, Seconds between two times

    I realized I posted this in the wrong section so I am reposting it here. I am trying to calculate the DAYS:HH:MM:SS: between 2 timedate fields <startdatetime> - <enddatetime> = <tickettime>. (So if a ticket was opened on Friday at 4:00:00 pm and closed at 8:30:00 am on Monday the time elapsed...
  8. CLKCLK

    Calculate Business hours between time

    I am trying to calculate the DAYS:HH:MM:SS: between 2 timedate fields <startdatetime> - <enddatetime> = <tickettime>. (So if a ticket was opened on Friday at 4:00:00 pm and closed at 8:30:00 am on Monday the time elapsed would be 0 days 1 hour 30 minutes 0 seconds.) The problem I am having is...

Part and Inventory Search

Back
Top