Search results for query: *

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

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

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

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

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?

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

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

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

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

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

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

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.

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

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.

#1: HPD_survey_join #2: HPD_Help_desk

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

It worked. Thanks again.

Thanks

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

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