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!

Search results for query: *

  1. Butlertl

    Select Statemant

    This is my select statement {844_Helpdesk_to_SLA_measurement.Last Resolved Date} in {?Date Range} and {844_Helpdesk_to_SLA_measurement.Status} in ["Resolved", "Closed"] and not {@Exclude} and not ({844_Helpdesk_to_SLA_measurement.Assigned Group} in ["Secure Voice"]) and...
  2. Butlertl

    Select Statemant

    CR 10. I need a report for all tickets closed and determine the percentage of tickets that meet the metric. SVTTitle = "Response to Service, Silver" or "Response to Service, Gold", or "Response to Service, Platinum" MeasurementStatus = "Missed" or Met" The problem: A new version of Remedy...
  3. Butlertl

    Select Statemant

    It is either a select or counting....If I cannot select the records I need without multiple then I need to count just the first entry in the list.......
  4. Butlertl

    Select Statemant

    INC000000019497 Call Center, Response to Service, Silver Met Call Center, Response to Service, Silver Missed Call Center, Response to Service, Silver Met Call Center, Response to Service, Silver Missed In this example I would want to count the first "MET" and ignore the remaining entries Thanks
  5. Butlertl

    Select Statemant

    The fields would be "Call Center, Response to Service, Silver" and the next Field would be "MET" or "MISSED".....I need to count the number missed but would need to count the first instance.....is that possible?
  6. 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...
  7. Butlertl

    Linking Remedy Tables

    Yes......they do. Any chance this could be an ODBC issue?
  8. Butlertl

    Linking Remedy Tables

    Oh...yes...individual reports run without a problem....any field I put in the report will print....
  9. Butlertl

    Linking Remedy Tables

    Negative....nothing displays......test data using an access database works fine...I am thinking it's the setup here with our network
  10. Butlertl

    Linking Remedy Tables

    It did not work......I think my process is corrupted. I have reprots from each table that provides data. The INCIDENT NUMBER is a string (15).....I created a report with HPD_survey_join with field in the report returning data. I then, added the HPD_Help_Desk table aith the above link......and...
  11. Butlertl

    Linking Remedy Tables

    I reversed the LINK....going from HPD_help_Desk to Survey_join...my select statement is LAST RESOLVED DATE in DATE RANGE SELECT "844_HPD_Survey_join"."Last Name", "844_HPD_Survey_join"."Incident Number", "844_HPD_Survey_join"."Contact Sensitivity", "844_HPD_Survey_join"."Status"...
  12. Butlertl

    Linking Remedy Tables

    I have the Help Desk table linked using Incident Number with a Left Outer Join with Enforced From...when I add a field to the report from the Help Desk table all data from the HPD_survey_join is removed.
  13. Butlertl

    Linking Remedy Tables

    SELECT "844_HPD_Survey_join"."Last Name", "844_HPD_Survey_join"."Incident Number", "844_HPD_Survey_join"."Contact Sensitivity", "844_HPD_Survey_join"."Status", "844_HPD_Survey_join"."Score", "844_HPD_Survey_join"."Survey Pass/Fail", "844_HPD_Survey_join"."SR_Q8", "844_HPD_Survey_join"."SR_Q1"...
  14. Butlertl

    Linking Remedy Tables

    I know I am missing something in the execution.....I would like to select using the resolved date in the HPD_Help_desk and link it via Incidence Number to the survey that weas returned in the HPD_survey_join.
  15. Butlertl

    Linking Remedy Tables

    #1: HPD_survey_join #2: HPD_Help_desk
  16. 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...
  17. Butlertl

    If OR Statement

    It worked. Thanks again.
  18. Butlertl

    If OR Statement

    Thanks
  19. Butlertl

    If OR Statement

    Sorry...this is the statement: If {HPD_Help_Desk.CallCenterResponsePlatinumMetric}= "Pass" or {HPD_Help_Desk.CallCenterResponseGoldMetric}= "Pass" or {HPD_Help_Desk.CallCenterResponseSilverMetric}= "Pass" Then 1 Else 0
  20. 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...

Part and Inventory Search

Back
Top