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: Butlertl
  • Content: Threads
  • Order by date
  1. Butlertl

    Select Statemant

    I have a field, "TITLE" that can have one of 5 different titles...the problem is that "Call Center, Response to Service, Silver" can be entered for the same ticket number several times.....I need to select the record for the first entry.......the date it was entered is not available.....any...
  2. Butlertl

    Linking Remedy Tables

    I have two Remedy 7.1 tables/views....One table has customer survey data with the Ticket number....the second table is the master table with all ticket information including the ticekt number. I have a report with the survey data in the report....when I link the HELP DESK table, and then add a...
  3. Butlertl

    If OR Statement

    This is the statement but I am not getting any data....ie: when it should show a one I am getting blanks. If {HPD_Help_Desk.CallCenterResponsePlatinumMetric}= "Pass" or {HPD_Help_Desk.CallCenterResponseGoldMetric}= "Pass" or {HPD_Help_Desk.CallCenterResponseSilverMetric}= "Pass" or Then 1 Else...
  4. Butlertl

    Remedy 7 connecting two databases

    Ticket number are INCIDENT_NUMBER (string 15) in the HelpDesk database and APPLICATIONUSERFRIENDLYID (string 80) in the SLM_Measurement database...I am trying to LINK the two with these fields without success.....could it be the field size not matching? Thanks Terry
  5. Butlertl

    Select Data from Work Log

    I have a work log/memo field that begins with 4/9/2009 3:46:26 PM terry.butler Reportable changed to: No I need to select all records that include the name xxxxxx.xxxxxx in the work log. I would provide about 30 names that should match for record selection...... What is the best way to...
  6. Butlertl

    Suppress if not a Multiple Record

    My requirement is to pull all remedy tickets, for a particular week, and that have multiple tickets for a single customer. I have combined the Last Name and First Name and created a group based on the combined names..... I used an INSERT Summary and a Count on each customer name. I also...
  7. Butlertl

    Select Statement

    Crystal 10 or 11 I have a list of customers with Remedy Ticekts...I need to select only those tickets where the customer opened multiple tickets during one day....and I need to search for a past 12 month period. Any ideas? Thanks to all. Terry
  8. Butlertl

    v10 Select Statement minus 8 hours

    I currently have a report with a select statement as follows: {OAO_HDSP_Support.Last Modified Date/Time} < CurrentDate - 1 I need to select data not touched within 8 hours.....I believe I need DATEDIFF but the solution eludes me...... Thanks
  9. Butlertl

    Possible Issue with IF THEN

    After then IF Then statement....all after DAYS * are being ignored....what am I doing wrong? WhileReadingRecords; NumberVar Days := {@Work Day}; // The field that calculates your business days TimeVar SetStart := TimeValue( "6:00"); // The start your work day TimeVar SetEnd :=...

Part and Inventory Search

Back
Top